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

📚Flashcards
Basic Calculations with Spreadsheets
Sign up to keep revising.Create a free account to study more flashcards and track your progress.

Practise the cards

10 cards from this deck

Show

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×28-2 \times 2 following BODMAS

4 (multiply first: 2×2=42 \times 2=4, then subtract: 8−4=48-4=4)

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

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

Benefit of using cell references in formulas

Formulas automatically update when data changes

Join 100,000+ NSC Matric students studying Flashcards with us.

Select your subjects, and get access to A+ resources today.