Using Functions to Solve Problems (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
Why combine multiple functions in business spreadsheets?
Why combine multiple functions in business spreadsheets?
To solve complex problems efficiently
What does =LEFT(A2;FIND(" ";A2)) extract from a full name?
What does =LEFT(A2;FIND(" ";A2)) extract from a full name?
The first name
Which functions combine to extract a surname from text?
Which functions combine to extract a surname from text?
RIGHT, LEN, and FIND
How many parameters does VLOOKUP require?
How many parameters does VLOOKUP require?
Four parameters
What does FALSE ensure in VLOOKUP?
What does FALSE ensure in VLOOKUP?
An exact match is found
What stock level triggers "yes" for low stock in =IF(D2<=12;"yes";"no")?
What stock level triggers "yes" for low stock in =IF(D2<=12;"yes";"no")?
12 or below
What spending amount qualifies customers for a bonus gift?
What spending amount qualifies customers for a bonus gift?
More than R2,000
When does the AND function return TRUE?
When does the AND function return TRUE?
When all arguments are true
What does COUNTIF do in business analysis?
What does COUNTIF do in business analysis?
Counts cells meeting specific criteria
How many stages are in the complete workflow system?
How many stages are in the complete workflow system?
Five stages