Functions (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Operators vs functions in spreadsheets
Operators vs functions in spreadsheets
Operators: symbols for basic calc; Functions: pre-built formulas
What does * operator do?
What does * operator do?
Multiplies values together
What does >= operator test?
What does >= operator test?
If value is greater than or equal to another
Purpose of SUM function
Purpose of SUM function
Adds all values in a specified range
What AVERAGE function calculates
What AVERAGE function calculates
Mean value by adding numbers & dividing by count
Difference: COUNT vs COUNTA
Difference: COUNT vs COUNTA
COUNT: only numbers; COUNTA: all non-empty cells
What IF function does
What IF function does
Tests condition & returns results based on true/false
Cause of #### error
Cause of #### error
Column too narrow to display full number
Cause of #DIV/0 error
Cause of #DIV/0 error
Dividing by zero or empty cell
Cause of #NAME error
Cause of #NAME error
Misspelled function name