Spreadsheets: Basics, Functions & Charts is one of 9 topics in the Grade 10 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. What does a cell reference such as B4 identify?
A specific cell, combining its column letter and row number
An entire worksheet
A type of chart
A network device
Answer: A specific cell, combining its column letter and row number — A cell reference identifies one specific cell by combining its column letter and row number, for example B4.
Easy
2. Every spreadsheet formula must begin with which symbol?
An equals sign (=)
A colon (:)
A hash (#)
A dollar sign ($)
Answer: An equals sign (=) — Basic calculations in a spreadsheet are performed using formulas, which always start with an equals sign.
Medium
3. A cell contains the formula =B2+B3. If B2 contains 15 and B3 contains 27, what value will the formula display?
Answer: 42 — The formula adds the values in B2 and B3 together: 15 + 27 = 42.
