【单选题】在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.C...
【单选题】在Excel工作簿中,执行下列代码后,sheet1工作表B8单元格的值是 。Sub 分段()For i = 2 To 10 Step 3 Sheet1.Cells(i, 1) = 8 * i Select Case Sheet1.Cells(i, 1) Case 0 To 30, 48 Sheet1.Cells(i, 2) = Sheet1.Cells(i, 1) + 10 Case 30 To ...