Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us
Excel Knowledge Test
Basic Level 5
The IF Function
The following link will open a training video containing IF function creation information if you need assistance in answering the following questionnaire:
https://youtu.be/td2U9ksij9Q
*
Indicates required field
Name
*
First
Last
Email
*
The main purpose of IF is to..
*
Test the contents of a cell
Analyse data
Edit text in the spreadsheet
Check all that apply...
*
The first argument tests the contents of a cell
The second argument shows a result if the test is true
The third argument shows a result if the test is false
How many arguments does IF require
*
2
3
4
What would you use in an argument to show a blank cell
*
A question mark
Two double quotes
Nothing
What must surround text used in arguments
*
Asterisks
Double quotes
Commas
Can other functions be used with IF?
*
Yes
No
Click to subscribe
Submit my answers
Use the audio player above to hear answers and helpful tips
Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us