More Advanced Functions (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
When does the AND function return TRUE?
When does the AND function return TRUE?
When ALL conditions are true
When does the OR function return FALSE?
When does the OR function return FALSE?
When all conditions are false
What commonly causes the #N/A error?
What commonly causes the #N/A error?
Lookup value doesn't exist in data range
How does ROUND handle the value 0.5?
How does ROUND handle the value 0.5?
Rounds up to 1
What does ROUNDDOWN(7.8, 0) return?
What does ROUNDDOWN(7.8, 0) return?
7
In SUMIF, what does the sum_range parameter specify?
In SUMIF, what does the sum_range parameter specify?
The cells to add up
What does COUNTIF count?
What does COUNTIF count?
Cells meeting a specific condition
When should you use SUMIFS instead of SUMIF?
When should you use SUMIFS instead of SUMIF?
When checking multiple criteria
What must you do before using the Subtotal feature?
What must you do before using the Subtotal feature?
Sort data by the grouping field
How should text criteria be formatted in functions?
How should text criteria be formatted in functions?
In quotation marks