Excel - Basic 5 - The IF function

Home
MS Office Tests
Downloads
- Excel
- Word
- PowerPoint
Job Test Downloads
Blog
Contact Us

United Computer Consultants

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 here to join the mailing list to receive software tips and tricks

Use the audio player above to hear answers and helpful tips

Note that ads appear on various pages, which may generate income for United Computer Consultants.
Visitors to this site are free to use the ads at their discretion but in no way does United Computer Consultants request such usage.
Without exception, we abide by the rules governing the display of advertising on the site.

© United Computer Consultants 2018. All rights reserved