Excel Practical Practice Test

MS Excel Online Practice Test

Test your Microsoft Excel skills with this free online practice test designed to assess your knowledge and practical abilities. Whether you’re a beginner or an experienced user, this quiz will challenge your understanding of formulas, functions, data handling, formatting, and more.

✅ Covers real-world Excel tasks
✅ Immediate feedback on answers
✅ Great for students, job seekers, and professionals
✅ No installation required – 100% online

Take the test now and discover how well you know Excel! Perfect for self-evaluation, interview preparation, or brushing up on essential Excel skills.

1 / 19

What is the purpose of the “Define Name” feature in Excel?

To create charts

To assign a name to a cell or range

To rename the workbook

2 / 19

After applying a filter, how can you tell if a column is being filtered?

The worksheet name changes

The row numbers turn bold

A filter icon appears in the column header

3 / 19

What is the primary use of the Filter feature in Excel?

To delete data

To sort worksheets

To display only rows that meet certain criteria

To highlight duplicates

4 / 19

You’ve created a Pivot Table showing total sales by product. You only want to view sales for the East and West regions. What should you do?

Add "Region" to the Report Filter area and select East and West

Apply a Filter to the original data

Delete all other regions from the Pivot Table

5 / 19

You have sales data with columns: “Region”, “Product”, and “Sales Amount”. You want to see the total sales for each region. What should you do in a Pivot Table?

Drag "Sales Amount" to Rows and "Region" to Values

Drag "Region" to Rows and "Sales Amount" to Values

Drag "Product" to Rows and "Region" to Filters

6 / 19

Which chart type is best suited to compare parts of a whole, such as market share?

Line chart

Column chart

Pie chart

Scatter chart

7 / 19

How can you print only a specific part of your worksheet in Excel?

Use the filter option

Hide other rows

Set the print area

Freeze panes

8 / 19

Which of the following combinations is often used as a more flexible alternative to VLOOKUP?

SUM + IF

INDEX + MATCH

MATCH + LOOKUP

OFFSET + VLOOKUP

9 / 19

You have a table of employee data in range A2:D10. Column A contains Employee IDs, and Column C contains Salaries. What will the formula =VLOOKUP(104, A2:D10, 3, FALSE) return?

The name of the employee with ID 104

The row number of employee 104

The salary of employee with ID 104

10 / 19

What does the Scenario Manager feature help you do?

Analyze and compare different sets of input values

Format cells conditionally

Record data changes

11 / 19

Which of the following is the correct syntax of the PMT function?

PMT(rate, periods, loan_amount)

PMT(rate, nper, pv, [fv], [type])

PMT(interest_rate, total_amount, duration)

PMT(loan_amount, rate, duration)

12 / 19

What does =COUNTIF(A1:A10, “Ap*”) mean?

Count all blank cells

Count only "Apple"

Count values containing “Ap”

Count values starting with “Ap”

13 / 19

How many cells it will count

=COUNTIF(A1:A5, “*book*”)

A1:A5 contains: “book”, “notebook”, “pen”, “Booklet”, “paper”?

1

2

3

4

14 / 19

What does the formula =IF(A1=”Yes”, 1, 0) return if A1 contains the word “Yes”?

1

0

Yes

TRUE

15 / 19

Which formula correctly uses the AND function within an IF?

"IF(A1>10 OR B1<5, "Yes", "No")"

"IF(AND(A1>10,B1<5),"Yes","No")"

"IF(A1>10,AND(B1<5),"Yes")"

16 / 19

What does the IF function return when the logical test is FALSE?

0

Blank cell

Value_if_false

Error

17 / 19

What does the HYPERLINK function do in Excel?

Imports web data

Links to another workbook or location

Creates a pivot table

Encrypts a worksheet

18 / 19

In a list of student scores in B2:B20, you want to highlight scores above 90. Which conditional formatting rule should you use?

Use a formula: ="B2>90"

Use a formula: "IF(B2>90, TRUE, FALSE)"

Format only cells equal to 90

19 / 19

What does the formula =SUMIF(A1:A10, “>100”) do?

Counts all values greater than 100

Sums values greater than 100 in A1:A10

Returns 100

Your score is
The average score is 0%
0%

Comments

Leave a Reply Cancel reply