Excel Advanced 2

Home
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

Note that ads may 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 2022. All rights reserved

Home
Contact Us

Excel Knowledge TestAdvanced Level 2VLOOKUP with Slider

Excel Knowledge Test
Advanced Level 2
VLOOKUP with Slider