IF Functions and Charts (Grade 11 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What type of function is the IF function in Excel?
What type of function is the IF function in Excel?
Logical function
How many parts does the basic IF function syntax contain?
How many parts does the basic IF function syntax contain?
Three parts
What does Excel evaluate first when processing an IF function?
What does Excel evaluate first when processing an IF function?
The condition
How must text values be formatted in an IF function?
How must text values be formatted in an IF function?
Enclosed in quotation marks
Do numbers need quotation marks in IF functions?
Do numbers need quotation marks in IF functions?
No, they don't need quotes
How does Excel treat 'Rain' and 'rain' when comparing text?
How does Excel treat 'Rain' and 'rain' when comparing text?
As different values
In the grade example, what result appears when A1=60 using =IF(A1=60, 'Pass', 'Grounded')?
In the grade example, what result appears when A1=60 using =IF(A1=60, 'Pass', 'Grounded')?
Pass
Which of these is NOT a stated use of IF functions?
Which of these is NOT a stated use of IF functions?
Delete data automatically
What part of the IF function asks the question Excel checks?
What part of the IF function asks the question Excel checks?
Condition
What does IF return when the condition is incorrect?
What does IF return when the condition is incorrect?
Value_if_false