NEW
Font size
WorksheetsExcel Data & Formatting lesson 1
Total questions: 10
Worksheet time: 5mins
What does raw data mean in Excel?
Data created using formulas
Data typed directly into cells
Data shown in charts
Data copied from another file
Which tool is best for entering numbers efficiently?
Mouse
Keyboard letters
Numerical keypad
Touchpad
What does formatting cells change?
The calculation
The formula
How the data looks
The data source
Which format would you use to show money?
Number
Percentage
Currency
Date
If 6.478 is formatted to 1 decimal place, what will display?
6
6.4
6.5
7
Where can you find Format Cells?
Insert tab
Right-click menu
View tab
Review tab
Which is an example of formatting?
Adding a formula
Changing 10 to 20
Adding a £ symbol
Deleting data
What happens to the value when formatting is applied?
It changes
It stays the same
It deletes
It doubles
Which ribbon tab contains number formatting tools?
Data
Insert
Home
View
Why is formatting important?
Makes data colourful only
Helps data be clearer to read
Changes calculations
Removes errors
