Font size
Worksheets[ICT] - Revision Quiz Unit 3
Total questions: 22
Worksheet time: 18mins
What is formula bar used for?
To type a formula
To make the project works
To make the computer work
To create disney land
what is a cell?
Currency, time, date, percentage, text, scientific
One box in the spreadsheet
Several worksheets made up
The line around the cell
What is a column?
One sheet in a spreadsheet
collection of cells going along in a straight line
collection of cells going down the screen
A visual representation of data
How to multiply in spreadsheets?
(D12*A7)
(D8/B7)
(D6 - C5)
(E8+A2)
What is a spreadsheet?
A document with data, which is arranged in rows and columns
The address is made of two part ( row position and column position)
One sheet in a spreadsheet
A visual representation of data
What are gridlines?
the line around the cell
collection of cells going along in a straight line
where you type a formula
collection of cells going down the screen
Write a formula for VLOOKUP with the code L8,O8:P20,2
how to subtract
(D6 - C5)
(D8/B7)
(E8+A2)
(D12*A7)
If you wanted to change the colour of the text inside a cell, which tool would you use?
Font color
Fill color
Borders
Bold
This tool gives the selected text (a) effect
This tool is used to _________ the selected text.
Bold face
Colour
Highlight
Underline
If you wanted to change the size of the text inside a cell which tool would you use?
Cell width
Cell height
Text colour
Font size
What is the name of the spreadsheet package we have been using?
Google Slides
Microsoft Word
Microsoft Excel
Microsoft Access
What does a spreadsheet NOT contain?
Rows
Columns
Cells
Word Art
What feature of a spreadsheet allows text to fill a cell up?
Wrapped Text
Format Text
Merged Text
Trapped Text
A cell can contain text, values and what else?
Currency
Percentages
Formulae
Dates
What are spreadsheets used for?
To perform powerful calculations
Make graphs and charts
Analyse patterns in the data
To store information and data
