MS Excel Pre-Assessment Test

Question 1 of 10

1

Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?

Select one of the following:

Use conditional formatting
Use a comment
Use a data validation input message
None of these

Explanation

Question 2 of 10

1

How is an array formula identified in the formula bar in an Excel worksheet?

Select one of the following:

Chevron braces <>
Curly braces {}
Parentheses ()
Square brackets []

Explanation

Question 3 of 10

1

Sparklines are tiny charts that fit into one cell

Select one of the following:

TRUE
FALSE

Explanation

Question 4 of 10

1

Which function would you use to find the largest number of a selected range?

Select one of the following:

MAXIMUM
MAX
LARGE
LARGEST

Explanation

Question 5 of 10

1

Which wildcard character represents a single character?

Select one of the following:

*
?
!
&

Explanation

Question 6 of 10

1

You can create your own shortcuts in Excel

Select one of the following:

Yes
No

Explanation

Question 7 of 10

1

If we have the following function: VLOOKUP($N13,$I$13:$L$20,2,FALSE); Which column of the source table are we trying to extract?

Select one of the following:

First
Second
Third
Fourth

Explanation

Question 8 of 10

1

Which of the following statements about Excel macros is false?

Select one of the following:

A macro is stored in a macro-enabled workbook.
A macro can contain viruses or malicious code.
A macro name can include alphabetic and special characters.
A macro is a sequence of commands.

Explanation

Question 9 of 10

1

Is it possible to create pivot from multiple Excel Sheets?

Select one of the following:

Yes
No

Explanation

Question 10 of 10

1

How many arguments does the Sumifs function have?

Select one of the following:

1
2
3
N

	Created by Jatin Banga almost 8 years ago

Your MS Excel learning journey starts here

MS Excel Pre-Assessment Test

Question 1 of 10

Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?

Select one of the following:

Explanation

Question 2 of 10

How is an array formula identified in the formula bar in an Excel worksheet?

Select one of the following:

Explanation

Question 3 of 10

Sparklines are tiny charts that fit into one cell

Select one of the following:

Explanation

Question 4 of 10

Which function would you use to find the largest number of a selected range?

Select one of the following:

Explanation

Question 5 of 10

Which wildcard character represents a single character?

Select one of the following:

Explanation

Question 6 of 10

You can create your own shortcuts in Excel

Select one of the following:

Explanation

Question 7 of 10

If we have the following function: VLOOKUP($N13,$I$13:$L$20,2,FALSE); Which column of the source table are we trying to extract?

Select one of the following:

Explanation

Question 8 of 10

Which of the following statements about Excel macros is false?

Select one of the following:

Explanation

Question 9 of 10

Is it possible to create pivot from multiple Excel Sheets?

Select one of the following:

Explanation

Question 10 of 10

How many arguments does the Sumifs function have?

Select one of the following:

Explanation