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)