Which of the following external references is correct for a workbook and worksheet that have no spaces?

(TCO 5) When multiple worksheets are selected the word ________ appears in th Show more Question 1.1. (TCO 5) When multiple worksheets are selected the word ________ appears in the title bar. (Points : 2) Select Group Set Cluster Question 2.2. (TCO 5) In Excel which of the following would you perform to group nonadjacent worksheets? (Points : 2) Click the first tab hold Shift and then click the last tab. Click the first tab hold Ctrl and then click last tab. Right-click a worksheet tab then select Select All Sheets. Right-click a worksheet tab then select Group. Question 3.3. (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 Question 4.4. (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. Question 5.5. (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces? (Points : 2) [New.Jersey.xlsx]Qtr4!B6 [New.Jersey.xlsx]Qtr4!B6 [New.Jersey.xlsx]Qtr4!B6 [NewJersey.xlsx]Qtr4!B6 Question 6.6. (TCO 5) Which formula would return the #NAME? error? (Points : 2) =SUM(B6.B12) =MAX(B6:B12) =AVG(B6:B12) =IF(A6=AtlantaA30) Question 7.7. (TCO 5) Which of the following is the proper use of a 3D formula? (Points : 2) =SUM(Yr1:Yr5!C7) =SUM(Yr1-Yr5!C7) =SUM(Yr1:Yr5!C7) =SUM(Yr1:Yr5!C7) Question 8.8. (TCO 6) A one-variable data table must have at least ________ blank row(s) and ________ blank column(s) between the dataset and the data table. (Points : 2) two two two one one two one one Show less

QUICK QUOTE

Approximately 250 words