Spreadsheet Formatting (Grade 11 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 do formulas allow you to do in spreadsheets?
What do formulas allow you to do in spreadsheets?
Perform calculations & analyse data
What does the cell reference C14 mean?
What does the cell reference C14 mean?
Column C, row 14
Which range type is A1:A30?
Which range type is A1:A30?
Column range
What does the colon (:) indicate in cell ranges?
What does the colon (:) indicate in cell ranges?
From this cell to that cell
In order of operations, what does Excel calculate first?
In order of operations, what does Excel calculate first?
Brackets
What is the result of =5+2*3?
What is the result of =5+2*3?
11
What is the result of =(5+2)*3?
What is the result of =(5+2)*3?
21
What does the ###### error indicate?
What does the ###### error indicate?
Column too narrow to display numbers
What causes a #NAME? error?
What causes a #NAME? error?
Misspelled function name
What causes a #DIV/0! error?
What causes a #DIV/0! error?
Dividing by zero or empty cell