MS Excel Advanced training review

What type of data validation rule has an in-cell drop down appear to show restricted values?

• any value

• list

• custom

• drop-down menu

With data validation rules, the user can set 3 different types of Alert options. All are alert options available in MS Excel except?

• stop

• warning

• invalid

• information

Which lookup function allows the computer to search in any direction?

• X-lookup

• V-lookup

• H-lookup

• none of them

• Column index number

• Table array

• Range look-up

• FALSE

• TRUE

• part 1

• part 2

• part 3

• part 4

When inserting a chart on a worksheet side-by-side with the data in the cells, it is referred to an ___________. This allows the user to re-position or resize it on screen.

In MS Excel, the selection pane has a few purposes. Please pick the best and most accurate description of the selection pane.

• it shows many of the formatting options available for use on objects in the spreadsheet

• it shows a list of all objects used in the current worksheet by name and allows the user to show/hide objects easily

• it shows a list of all objects used in the whole file and allows the user to show/hide objects easily

• the short-cut Alt+F10 will show/hide the selection pane

In MS Excel, the filtering tool called ________ can be used with pivot tables, charts and tables. This filtering tools helps the user to more interactive and efficient when changing the filter criteria.

Several elements are used in the design of this chart. Select the elements that are used.

• legend

• X-axis

• data labels

• gridlines

• data table

The visual in this image is referred to what in MS Excel?

• trendlines with high points

• trendlines

• sparklines

• mini line charts