WorksheetsSpreadsheet
Total questions: 19
Worksheet time: 10mins
Each page on a spreadsheet is called what?
A book
A worksheet
A sheet
Write a formula to work out the lowest possible number in the Total Cost of ingredients column
(a)
Complete the sentence below using the correct word:
A spreadsheet can ____________ for particular items of data
Program
Search
The lines on a spreadsheet are called what?
Sheet lines
Gridlines
Borders
Complete the following sentence using the correct word:
A formula tells the computer to _____ data held in specific cells
Program
Process
What does rows start with?
Letters
Numbers
Nothing
Write the formula to work out the total cost of the potion
(a)
Choose the correct formula to work out the total cost of the human eyeball
=B6*C6
B6*C6
=SUM(B6:C6)
What does merging cells do?
It links up two different cells together
It combines the selected cells together to form one big cell
It copies and pastes the information from one cell to another
When you click on a cell that cell is then called the?
Active cell
Inactive cell
Highlighted cell
When creating a graph the X axis goes which way?
Vertical up the side of the graph
Horizontal across the bottom of the graph
When labelling your graph which way does the Y axis go?
Vertical up the side of the graph
Horizontal across the bottom of the graph
What formatting has been applied to the text in row 7 of the spreadsheet?
The font size has been increased
The font has been made bold
The font colour has been changed
What is the symbol for multiplication?
+
/
-
*
What is the cell reference for the animal that lives in the desert?
(a)
What animal is carnivorous and lives in the woods?
(a)
How has the text in column B been aligned?
Centred
Left aligned
Right aligned
What must all formulas begin with?
=
-
:
()
A business would use a spreadsheet for what?
Advertisement
Calculating cost of stock
Keeping records of customers' addresses
