Home
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel - Basic 1 - General
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
Privacy Policy
United Computer Consultants
Helpful video:
How to add a "Slider" control and use with VLOOKUP -
https://youtu.be/6XqRP8gRj90
Excel Knowledge Test
Advanced Level 2
VLOOKUP with Slider
Answer the questions first, then use the audio player at the
bottom of the page to hear answers and helpful tips
*
Indicates required field
Name
*
First
Last
Email
*
How is the Developer tab added to the ribbon?
*
File>Option>Save
File>OPtions>Customise Ribbon>Developer
File>Options>Add-Ins
Which tab contains the Form Control?
*
Home
Insert
Developer
The IF function always requires....arguments exactly
*
3
2
0
What do the arrows on the slider do?
*
They delete the contents of cells
They increase or decrease the number in the nominated cell
The contents of cells are copied to the clipboard
How do you change the properties of the slider?
*
Right click on the slider, Format Control>Properties
Double-click the slider and format
The properties cannot be changed
How do you hide the contents of cells?
*
Press Shift-delete
Select the cell/s and press Backspace
Home>Number>Format>Custom, repace "General" with three sem-colons
[object Object]
Why convert data to a table?
*
New data is automatically added to a drop-down list
There is no benefit
Can the slider be used to define the column number in VLOOKUP
*
No
Yes
Click here to join the mailing list to receive software tips and tricks
Use the audio player above to hear answers and helpful tips