Spreadsheets: Formulas, Functions & Graphs is one of 9 topics in the Grade 11 Computer Applications Technology CAPS syllabus, covered across 3 lessons on Study Vault. Below are real practice questions from this topic with full worked answers.
Sample practice questions
Easy
1. Which spreadsheet function adds together a range of numbers?
SUM
AVERAGE
COUNT
MAX
Answer: SUM — SUM is the simplest and most commonly used spreadsheet function, adding together a range of numbers.
Easy
2. Which function returns the current date, automatically updating whenever the spreadsheet is reopened?
TODAY
SUM
MAX
COUNT
Answer: TODAY — The TODAY function returns the current date and automatically updates whenever the spreadsheet is reopened or recalculated.
Medium
3. Give the name of the function that calculates the mean (average) of a range of numbers.
Answer: AVERAGE — The AVERAGE function calculates the mean of a range of numbers.
