WorksheetsExcel PreTest
Total questions: 20
Worksheet time: 23mins
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
Complete the sentence using the correct word from the options below. A spreadsheet can (_____) for particular items of data
Program
Search
Save
The lines on a spreadsheet are called what?
Gridlines
Borders
Sheet lines
Complete the following sentence using the correct word from the options below. A formula tells the computer to (____) data held in specific cells
Program
Process
Function
When referring to cells - what do rows start with?
Letters
Numbers
Nothing
Write the formula to calculate the total cost of a spell
Choose the correct formula to work out the total cost of a human eyeball
=B6*C6
B6*C6
=sum(B6:C6)
What does merging cells do?
It combines the selected cells to form one big cell
It copies and pastes the information from one cell to another
It links up two different cells together
When you click on a cell that cell is then called the.....
Inactive cell
Active cell
Highlighted cell
When labeling 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
Choose the correct formula to work out the total cost of the spells
=SUM(B4:B8)
=SUM(D4:D8)
=SUM(C4:C8)
=Sum(D4:D8)
What is the symbol for multiplication?
+
/
*
What is the Cell Reference for the animal that lives in the desert?
What animal is carnivorous and lives in the woods?
How has the text in column B been aligned?
Centred
Left aligned
Right aligned
What must all formulas begin with?
When creating a graph the X axis goes which way?
Vertical up the side of the graph
Horizontal across the bottom of the graph
A business that uses a spreadsheet, could be using it for...
creating an advertisement
calculating the cost of stock
keeping records of customers addresses
