WorksheetsYear 8 Spreadsheets Retrieval 6
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
In Google Sheets, which of the following would correctly add the values in cell A1 and cell B1?
a)
A1+B1=
b)
SUM(A1,B1)
c)
A1 plus B1
d)
=A1+B1
2.
You want to find the total score of all students listed in cells C2 through C10. Which function would you use?
a)
AVERAGE(C2:C10)
b)
SUM(C2:C10)
c)
MIN(C2:C10)
d)
MAX(C2:C10)
3.
To find the highest test score from a range of scores in cells D2 to D8, which function should you use?
a)
MAX(D2:D8)
b)
AVERAGE(D2:D8)
c)
SUM(D2:D8)
d)
MIN(D2:D8)
4.
Which function would you use to find the lowest price from a list of prices in cells E2 through E5?
a)
MAX(E2:E5)
b)
AVERAGE(E2:E5)
c)
MIN(E2:E5)
d)
SUM(E2:E5)
5.
You want to calculate the average of the numbers in cells F1, F2, and F3. Which function should you use?
a)
MIN(F1:F3)
b)
SUM(F1:F3)
c)
MAX(F1:F3)
d)
AVERAGE(F1:F3)
6.
In Google Sheets, you want cell G1 to display "Pass" if the value in cell H1 is greater than or equal to 70, and "Fail" otherwise. Which function would you use in cell G1?
a)
LOOKUP(H1>=70, "Pass", "Fail")
b)
IF(H1>=70, "Pass", "Fail")
c)
OR(H1>=70, "Pass", "Fail")
d)
AND(H1>=70, "Pass", "Fail")
7.
You have a table where student names are in column A and their ID numbers are in column B. If you know a student's name is in cell C1, which function could you use in cell D1 to find their ID number?
a)
VLOOKUP(C1, A:B, 2, FALSE)
b)
SUM(A:B, C1, 2, FALSE)
c)
IF(C1, A:B, 2, FALSE)
d)
AVERAGE(A:B, C1, 2, FALSE)
8.
To make the text in cell A1 bold, which formatting option would you typically use?
a)
Changing the background color.
b)
Changing the font size.
c)
Applying a border.
d)
Clicking the "B" icon in the formatting toolbar.
9.
You want to display a list of prices in dollars and cents (e.g., $12.50). Which type of number formatting would you apply to the cells containing the prices?
a)
Plain text
b)
Percentage
c)
Currency
d)
Scientific
10.
You have a list of dates in column A. To change the way these dates are displayed (e.g., from 2025-10-12 to 10/12/2025), you would need to adjust the:
a)
Text color.
b)
Cell alignment.
c)
Number format.
d)
Font style.
100 %
