Cell References & Formulas
What is a formula in Excel?
A mathematical equation used to calculate values using cell data.
What button is used to quickly total a column of numbers?
The Sum Button (Σ).
What is Normal View in Excel?
The default worksheet view without print layout indicators.
What is the print area?
The specific range of cells selected to print.
You want your column headers to repeat on each printed page. What tool should you use?
Print Titles.
What is a relative cell reference?
A cell reference that changes when copied to another cell (A1)
What does the fill handle do?
Copies formulas or extends patterns into adjacent cells.
What does Page Layout View show?
How the worksheet will appear when printed.
What are print titles?
Rows/columns that repeat on each printed page.
You need to calculate a budget where the cost in one cell multiplies across rows. Which reference is best?
Absolute Cell Reference.
What is an absolute cell reference?
A fixed reference that does not change when copied ($A$1).
What is the order of evaluation in Excel?
The sequence Excel follows to calculate a formula (PEMDAS).
What does Page Break Preview allow you to do?
Adjust where printed pages will break.
Why is setting print titles useful?
Ensures column/row headers are visible on every page.
You notice your table cuts off when printed. What view will help you adjust this?
Page Break Preview.
What is a mixed cell reference?
One part is absolute, the other is relative (like $A1 or A$1).
What is an operator in Excel?
A symbol that performs a calculation (e.g., +, -, *, /).
What feature automatically applies colors, icons, or data bars to cells based on their values? This helps enhance storytelling to emphasize important data.
Conditional Formatting
What does Freeze Panes do?
Keeps selected rows/columns visible while scrolling.
You want to scroll while keeping the first row visible. What should you use?
Freeze Panes.
What is the point-and-click method?
Selecting cells for a formula by clicking instead of typing.
What is an operand in Excel?
The values or cell references used in a formula (5, A1)
What is the Split tool used for?
To divide the worksheet into panes for scrolling independently.
Where can you find the Freeze Panes tool?
Under the View tab > Freeze Panes dropdown.
A teacher asks you to calculate GPA by quarter with a function that autofills. What should you use?
A formula with the Fill Handle.