WorksheetsHomework 3 Spreadsheets
Total questions: 10
Worksheet time: 5mins
Which of the following is NOT a way formatting has been applied to the spreadsheet shown in the image?
Bold text for headings
Different font sizes
Cell shading
Animated transitions
How can you display the formulae in a spreadsheet application like Excel?
By clicking "Formulas" and selecting "Show Formulae"
By pressing Ctrl + ~ (tilde)
By double-clicking any cell
By right-clicking and choosing "Display Formula"
Which formula would you use to find the maximum percentage mark achieved by any student in the spreadsheet?
=MAX(H2:H6)
=SUM(H2:H6)
=AVERAGE(H2:H6)
=MIN(H2:H6)
If you want to sort the data in descending order in Excel, which menu option should you use?
Filter
Sort Z to A
Sort A to Z
Find and Replace
Suppose you want to analyze which student improved the most from Test 1 to Test 3. What would be a good approach to determine this using the spreadsheet?
Subtract Test 1 marks from Test 3 marks for each student and compare the results
Add all test marks together for each student
Only look at the percentage column
Use the SUM formula on Test 1 marks
Which option should you select to sort data in descending order of percentage in a spreadsheet?
Order: A to Z
Order: Z to A
Order: Oldest to Newest
Order: Smallest to Largest
What is the purpose of the "Logical_test" field in the IF function arguments box in a spreadsheet?
To specify the value if the condition is true
To specify the value if the condition is false
To enter the condition that will be evaluated
To sort the data in the spreadsheet
If you want to insert the word "Distinction" in column H for any percentage greater than or equal to 75, which value should you enter in the "Value_if_true" field of the IF function?
"Pass"
"Distinction"
"Fail"
"Merit"
Which logical test would correctly check if a percentage in column H is greater than or equal to 75 in a spreadsheet formula?
H1 < 75
H1 = 75
H1 >= 75
H1 > 75
You are given a list of student percentages in a spreadsheet. How would you use the IF function to label students with "Distinction" if their percentage is 75 or above, and leave the cell blank otherwise? Choose the correct formula.
=IF(H1 >= 75, "Distinction", "")
=IF(H1 < 75, "Distinction", "")
=IF(H1 = 75, "Distinction", "")
=IF(H1 > 75, "", "Distinction")
