WorksheetsSpreadsheet Formula
Total questions: 15
Worksheet time: 23mins
What is the cell reference of the Yellow cell?
A1
C4
B3
C3
To change the Cell Colour of the cell you would click...
A
B
C
D
In a cell reference, such as B2, what does the number stand for?
the column the cell is in
the worksheet the cell is in
the row the cell is in
the value of the cell
Mathematical calculations in a spreadsheet are called:
words
values
formulas
labels
What is the name of the spreadsheet package we have been using?
Google Slides
Microsoft Word
Microsoft Excel
Microsoft Access
A spreadsheet program is used to store data in:
a database.
a text document.
rows and columns.
letters and numbers.
Which of the following is an example of a cell reference?
Column C
=SUM
Row 1
A5
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculations in an organized way
To excel your written work
Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta
£1.25 times 12
C5*D5
=C5*D5
To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?
Item
Price
Number Sold
Total
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
