WorksheetsTopic 1 (HW 1): Spreadsheets
Total questions: 15
Worksheet time: 9mins
"The exact location of a cell within a spreadsheet"
Cell Reference
Cell Location
Cell Area
What is the cell reference of the yellow cell?
B5
5B
An individual box/square within a spreadsheet is called a (a)
Select all correct cell references for the yellow cells
D3:F4
D3, E3, F3, D4, E4, F4
3D:4F
3D, 3E, 3F, 4D, 4E, 4F
Spreadsheets allow you to organise large amounts of data
True
False
Which of the following keyboard symbols is used to represent multiplication in a spreadsheet?
*
/
#
~
Spreadsheets cannot be used to carry out calculations
True
False
Select the correct formula to display the total of these two numbers in the yellow cell
=sum (B4 + C4)
=sum(4B + 4C)
sum (B4 + C4)
Select the correct formula to display the multiplication of these two numbers in the yellow cell
=sum (B4 * C4)
=sum(4B * 4C)
sum (B4 * C4)
Which keyboard symbol must be included at the beginning of a formula?
(a)
Which of the following formula would be used to find the smallest value?
=MIN
=MAX
=SUM
=COUNT
Which of the 2 COUNT functions only includes number values in its total?
=COUNT
=COUNTA
Which of the following formula will give the result of 13?
=MIN (B3:D5)
=MAX (B3:D5)
=SUM (B3:D5)
=COUNT (B3:D5)
Which of the following formula will give the result of 9?
=MIN (B3:D5)
=MAX (B3:D5)
=SUM (B3:D5)
=COUNT (B3:D5)
One of the most common uses for spreadsheets is to carry our complex calculations for the user
True
False
