Spreadsheet Fundamentals and Interface
This domain tests whether you can navigate a spreadsheet application confidently and understand how the file, the sheet, and the cell relate to one another. Questions typically ask you to identify what a UI element shows, predict the result of a navigation shortcut, or explain why a workbook behaves unexpectedly.
Workbook and worksheet anatomy
- A workbook is the file; worksheets are tabs inside it. A cell address combines the column letter with the row number (A1), a rectangular range uses a colon (A1:C10), and whole-column or whole-row references are written A:A and 1:1.
- The Name Box displays the active address and accepts typed addresses or defined names, so typing B47 moves the cursor there directly.
- The Formula Bar shows what is stored in the cell, not what is displayed. Select a cell holding a long date or a truncated text string and read the bar to see the real content.
- Ribbon tabs can be contextual: table and chart tools appear only while the relevant object is selected, which is why a missing tab usually means nothing is selected.
Navigation and selection
- Ctrl+Arrow jumps to the edge of the current contiguous data block; adding Shift extends the selection to that edge instead of moving.
- Ctrl+End lands on the last used cell. If it lands far below your data, cells in between carry formatting, and that stray range will affect printing and pivot ranges.
- Shift+click extends a selection, Ctrl+click adds non-adjacent cells, and Ctrl+A inside a data block selects the whole block.
Worked example
You must select every cell from A1 to the end of a table without dragging. Click A1, then press Ctrl+Shift+End. Reasoning: Ctrl+End identifies the last used cell, and Shift converts that jump into a selection endpoint. If the selection includes empty rows under the table, the diagnostic is that those cells are formatted and therefore count as used.
Traps that cost marks
- Confusing displayed value with stored value: a cell showing 12.35 may still store 12.3456, and totals use the stored number.
- Believing Delete removes a worksheet; it clears contents, while removing a tab requires right-click Delete or Hide.
- Forgetting that saving as CSV keeps only the active sheet.