NEW
Font size
WorksheetsSpreadsheet Final Test
Total questions: 29
Worksheet time: 15mins
Which function is used to add numbers in a range?
=ADD(A1:A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
=COUNT(A1:A5)
What will =AVERAGE(10, 20, 30) return?
20
30
15
25
Which function returns the smallest number in a range?
=MAX(A1:A10)
=MIN(A1:A10)
=LOW(A1:A10)
=AVERAGE(A1:A10)
If cells A1 to A5 contain 5, 8, 2, 10, 7, what is the result of =MAX(A1:A5)?
10
7
5
8
Which function counts only numeric values in a range?
=COUNTA(A1:A10)
=COUNT(A1:A10)
=COUNTNUM(A1:A10)
=SUM(A1:A10)
If cells A1 to A3 contain: 4, 6, "Hello", what is the result of =COUNTA(A1:A3)?
2
3
4
Error
What is the correct formula to find the average of cells B1 to B4?
=AVG(B1:B4)
=AVERAGE(B1:B4)
=MEAN(B1:B4)
=SUM(B1:B4)/COUNT(B1:B4)
What will =IF(A1>50, "Pass", "Fail") return if A1 is 60?
Fail
Pass
60
TRUE
Which formula finds the largest value between 3, 15, and 9?
=LARGE(3,15,9)
=MAX(3,15,9)
=BIGGEST(3,15,9)
=TOP(3,15,9)
If you want to count all non-empty cells in a range, which function should you use?
=COUNTA()
=COUNT()
=COUNTIF()
=SUM()
What is Conditional Formatting used for in spreadsheets?
To change the data values
To change the appearance of cells based on a condition
To delete empty cells
To merge cells
Which of these is NOT an example of Conditional Formatting?
Automatically highlighting cells with values above 100
Making text bold when a value is less than 50
Changing cell background color when the cell is empty
Adding a border to all cells manually
You want cells to turn red if the value is less than equal 10. Which comparison operator should you use?
>
=
<
<=
If you apply Conditional Formatting to highlight sales above $500, what happens when a value changes from $400 to $600?
The cell stays the same
The cell changes color based on the rule
The cell is deleted
The cell text changes to bold automatically
Which option would you choose to remove Conditional Formatting from a range?
Delete cell contents
Clear rules
Hide cells
Remove formulas
In IGCSE exams, why might Conditional Formatting be useful for analyzing large data sets?
It makes numbers smaller
It helps you see patterns or trends quickly
It sorts the data automatically
It changes all formulas to text
Which of these rules is valid for Conditional Formatting?
Cell Value is greater than 50
Cell Font = Arial
Cell Background = Blue
Merge Cell if greater than 100
What happens if two Conditional Formatting rules conflict?
Both rules apply at the same time
The one with higher priority applies
The spreadsheet gives an error
The cell turns white
If you want to highlight weekends in a timetable automatically, which Conditional Formatting feature could you use?
Icon Sets
Date formatting rules
Data validation
Merge & Center
A student wants to highlight the top 3 scores in a list. Which Conditional Formatting option is best?
Highlight Cells Rules → Greater Than
Top/Bottom Rules → Top 10 Items
Use a formula
Data Bars
What does the IF function do in a spreadsheet?
Adds numbers together
Checks a condition and returns one value if TRUE and another if FALSE
Finds the largest value in a range
Sorts data in alphabetical order
Which of the following is the correct syntax for an IF function?
=IF(test, true_value, false_value)
=IF(true_value, false_value, test)
=IF(test; true_value; false_value)
=IF(true_value; test; false_value)
If the formula is =IF(A1>50, "Pass", "Fail") and A1 contains 45, what will it display?
Pass
Fail
45
Error
In the formula =IF(A2=100, "Perfect", "Not Perfect"), what does A2=100 represent?
The true value
The false value
The logical test
The cell reference
Which formula will return “High” if B1 is greater than 500, otherwise “Low”?
=IF(B1>500, "High", "Low")
=IF(B1=500, "Low", "High")
=IF(B1<500, "High", "Low")
=IF(B1>=500, "Low", "High")
If you want to use IF to check if C1 is empty, which formula is correct?
=IF(C1="", "Empty", "Not Empty")
=IF(C1, "Empty", "Not Empty")
=IF("Empty", C1="", "Not Empty")
=IF(C1=0, "Empty", "Not Empty")
Which operator is used to check “greater than or equal to” in IF conditions?
>
=
<
>=
What will happen if the logical test in an IF function is FALSE?
It returns the TRUE value
It returns the FALSE value
It gives an error message
It changes the formula automatically
You want to display “Bonus” if sales are more than $1000, otherwise display nothing. Which is correct?
=IF(Sales>1000, "Bonus", "")
=IF(Sales>1000, Bonus, "")
=IF(Sales>=1000, "", "Bonus")
=IF(Sales>1000, "", Bonus)
