Menu

Formulas - Match-up

Match-up definitions and answers with key terms and examples. Press submit to check your answers.

Formula
Equals sign
Maths operator
Brackets
Order of calculation
Recalculation
Copying a formula down
Using cell references
Asterisk
Formula bar


Answers
The rule that decides which part of a calculation is worked out first, such as multiplying before adding.
Repeating the same calculation in the cells below so each row uses its own numbers.
An instruction typed into a cell that works out a calculation and shows the answer.
The automatic updating of a result when the value it uses in another cell is changed.
A symbol such as +, -, * or / used in a spreadsheet calculation to perform arithmetic.
The keyboard character * used in a calculation to multiply, as keyboards have no times sign.
The area near the top of the screen that shows the calculation entered in the selected cell.
Curved symbols placed around part of a calculation so that part is worked out first.
The symbol formed by two horizontal lines that starts every spreadsheet calculation.
Clicking or typing a cell address such as B4 into a calculation so that cell's value is used.
Log in or sign-up to access the match-up activity



Don't have a login?

You can still revise this topic