Introduction to Functions in Spreadsheets (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 formulas and functions in spreadsheets?
What is the key difference between formulas and functions in spreadsheets?
Formulas use operators; functions use ranges
What must every function and formula begin with?
What must every function and formula begin with?
An equals sign (=)
In the function =SUM(B3:B9), what is B3:B9 called?
In the function =SUM(B3:B9), what is B3:B9 called?
The argument
What does the colon (:) do in a function like =SUM(B5:B11)?
What does the colon (:) do in a function like =SUM(B5:B11)?
Creates a reference to a range of cells
Which function would you use to add all values in a range of cells?
Which function would you use to add all values in a range of cells?
SUM
What does the COUNT function do?
What does the COUNT function do?
Counts how many cells contain numbers
What symbol represents the AutoSum button in spreadsheets?
What symbol represents the AutoSum button in spreadsheets?
Σ (Sigma)
What does the #NAME! error indicate?
What does the #NAME! error indicate?
You've misspelt the function name
How do you separate multiple arguments in a function?
How do you separate multiple arguments in a function?
With commas or semicolons
What are the three essential parts of function syntax?
What are the three essential parts of function syntax?
Equals sign, function name, arguments