WorksheetsExcel Skills Quiz
Total questions: 30
Worksheet time: 15mins
What is Microsoft Excel mainly used for?
Writing letters
Creating presentations
Organising and calculating data
Editing images
What is a spreadsheet made up of?
Slides
Pages
Rows and columns
Paragraphs
What is the name of a single box in Excel?
Row
Column
Cell
Table
What does a cell reference tell you?
The file name
The cell’s location
The formula used
The font style
Which is a correct cell reference?
2B
B2
Cell2
RowB
What symbol must all formulas start with in Excel?
+
=
*
#
Which of these is a formula?
A1+A2
SUM(A1,A2)
=A1+A2
A1,A2
Why are formulas useful in Excel?
They change colours automatically
They update when data changes
They remove errors
They save files
What does the SUM function do?
Multiplies numbers
Adds numbers together
Sorts data
Counts text
Which formula would add cells A1 to A5?
=A1+A5
=ADD(A1:A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
What is a worksheet?
A single cell
A page in a spreadsheet file
A chart
A formula
Why are multiple worksheets useful?
They increase file size
They organise data into sections
They add formatting
They stop formulas working
What must you select before creating a chart?
The worksheet name
The file
The correct data
The printer
Which chart type is best for comparing values?
Pie chart
Bar chart
Line graph
Scatter graph
Which chart shows parts of a whole?
Bar chart
Line graph
Pie chart
Table
Why should charts have titles?
To make them colourful
To explain what the chart shows
To increase marks
To fill space
What does formatting do in Excel?
Changes calculations
Improves appearance and readability
Deletes data
Creates formulas
Which formatting feature makes headings stand out?
Borders
Bold
Fill colour
Italics
What does sorting data do?
Deletes rows
Changes formulas
Arranges data in order
Formats cells
Which order would help find the largest number quickly?
Alphabetical
Random
Smallest to largest
Largest to smallest
What does copying a formula usually do?
Changes the formula completely
Adjusts cell references automatically
Deletes data
Locks the formula
What is a common use of multiplication in Excel?
Formatting text
Calculating totals
Creating charts
Sorting data
What should you do if a formula gives the wrong answer?
Ignore it
Delete the spreadsheet
Check the formula and data
Restart Excel
What does it mean to reference a cell?
Rename it
Use it in a formula
Format it
Lock it
Why should data be laid out neatly in Excel?
To increase file size
To make it easier to read and understand
To stop errors
To speed up saving
What does a table help you do?
Delete data
Organise and analyse data
Write text
Create images
What should you check before submitting an Excel file?
Colours only
File name only
Formulas and data accuracy
Font size only
Why is Excel useful in school and work?
It replaces all software
It helps manage and analyse data
It is only for maths
It is only for business
Which of the following is NOT an Excel feature?
Formulas
Charts
Worksheets
Slides
Which statement best describes Excel skills?
Typing quickly
Using data to solve problems
Drawing pictures
Writing essays
