UNITED COMPUTER CONSULTANTS
Home
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel Basic 1 - Basic Excel
Excel Basic 2 - Keyboard Shortcuts
Excel - Basic 3 - Functions
Excel - Basic 4 - Pivot Tables
Excel - Basic 5 - The IF function
Excel - Intermediate
>
Excel - Intermediate 1
Excel - Intermediate 2
Excel - Intermediate 3
Excel - Intermediate 4
Excel - Intermediate 5
Excel Advanced
>
Excel Advanced 1
Excel Advanced 2
Word Tests
>
Word - Basic
>
Word - Basic1 - General
Word - Basic 2 - Keyboard Shortcuts
Word - Basic 3 - Formatting
Word - Basic 4 - Tables
Word Tips and Tricks
Word Intermediate
>
Word - Intermediate - General
PowerPoint Tests
>
PowerPoint
Downloads
Excel
Word
PowerPoint
TestsFiles
Blog
Contact Us
Excel Knowledge Test
Basic Level 5
The IF Function
Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.
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
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel Basic 1 - Basic Excel
Excel Basic 2 - Keyboard Shortcuts
Excel - Basic 3 - Functions
Excel - Basic 4 - Pivot Tables
Excel - Basic 5 - The IF function
Excel - Intermediate
>
Excel - Intermediate 1
Excel - Intermediate 2
Excel - Intermediate 3
Excel - Intermediate 4
Excel - Intermediate 5
Excel Advanced
>
Excel Advanced 1
Excel Advanced 2
Word Tests
>
Word - Basic
>
Word - Basic1 - General
Word - Basic 2 - Keyboard Shortcuts
Word - Basic 3 - Formatting
Word - Basic 4 - Tables
Word Tips and Tricks
Word Intermediate
>
Word - Intermediate - General
PowerPoint Tests
>
PowerPoint
Downloads
Excel
Word
PowerPoint
TestsFiles
Blog
Contact Us