Question 2 . Question : ( TCO 5 ) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets : the same formula is entered into all grouped worksheets . the formula changes by one row in each grouped worksheet . the formula changes by one column in each grouped worksheet . nothing happens to the other sheets .
Question 3 . Question : ( TCO 5 ) When two windows of the same workbook are opened , Excel adds _____ to the title bar of the second window . the letter B the number 2 the letter A the number 1
Question 4 . Question : ( TCO 5 ) In Excel , which of the following is NOT a method for splitting a worksheet ? 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 .
Question 5 . Question : ( TCO 5 ) Which of the following external references is correct for a workbook and worksheet that have no spaces ? "[ New . Jersey . xlsx ] Qtr4 !" B6 '[ New . Jersey . xlsx ] Qtr4 !' B6 [ New . Jersey . xlsx ] Qtr4 !, B6 [ NewJersey . xlsx ] Qtr4 ! B6
Question 6 . Question : ( TCO 5 ) Which formula would return the # NAME ? error ? = SUM ( B6 . B12 ) = MAX ( B6 : B12 ) = AVG ( B6 : B12 )