math 3

Prévia do material em texto

18/09/2026, 19:19 Free Printable Excel Multiple Worksheets 6. What is the purpose of grouping worksheets in Excel? a) To calculate formulas across multiple b) To change the formatting of multiple worksheets. worksheets at once. c) To create a summary report of data from d) To organize and manage related data or multiple worksheets. information. 7. How can you ungroup worksheets in Excel? a) Right-click on any worksheet tab and select b) Press the 'Ctrl' key and click on each 'Ungroup Sheets' from the context menu. worksheet tab to select them, then right-click and choose Sheets'. c) Go to the 'View' tab and click on Ungroup d) Double-click on any worksheet tab. Sheets'. 8. What happens to the grouped worksheets when you apply formatting or insert data in Excel? a) The changes are applied to a random b) The changes are applied to all the grouped worksheet in the group. worksheets. c) The changes are only applied to the first d) The changes are not applied to any worksheet in the group. worksheet in the group. 9. What is the maximum number of worksheets that can be grouped together in Excel? a) 255 b) 100 c) 500 d) 1000 10. What is the shortcut key to switch between grouped worksheets in Excel? a) Ctrl + Shift + PgUp or Ctrl + Shift + PgDn b) Alt + PgUp or Alt + PgDn c) Ctrl + PgUp or Ctrl + PgDn d) Ctrl + Tab or Ctrl + Shift + Tab 11. The cell reference to cell C3 on the worksheet called 'Sales' looks like this: a) ='Sales'!C3 b) =C3!'Sales' c) =!'Sales'C3 d) =Sales!C3 2/3