NEW
Font size
WorksheetsExcel Skills Lesson 1-6
Total questions: 10
Worksheet time: 5mins
Why are formulas useful in spreadsheets?
They make cells colourful
They calculate automatically and reduce errors
They replace raw data
They format text
What does an arithmetic formula do?
Changes how numbers look
Performs calculations using operators
Creates graphs
Restricts user choices
Which symbol must every formula start with?
+
−
=
*
Which operator is used to multiply values?
+
−
*
/
Why should cell references be used instead of typing numbers into formulas?
It looks neater
Values update automatically if data changes
It adds formatting
It prevents saving
What happens when a relative cell reference is copied?
It stays fixed
It updates automatically
It deletes the formula
It locks the value
Which reference is an example of an absolute cell reference?
A1
A$1
$A$1
$A1$
Why is absolute referencing useful?
To change formatting
To lock a value when copying formulas
To create charts
To add data validation
Which Excel feature helps add a list of values quickly?
LOOKUP
Conditional Formatting
Autosum
Data Validation
Which Excel skill is MOST important for calculating totals accurately?
Formatting cells
Using graphs
Using formulas with correct cell references
Changing colours
