Using Functions to Solve Problems (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
Purpose of combining multiple functions
Purpose of combining multiple functions
Solve complex business problems
LEFT function purpose
LEFT function purpose
Extracts chars from beginning of text
FIND function purpose
FIND function purpose
Locates position of specific characters
Formula: extract first name
Formula: extract first name
=LEFT(A2;FIND(" ";A2))
VLOOKUP function purpose
VLOOKUP function purpose
Searches column & returns value from specified column
FALSE parameter in VLOOKUP
FALSE parameter in VLOOKUP
Ensures exact match
IF function purpose
IF function purpose
Returns values based on logical conditions
When AND returns TRUE
When AND returns TRUE
When all conditions are true
TODAY function returns
TODAY function returns
Current date
COUNTIF function purpose
COUNTIF function purpose
Counts cells meeting specific criteria