Spreadsheet and Presentation
Spreadsheet and Presentation
This domain tests cell references, formulas, functions, charts and slide delivery. Questions often require predicting a result after fill-down or distinguishing a transition from an animation.
Core rules
- A cell address combines column and row, e.g. B4. A range is A1:A5. Every formula starts with =; text is left-aligned by default, numbers right-aligned.
- Relative references (A1) change when copied; absolute references ($A$1) stay fixed; mixed references lock one part ($A1 or A$1).
- Common functions: SUM adds, AVERAGE divides by count of numeric cells, COUNT counts numbers, COUNTA counts non-empty cells, IF returns one value or another based on a condition.
- In presentations, a transition affects how one slide changes to the next; an animation affects objects on a slide. Slide Master controls repeated layout/theme. F5 starts from the first slide; Shift+F5 starts from the current slide.
Worked example
In B1 enter =IF(A1>=40,"Pass","Fail"). If A1 is 40, B1 shows Pass. Reasoning: >= includes equality, so 40 meets the condition. If copied down to B2, A1 becomes A2 because the reference is relative; =$A$1 would keep A1 fixed.
Traps
COUNT ignores text; COUNTA includes it. A formula without = is treated as text. $A$1 locks both column and row. Animation is not transition. Deleting a chart series differs from deleting the chart. AVERAGE ignores blank cells but counts zeros.