WorksheetsSpreadsheet Skills Quiz
Total questions: 30
Worksheet time: 15mins
What is a spreadsheet mainly used for?
Writing letters
Storing data and performing calculations
Drawing pictures
Playing games
Columns in a spreadsheet are labelled using:
Numbers
Symbols
Letters
Colours
Rows in a spreadsheet are labelled using:
Letters
Numbers
Shapes
Icons
What is the correct cell reference for column E, row 4?
4E
E4
EE4
4
What is the active cell?
The cell with the biggest number
The cell you last edited
The cell with a thick black border
The first cell in the spreadsheet
What is a label in a spreadsheet?
A number used in a calculation
A formula
Text used to describe data
A chart
What is a value in a spreadsheet?
A heading
A number you type in
A picture
A border
Which feature is used to separate data clearly in a table?
Zoom
Borders
Autofill
Freeze pane
Why is formatting (colour, bold, borders) useful?
It makes the spreadsheet larger
It makes data easier to read
It deletes mistakes
It changes values
Where should column headings usually be placed?
At the bottom
In the middle
At the top of the table
On a new sheet
What symbol must all formulas start with?
+
=
*
/
Which formula correctly adds cells A3 and B3?
A3+B3
=A3+B3
=A3B3
+A3B3
What happens when you change a value used in a formula?
The formula deletes
The answer updates automatically
The spreadsheet crashes
Nothing changes
Which symbol is used for multiplication in Excel?
x
×
*
÷
Which symbol is used for division in Excel?
/
÷
:
%
Which formula multiplies cell C2 by B2?
=C2+B2
=C2*B2
=C2/B2
=C2-B2
What is the Autosum tool used for?
Formatting cells
Adding text
Adding a range of values
Creating charts
Where should you place the Autosum result?
At the top of the spreadsheet
In an empty cell below or beside values
In a label cell
On a new worksheet
What happens if you forget the equals sign in a formula?
Excel fixes it
Excel treats it as text
Excel crashes
The cell turns red
Which formula would calculate 3 × 4?
=3+4
=34
3x4
34
What does copying a formula do?
Deletes the formula
Repeats the formula in another cell
Converts it to text
Changes the values
Why is using cell references better than typing numbers into formulas?
It looks nicer
It allows automatic updating
It uses less memory
It removes labels
Which task would best use a spreadsheet?
Writing a story
Tracking costs and profits
Drawing a logo
Editing a photo
Which of these is an example of good spreadsheet design?
No labels
Random colours
Clear headings and borders
Empty cells only
What should you do before sharing a spreadsheet?
Delete all data
Check formulas work correctly
Remove labels
Change font randomly
What does bold text usually show in a table?
Values
Errors
Headings
Borders
Which skill helps avoid calculation mistakes?
Formatting
Manual maths
Using formulas
Guessing
What is the main benefit of spreadsheets in real life?
They look colourful
They do calculations quickly and accurately
They replace computers
They stop errors completely
Which formula adds cells B2 to B6?
=B2+B6
=SUM(B2:B6)
=ADD(B2:B6)
=TOTAL(B2:B6)
What does a spreadsheet automatically do when data changes?
Deletes formulas
Updates linked calculations
Changes formatting
Locks cells
