Basic Calculations with Spreadsheets (Grade 10 NSC Matric Computer Application Technology): Quizzes

What must all spreadsheet formulas begin with?

An equals sign (=)

Which symbol is used for multiplication in spreadsheets?

• (asterisk)

Which symbol is used for division in spreadsheets?

/ (forward slash)

What does the 'B' in BODMAS stand for?

Brackets

Calculate: $8-2 \times 2$

4

Calculate: $5 \times (6+2)$

40

What is the main purpose of brackets in formulas?

Override BODMAS order

Why do people use spreadsheets instead of word processors for calculations?

Perform calculations automatically

If A1=8 and A2=3, what does =(A1+A2)*3 calculate?

33

What is the benefit of using cell references in formulas?

Formulas update automatically