More Functions (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
COUNTIF function purpose
COUNTIF function purpose
Counts cells meeting specific conditions/criteria
COUNT vs COUNTIF key difference
COUNT vs COUNTIF key difference
COUNT counts all numbers; COUNTIF counts by conditions
COUNTIF syntax structure
COUNTIF syntax structure
=COUNTIF(range, criteria)
COUNTIF text criteria requirement
COUNTIF text criteria requirement
Enclose text in quotation marks
Relational operators definition
Relational operators definition
Symbols that compare values and create conditions
Relational operator > meaning
Relational operator > meaning
Greater than
Relational operators in COUNTIF format
Relational operators in COUNTIF format
Enclose entire condition in quotation marks
Cell formatting effect on values
Cell formatting effect on values
Changes display only, not actual stored values
Format Cells dialogue keyboard shortcut
Format Cells dialogue keyboard shortcut
Ctrl+1
Ribbon decimal buttons function
Ribbon decimal buttons function
Quickly increase/decrease decimal places displayed