【简答题】在Excel工作簿中,执行下列代码后,sheet1工作表B7单元格的值 是 。 Sub 分段() For i = 1 To 10 Sheet1.Cells(i, 1) = 8 * I Select Case Sheet1.Cells(i, 1) Case 0 To 30 Sheet1.Cells(i, 2) = Sheet1.Cells(i, 1) + 10 Case 30 To 70 Sheet...
【简答题】在Excel工作簿中,执行下列代码后,sheet1工作表B7单元格的值是 。 Sub 分段() For i = 1 To 10 Sheet1.Cells(i, 1) = 8 * i Select Case Sheet1.Cells(i, 1) Case 0 To 30 Sheet1.Cells(i, 2) = Sheet1.Cells(i, 1) + 10 Case 30 To 70 Sheet1...
【简答题】在Excel工作簿中,执行下列代码后,sheet1工作表B6单元格的值是【1】 Sub 分段() For i = 1 To 10 Sheet1.Cells(i, 1) = 8 * i Select Case Sheet1.Cells(i, 1) Case Is < 30 Sheet1.Cells(i, 2)=Sheet1.Cells(i, 1) + 10 Case Is < 7...