MS Excel Pre-Assessment Test

Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js

We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our terms and conditions for more information.

Quiz by Jatin Banga, created more than 1 year ago

Your MS Excel learning journey starts here

861

	Created by Jatin Banga about 8 years ago

Rate this resource by clicking on the stars below:

(0)

Ratings (0)

0
0
0
0
0

0 comments

There are no comments, be the first and leave one below:

To join the discussion, please sign up for a new account or log in with your existing account.

Your MS Excel learning journey starts here

0 comments

MS Excel Pre-Assessment Test

MS Excel Pre-Assessment Test

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

Sparklines are tiny charts that fit into one cell

Select one of the following:

Explanation

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

Which wildcard character represents a single character?

Select one of the following:

Explanation

Question 3 of 10 Question 6 of 10

You can create your own shortcuts in Excel

Select one of the following:

Explanation

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

Which of the following statements about Excel macros is false?

Select one of the following:

Explanation

Question 8 of 10 Question 9 of 10

Is it possible to create pivot from multiple Excel Sheets?

Select one of the following:

Explanation

Question 9 of 10 Question 10 of 10

How many arguments does the Sumifs function have?

Select one of the following:

Explanation