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 )