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
What is the key difference between operators and functions?
What is the key difference between operators and functions?
Operators are symbols; functions are formulas
What do comparison operators return as results?
What do comparison operators return as results?
TRUE or FALSE
What does the COUNT function count in a spreadsheet?
What does the COUNT function count in a spreadsheet?
Only cells with numerical values
What causes a #NAME error in a spreadsheet?
What causes a #NAME error in a spreadsheet?
Misspelling a function name
What does the #### error indicate?
What does the #### error indicate?
Column is too narrow to display number
What does the COUNTBLANK function do?
What does the COUNTBLANK function do?
Identifies empty cells
What causes a #DIV/0 error?
What causes a #DIV/0 error?
Dividing by zero or an empty cell
Which symbol represents 'not equal to' in spreadsheets?
Which symbol represents 'not equal to' in spreadsheets?
<>
What does the SUMIF function do?
What does the SUMIF function do?
Adds values meeting specific criteria
What does a #VALUE! error indicate?
What does a #VALUE! error indicate?
Calculations on inappropriate data types