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

Symbol that must start all spreadsheet formulas

Equals sign (=)

Spreadsheet operator for addition

Spreadsheet operator for subtraction

Spreadsheet operator for division

/ (forwards slash)

Spreadsheet operator for multiplication

• (asterisk)

BODMAS acronym meaning

Brackets, Of, Division, Multiplication, Addition, Subtraction

Purpose of brackets in spreadsheet formulas

Override BODMAS order, control which calculations happen first

Result of $8-2 \times 2$ following BODMAS

4 (multiply first: $2 \times 2=4$, then subtract: $8-4=4$)

Result of $(A1+A2) \times 3$ when $A1=8$, $A2=3$

33 (brackets first: $8+3=11$, then multiply: $11 \times 3=33$)

Benefit of using cell references in formulas

Formulas automatically update when data changes