More Functions (Grade 10 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 COUNT and COUNTIF functions?
What is the key difference between COUNT and COUNTIF functions?
COUNT counts all; COUNTIF counts by criteria
What is the correct basic syntax for a COUNTIF function?
What is the correct basic syntax for a COUNTIF function?
=COUNTIF(range, criteria)
What does =COUNTIF(D3:D13,2) do?
What does =COUNTIF(D3:D13,2) do?
Counts cells in D3:D13 containing exactly 2
What must you use when searching for text values in COUNTIF functions?
What must you use when searching for text values in COUNTIF functions?
Quotation marks
What happens if you omit quotation marks around text in COUNTIF?
What happens if you omit quotation marks around text in COUNTIF?
Text is treated as a cell reference
What does the <> relational operator mean?
What does the <> relational operator mean?
Not equal to
What does =COUNTIF(E3:E19,">1") count?
What does =COUNTIF(E3:E19,">1") count?
Cells in E3:E19 with values greater than 1
What effect does cell formatting have on actual cell values?
What effect does cell formatting have on actual cell values?
None; formatting only changes display
What keyboard shortcut opens the Format Cells dialogue box?
What keyboard shortcut opens the Format Cells dialogue box?
Ctrl+1
What does the increase decimal button on the ribbon do?
What does the increase decimal button on the ribbon do?
Adds one more decimal place each click