Basic Calculations with Spreadsheets (Grade 10 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What must all spreadsheet formulas begin with?
What must all spreadsheet formulas begin with?
An equals sign (=)
Which symbol is used for multiplication in spreadsheets?
Which symbol is used for multiplication in spreadsheets?
- (asterisk)
Which symbol is used for division in spreadsheets?
Which symbol is used for division in spreadsheets?
/ (forward slash)
What does the 'B' in BODMAS stand for?
What does the 'B' in BODMAS stand for?
Brackets
Calculate:
Calculate:
4
Calculate:
Calculate:
40
What is the main purpose of brackets in formulas?
What is the main purpose of brackets in formulas?
Override BODMAS order
Why do people use spreadsheets instead of word processors for calculations?
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?
If A1=8 and A2=3, what does =(A1+A2)*3 calculate?
33
What is the benefit of using cell references in formulas?
What is the benefit of using cell references in formulas?
Formulas update automatically