Functions in Spreadsheets (Grade 10 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Functions in spreadsheets
Functions in spreadsheets
Built-in tools that automate complex calculations
Symbol required to start all functions
Symbol required to start all functions
Equals sign (=)
Three components of function syntax
Three components of function syntax
= sign, function name, arguments in parentheses
Arguments in functions
Arguments in functions
Info functions need: cells, ranges, or specific numbers
SUM function purpose
SUM function purpose
Adds all values in a range
AVERAGE function purpose
AVERAGE function purpose
Calculates the mean (average) of values
COUNT function purpose
COUNT function purpose
Counts how many cells contain numbers
AutoSum feature
AutoSum feature
Quick way to insert common functions (Σ button)
#NAME! error meaning
#NAME! error meaning
Misspelt function name
#DIV/0! error meaning
#DIV/0! error meaning
Dividing by zero or an empty cell