NEW
Font size
WorksheetsExcel Skills Quiz (Lessons 1–5)
Total questions: 10
Worksheet time: 5mins
What is the main purpose of using formulas in Excel?
To change how data looks
To calculate values automatically
To create charts
To restrict user input
Which symbol must every Excel formula begin with?
+
−
=
*
Which operator is used to multiply values in a formula?
+
−
*
/
Why should cell references be used instead of typing numbers into formulas?
They look better
They update automatically when data changes
They add formatting
They prevent errors completely
What does an arithmetic formula do?
Formats cells
Performs calculations using numbers or cell references
Creates graphs
Restricts data entry
What happens if a value used in a formula changes?
The formula stops working
The total updates automatically
The data is deleted
The formatting resets
Which Excel feature is best for adding a column of numbers quickly?
LOOKUP
Autosum
Conditional Formatting
Data Validation
Which type of cell referencing changes when a formula is copied?
Absolute referencing
Fixed referencing
Relative referencing
Locked referencing
Which is an example of a correct Excel formula?
A1 + A2
=A1 + A2
+A1A2
SUM(A1 A2)
Why is accuracy important when calculating costs in a spreadsheet?
To improve formatting
To make graphs clearer
To support correct decisions and planning
To reduce file size
