Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us
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
*
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 below to hear answers and helpful tips
Submit my answers
Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us