Manage worksheets and workbooks
The Manage worksheets and workbooks domain tests whether you can bring external data in, navigate a workbook, control how sheets and windows display, prepare print output, and protect or distribute a file. The exam favors exact command paths and the effect of each option, not just the feature name.
Import and navigate
- Data > From Text/CSV opens Power Query; choose delimiter, data types, and Load To. You can load to an existing worksheet at a chosen cell, a new worksheet, a table, or the data model/PivotTable.
- F5 or Ctrl+G opens Go To; the Name Box accepts a defined name or cell address. Ctrl+F finds values or formulas, and hyperlinks can jump to a location in the document.
Sheets, views, and print
- Insert, delete, rename, move, copy, and hide sheets; set tab color from the sheet tab shortcut menu.
- Freeze Panes freezes everything above and left of the active cell. Split creates draggable panes.
- Page Layout > Print Titles repeats entire rows or columns; Print Area limits what prints; Scale to Fit, margins, and headers/footers control layout.
- Protect Sheet restricts cell editing; Protect Workbook restricts structure/windows; Mark as Final is advisory only; Encrypt with Password restricts opening; Inspect Document removes hidden metadata and comments.
Worked example
You import sales.csv into an existing workbook and need the header row repeated on every printed page. Load the CSV to cell A4 on a new sheet, confirm the first row contains headers, then use Page Layout > Print Titles > Rows to repeat at top = $1:$1. If you freeze at A2, row 1 stays visible on screen, but that is not a print setting; print titles are separate.
Traps
Freezing at the wrong cell freezes unintended rows/columns. Print Titles must be whole rows or columns, not a multi-range. Hiding a worksheet does not delete it. CSV files strip formatting and formulas. Protect Workbook and Protect Sheet block different things.