Search Header Logo

MS Excel Advanced training review

Authored by Arlene Roche

Business

Professional Development

Used 3+ times

MS Excel Advanced training review
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

any value

list

custom

drop-down menu

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

X-lookup

V-lookup

H-lookup

none of them

4.

MULTIPLE SELECT QUESTION

45 sec • 2 pts

Column index number

Table array

Range look-up

FALSE

TRUE

5.

MULTIPLE CHOICE QUESTION

1 min • 3 pts

part 1

part 2

part 3

part 4

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

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.

7.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?