Overview of Formulas (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
What a cell reference tells Excel
What a cell reference tells Excel
Which cell to use in a formula
How to indicate a cell range
How to indicate a cell range
Colon (:) between start and end cell refs
Excel calculation order acronym
Excel calculation order acronym
BPEPMD
What brackets do in formulas
What brackets do in formulas
Control the order of calculations
Character that starts all formulas
Character that starts all formulas
Equals sign (=)
What ###### error indicates
What ###### error indicates
Column too narrow or negative date/time
What #NAME? error indicates
What #NAME? error indicates
Unrecognised text or misspelled function
What #DIV/0! error indicates
What #DIV/0! error indicates
Division by zero or empty cell
What #REF! error indicates
What #REF! error indicates
Invalid cell reference (deleted cells)
#VALUE! error meaning
#VALUE! error meaning
Mixed data types that can't work together