Advanced Functions in Spreadsheets (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
AND function purpose
AND function purpose
Checks if ALL specified conditions are true
OR function purpose
OR function purpose
Checks if AT LEAST ONE condition is true
#N/A error meaning
#N/A error meaning
Function cannot find the value it's looking for
ROUND function rounding rule
ROUND function rounding rule
0.5+ rounds up, below 0.5 rounds down
ROUNDUP function behavior
ROUNDUP function behavior
Always rounds numbers towards higher value
ROUNDDOWN function behavior
ROUNDDOWN function behavior
Always rounds numbers towards lower value
SUMIF function purpose
SUMIF function purpose
Adds values that meet a specific condition
COUNTIF function purpose
COUNTIF function purpose
Counts cells that meet a specific condition
SUMIFS vs SUMIF difference
SUMIFS vs SUMIF difference
SUMIFS checks multiple criteria, SUMIF checks one
Subtotal feature first step requirement
Subtotal feature first step requirement
Sort data by the field you want to group by