Innovative Technology Solutions

/10
2

"Welcome to the Excel Assessment! Test your knowledge of Microsoft Excel principles and practices. Get ready to challenge yourself and enhance your skills."


Created by 8fc9083d7fadce741aa7d44eb51e9c8f?s=32&d=mm&r=gShubham verma
Excel

Excel Post Assessment

Try out this free assessment to see how well you know your skills.

Please Enter some basic details about you before starting the quiz.

1 / 10

1)

Pivot Table is option available under which Menu?

2 / 10

2)

When You want to show some data in a chart in the form a Percentage Values which chart will be the Best?

3 / 10

3)

Consider the Formula : = SUM(PRICEDATA)

Here PRICEDATA indicates-

4 / 10

4)

The Most advanced version of LOOKUP Function is ?

5 / 10

5)

When VLOOKUP() does not find the data it returns a value:

6 / 10

6)

Which of the following Function is used to calculate Average of Some Values?

7 / 10

7)

Which of the Following is an example of Mixed Cell Referencing?

8 / 10

8)

Which short cut key you can use to make a Cell Address Absolute?

9 / 10

9)

Which function is used to search a string inside another string?

10 / 10

10)

You are having an worksheet where there are lot many Range Names are Defined- To See the List of all Range Names and their cell ranges – which option can help you ?

Your score is

The average score is 60%

0%