Excel - Intermediate 1

Use the following links to see training videos which will assist in answering the questionnaire:
Absolute cell references: - https://youtu.be/hG2JTNpJD3Y
Using VLOOKUP: -https://youtu.be/YqjE6OUqqrY

Excel Knowledge Test
Intermediate 1
General

Complete the questions first, the listen to the
answers using the audio player at the bottom of the page

* Indicates required field

Name *

First

Last

Email *

In a VLOOKUP formula, why is the "False" argument used *

You created a chart of sales figures for three sales people, How do you show the trend in their sales? *

Write a short example of a basic VLOOKUP formula using fictitious cell references *

Write a short example of a basic IF formula using fictitious cell references *

What is an "absolute" reference, and where and why are they used? What character indicates this type of reference? *

You need to have a "countdown" to the number of days left for a particular task to be completed. How would you approach this in Excel? *

You wish to autofill a formula down a column. What is the alternate to dragging, and what is the requirement? *

You wish to fill cells with the days of the week EXCEPT for weekends. Where do you point the mouse, and which mouse button would you use? *