WorksheetsY9 Assessment Revision
Total questions: 14
Worksheet time: 7mins
What formula do you type to calculate the total scores for a student?
=Average
=Sum
=Max
=Min
What formula do you type to calculate the Average scores for a student?
=SUM
=Average
=Max
=Min
In Excel, which formula will calculate the product (multiplication) of the numbers in cells B2 through B5?
=SUM(B2:B5)
=MULTIPLY(B2:B5)
=PRODUCT(B2:B5)
=B2*B3*B4*B5
Which formula returns the largest number in cells C1 to C5?
=MAX(C1:C5)
=LARGEST(C1:C5,1)
=BIGGEST(C1:C5)
=MAXIMUM(C1:C5)
What does the formula =COUNT(E1:E10) do?
Adds all numbers in E1 to E10
Counts the number of numeric values in E1 to E10
Finds the average of values in E1 to E10
Counts all cells in E1 to E10, including text
If the range A1:A5 contains the values: 12, “Hello”, 45, “Excel”, 78, what will =COUNT(A1:A5) return?
5
3
2
0
Which function should you use to count all non-empty cells, including text and numbers?
COUNT
COUNTA
COUNTIF
SUM
The COUNT function will ignore which of the following?
Numbers
Dates
Text
Decimal values
Which of the following is the correct syntax of the SUMIF function in Excel?
=SUMIF(range, sum_range, criteria)
=SUMIF(criteria, range, sum_range)
=SUMIF(range, criteria, sum_range)
=SUMIF(sum_range, range, criteria)
Which of the following formulas correctly adds sales in column C where the region in column A is "North"?
=SUMIF(C:C,"North",A:A)
=SUMIF(A:A,"North",C:C)
=SUMIF("North",A:A,C:C)
=SUMIF(A2:A10,C2:C10,"North")
In the formula =SUMIF(A2:A8, "<=100", B2:B8), what does the criteria "<=100" mean?
Greater than 100
Equal to 100 only
Less than or equal to 100
Not equal to 100
Which formula correctly adds values in C2:C10 where B2:B10 equals “Completed”?
=SUMIF(C2:C10,"Completed",B2:B10)
=SUMIF(B2:B10,"Completed",C2:C10)
=SUMIF("Completed",B2:B10,C2:C10)
=SUMIF(B:B,C:C,"Completed")
What does the formula =SUM(B2:B6) do in Excel?
Multiplies the values in cells B2 to B6
Adds the values in cells B2 to B6
Finds the average of the values in cells B2 to B6
Counts the number of values in cells B2 to B6
In Excel, which formula will calculate the product (multiplication) of the numbers in cells B2 through B5?
=SUM(B2:B5)
=MULTIPLY(B2:B5)
=PRODUCT(B2:B5)
=B2*B3*B4*B5
