MS Excel Pre-Assessment Test

Question 7 of 10 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 a data validation input message
Use conditional formatting
Use a comment
None of these

Explanation

Question 1 of 10 Question 2 of 10

1

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

Select one of the following:

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

Explanation

Question 6 of 10 Question 3 of 10

1

Sparklines are tiny charts that fit into one cell

Select one of the following:

TRUE
FALSE

Explanation

Question 5 of 10 Question 4 of 10

1

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

Select one of the following:

LARGE
MAX
MAXIMUM
LARGEST

Explanation

Question 4 of 10 Question 5 of 10

1

Which wildcard character represents a single character?

Select one of the following:

!
?
&
*

Explanation

Question 9 of 10 Question 6 of 10

1

You can create your own shortcuts in Excel

Select one of the following:

No
Yes

Explanation

Question 10 of 10 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:

Third
First
Fourth
Second

Explanation

Question 8 of 10 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 name can include alphabetic and special characters.
A macro is a sequence of commands.
A macro can contain viruses or malicious code.

Explanation

Question 3 of 10 Question 9 of 10

1

Is it possible to create pivot from multiple Excel Sheets?

Select one of the following:

Yes
No

Explanation

Question 2 of 10 Question 10 of 10

1

How many arguments does the Sumifs function have?

Select one of the following:

1
N
3
2

	Created by Jatin Banga about 8 years ago

Your MS Excel learning journey starts here

0 comments

MS Excel Pre-Assessment Test

Question 7 of 10 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 1 of 10 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 6 of 10 Question 3 of 10

Sparklines are tiny charts that fit into one cell

Select one of the following:

Explanation

Question 5 of 10 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 4 of 10 Question 5 of 10

Which wildcard character represents a single character?

Select one of the following:

Explanation

Question 9 of 10 Question 6 of 10

You can create your own shortcuts in Excel

Select one of the following:

Explanation

Question 10 of 10 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 Question 8 of 10

Which of the following statements about Excel macros is false?

Select one of the following:

Explanation

Question 3 of 10 Question 9 of 10

Is it possible to create pivot from multiple Excel Sheets?

Select one of the following:

Explanation

Question 2 of 10 Question 10 of 10

How many arguments does the Sumifs function have?

Select one of the following:

Explanation