Right-click a worksheet tab, then select Select All Sheets. Right-click a worksheet tab, then select Group.
( TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.( Points: 2)
The letter B The number 2 The letter A The number 1
( TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet?( Points: 2)
Drag a split box Double-click a split box. Right-click in the active cell and click Split. Click Split in the Window group on the View tab.
( TCO 5) If a worksheet name has a space in it, ________ surround the worksheet name in the worksheet reference.( Points: 2)
Double quotation marks Single quotation marks Parentheses Brackets( TCO 5) Which formula would return the # NAME? error?( Points: 2) = SUM( B6. B12) = MAX( B6: B12) = AVG( B6: B12) = IF( A6 =” Atlanta”, A3,0)