Start learning →

Match each spreadsheet formula or function with its syntax rule:

A1-A, 2-B, 3-C
B1-B, 2-A, 3-C
C1-C, 2-B, 3-A
D1-A, 2-C, 3-B
Answer & Solution
Correct answer: A. 1-A, 2-B, 3-C
Formulas must start with =. SUM adds numbers. AVERAGE computes mean.
Practise this question with Quill — ICSE Class 8 →

Keep practising Spreadsheet Basics

Browse all Spreadsheet Basics questions for ICSE Class 8, or explore more Computer Applications topics.

Start a Spreadsheet Basics lesson →
Related questions
Match each spreadsheet data type with its default alignment in a cell:Match each spreadsheet cell reference type with its behavior when copied:Match each spreadsheet component with its standard grid definition:What is the column label for the final 16384th column in modern Excel?What condition is required for automatic recalculation in a sheet?What rule governs cell names within a single spreadsheet?In the mixed reference $A1, which coordinate is kept absolute?Where can a generated chart component be placed in a spreadsheet?