"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

Shubham verma

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.

NameEmailPhone Number

1 / 10

Consider the Formula : = SUM(PRICEDATA)

Here PRICEDATA indicates-

Variable

Worksheet Name

Range Name

Column Header

2 / 10

The Most advanced version of LOOKUP Function is ?

VLookup()

HLookup()

Index()

XLookup()

3 / 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 ?

Formulas -> Name Manager

Data -> Trace Pracedents

Right Click Any Sheet -> Select all Sheets

None of These

4 / 10

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

Avg()

Average()

Mean()

Avge()

5 / 10

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

Line Chart

Pie Chart

Stacked Bar

Hierarchical Chart

6 / 10

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

#N/A

#Ref

NULL

Nothing

7 / 10

Pivot Table is option available under which Menu?

Insert

Data

Home

View

8 / 10

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

$A$1

$AB1

A1:C10

9 / 10

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

F11

10 / 10

10)

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

count()

length()

find()

concat()

Your score is

The average score is 60%