NEW
Font size
WorksheetsExcel Skills & Knowledge Test
Total questions: 30
Worksheet time: 15mins
What does “raw data” mean in a spreadsheet?
Data that changes automatically
Data typed in directly and does not change
Data shown in a graph
Data created using formulas
Which is an example of variable data?
A typed price
A fixed heading
A value that updates when a selection changes
A column title
What does formatting a cell change?
The calculation
The formula
How the number looks
The value stored in the cell
Which format would you use to show money?
Percentage
Decimal
Currency
Date
If the number 4.678 is formatted to 1 decimal place, what is shown?
4
4.6
4.7
5
Which tool automatically adds numbers together?
LOOKUP
Data Validation
Autosum
Conditional Formatting
Where do you find Data Validation in Excel?
Insert tab
Data tab
View tab
Home tab
What is the purpose of a drop-down list?
To calculate totals
To reduce spelling mistakes and control choices
To format cells
To create graphs
What does the LOOKUP function do?
Adds numbers
Sorts data
Finds a value and returns matching information
Formats cells
Which description best explains LOOKUP?
“Add these values together”
“Find this, then show the matching value”
“Change how numbers look”
“Highlight a cell”
What must a LOOKUP function use to work correctly?
A graph
A table of data
A chart title
A text box
Which symbol always starts a formula in Excel?
+
–
=
*
What is a cell reference?
A cell colour
A cell address like A1
A formula result
A worksheet name
What does conditional formatting do?
Deletes data
Changes values
Highlights cells based on rules
Creates formulas
Which formatting could show values in green if they meet a rule?
Currency
Autosum
Conditional formatting
Lookup
What is relative cell referencing used for?
Locking values
Copying formulas that adjust automatically
Creating graphs
Formatting text
What happens when you copy a relative formula down a column?
It stays the same
It deletes data
It updates cell references
It changes formatting
Why are graphs useful in Excel?
They store data
They replace formulas
They help present data visually
They calculate totals
What is the main purpose of a spreadsheet?
To draw pictures
To organise and analyse data
To write documents
To design websites
What does formatting change according to Paragraph 1?
The formula
The stored value
How data looks
The worksheet name
Which is an example of raw data from Paragraph 1?
A graph
A formula result
A typed price
A chart title
Why are functions useful?
They make spreadsheets colourful
They automate tasks and reduce errors
They delete incorrect data
They replace tables
Which function is used to quickly add numbers?
LOOKUP
FORMAT
Autosum
Validation
What does a lookup function search through?
Graphs
Tables
Charts
Text boxes
What is one benefit of drop-down lists?
They increase typing
They allow any value
They control user input
They calculate totals
What does conditional formatting help with?
Entering formulas
Highlighting important values
Creating tables
Printing worksheets
Why are graphs useful?
They store data
They calculate results
They make patterns easier to see
They format cells
Which tool helps prevent invalid choices?
Autosum
Graphs
Drop-down lists
Currency formatting
What improves spreadsheet design according to Paragraph 3?
Random colours
Clear structure and rules
Large text only
Fewer formulas
Which skill is most important for working accurately in Excel?
Guessing values
Typing quickly
Using tools correctly
Changing colours
