WorksheetsY8 Revision Assessment
Total questions: 15
Worksheet time: 8mins
In Excel, how can you quickly format numbers to display a dollar sign ($) before them?
Type $ manually before each number
Use the Format Cells option and choose Currency
Press Ctrl + $ on the keyboard
Change the cell color to green
To start writing a formula in Excel or Numbers, which symbol should you type first?
#
@
=
$
Which formula is used in Excel or Numbers to find the sum of the values in cells A1 through A5?
=ADD(A1:A5)
=TOTAL(A1:A5)
=SUM(A1:A5)
=PLUS(A1:A5)
What is the main purpose of the SUM function in Excel?
To count the number of cells
To multiply numbers
To add numbers together
To average numbers
If you type =SUM(A1:A10) in Excel, what will it do?
Count how many cells contain numbers in A1 to A10
Add all the numbers from cell A1 to A10
Display the largest number in A1 to A10
Add only the first and last numbers in the range
If cell A1 = 5, A2 = 10, and A3 = 15, what will =SUM(A1:A3) return?
25
30
15
5
Which formula is used in Excel or Numbers to find the product (multiply) of the numbers in cells A1 through A3?
=MULTIPLY(A1:A3)
=PRODUCT(A1:A3)
=SUM(A1:A3)
=ADD(A1:A3)
What does the COUNTA function do in Excel?
Counts only empty cells in a range
Counts all non-empty cells in a range, including text and numbers
Counts only numeric values in a range
Adds all numbers in a range
If cells A1 = 10, A2 = “Hello”, A3 = blank, A4 = 25, what will =COUNTA(A1:A4) return?
1
2
3
4
Which formula should you use in the Result column to display “Pass” if the score is greater than or equal to 60, otherwise display “Fail”?
=IF(A2>60,"Fail","Pass")
=IF(A2>=60,"Pass","Fail")
=IF(A2<=60,"Pass","Fail")
=IF(A2<60,"Pass","Fail")
What will be the result of the formula =IF(B2>=50,"Pass","Fail") if B2 contains 80?
Pass
Fail
50
Error
Which of the following formulas will display “Good” if the score in A2 is 90 or above, otherwise display “Try Again”?
=IF(A2>90,"Try Again","Good")
=IF(A2>=90,"Good","Try Again")
=IF(A2<90,"Good","Try Again")
=IF(A2=90,"Try Again","Good")
In the formula =IF(A2>=60,"Pass","Fail"), what happens if A2 is empty?
Displays "Pass"
Displays "Fail"
Displays 0
Displays an error
Which formula checks if A2 is greater than 70 and displays “Excellent”, otherwise displays “Needs Improvement”?
=IF(A2>70,"Needs Improvement","Excellent")
=IF(A2>=70,"Needs Improvement","Excellent")
=IF(A2>70,"Excellent","Needs Improvement")
=IF(A2<70,"Excellent","Needs Improvement")
What is the correct syntax for the SUMIF function?
=SUMIF(range, criteria, sum_range)
=SUMIF(criteria, range, sum_range)
=SUMIF(sum_range, criteria, range)
=SUMIF(range, sum_range, criteria)
