Advanced Formulas and Functions (Grade 11 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 symbol must all Excel formulas begin with?
What symbol must all Excel formulas begin with?
Equal sign (=)
What is the key difference between formulas and functions in Excel?
What is the key difference between formulas and functions in Excel?
Functions are pre-built, formulas are custom
How many built-in functions does Excel contain?
How many built-in functions does Excel contain?
Over 400
What does Formula Intellisense do when you type functions?
What does Formula Intellisense do when you type functions?
Suggests functions & shows syntax info
What does =ROUND(894.7, -3) return?
What does =ROUND(894.7, -3) return?
1000
How does rounding differ from formatting in Excel?
How does rounding differ from formatting in Excel?
Rounding changes stored value
What alternative symbol can replace the POWER function?
What alternative symbol can replace the POWER function?
Caret (^)
Which function counts cells with any type of information?
Which function counts cells with any type of information?
COUNTA
What does =SMALL(A1:A16, 4) find?
What does =SMALL(A1:A16, 4) find?
4th smallest value in range
Why should you use cell references instead of typing numbers in functions?
Why should you use cell references instead of typing numbers in functions?
Makes spreadsheets more flexible