Advanced 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
Purpose of advanced functions in Excel
Purpose of advanced functions in Excel
Analyse data quickly and efficiently
What is a nested IF function
What is a nested IF function
One IF statement placed inside another IF statement
How nested IF conditions are processed
How nested IF conditions are processed
In sequence, as a hierarchy of conditions
Where to find Insert Function button
Where to find Insert Function button
Formulas tab in ribbon, fx icon
What does VLOOKUP do
What does VLOOKUP do
Searches vertically down first column for a match
Four components of VLOOKUP
Four components of VLOOKUP
lookup_value, table_array, col_index_num, range_lookup
What does HLOOKUP do
What does HLOOKUP do
Searches horizontally across top row for a match
When to use VLOOKUP vs HLOOKUP
When to use VLOOKUP vs HLOOKUP
VLOOKUP for column data, HLOOKUP for row data
Best practice for range_lookup parameter
Best practice for range_lookup parameter
Use FALSE for exact match to avoid unexpected results
Real-world uses of lookup functions
Real-world uses of lookup functions
Student grades, inventory prices, employee details