Managing Worksheets
Worksheet structure
A workbook contains one or more worksheets (tabs). You must be able to insert, rename, move, copy, delete and hide/unhide sheets, and change tab colour. Copying a sheet can create a duplicate within the workbook or move it to another workbook. A common trap: deleting a sheet removes its data permanently (undo may not restore it after saving), and a hidden sheet is still part of the file and still calculates.
Referencing across sheets
Formulas can reference other sheets using the syntax SheetName!Cell. If a sheet name contains spaces, wrap it in single quotes: 'Sales 2024'!B2. A 3-D reference like SUM(Jan:Dec!B2) totals the same cell across a range of sheets. Questions frequently test the exclamation mark and the quoting rule.
Grouping and reorganising
You can select multiple sheets (Ctrl+click or Shift+click) to enter data or apply formatting to all at once - but remember to ungroup afterwards, or edits will hit every grouped sheet. Use Move or Copy to reorder tabs and to duplicate a sheet with its formulas intact.
Freezing and splitting
Freeze Panes keeps row/column headings visible while scrolling; Split divides the window into panes. Traps: freezing at the wrong cell freezes the wrong rows/columns (freeze below and to the right of the headings you want to keep), and freezing affects the view, not the print layout.
Rule of thumb
When a question involves data from another sheet, look for the ! separator; if the name has a space, expect single quotes. When reorganising, ask whether the task should affect one sheet or all grouped sheets.
Worked example
To total B2 on three sheets named Jan, Feb, Mar: =Jan!B2+Feb!B2+Mar!B2 or =SUM(Jan:Mar!B2).