Training By Himanshu
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. NameEmail 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 isThe average score is 42% 0% Restart quiz
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?
2 / 19
After applying a filter, how can you tell if a column is being filtered?
3 / 19
What is the primary use of the Filter feature in Excel?
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?
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?
6 / 19
Which chart type is best suited to compare parts of a whole, such as market share?
7 / 19
How can you print only a specific part of your worksheet in Excel?
8 / 19
Which of the following combinations is often used as a more flexible alternative to 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?
10 / 19
What does the Scenario Manager feature help you do?
11 / 19
Which of the following is the correct syntax of the PMT function?
12 / 19
What does =COUNTIF(A1:A10, “Ap*”) mean?
13 / 19
How many cells it will count
=COUNTIF(A1:A5, “*book*”)
A1:A5 contains: “book”, “notebook”, “pen”, “Booklet”, “paper”?
14 / 19
What does the formula =IF(A1=”Yes”, 1, 0) return if A1 contains the word “Yes”?
15 / 19
Which formula correctly uses the AND function within an IF?
16 / 19
What does the IF function return when the logical test is FALSE?
17 / 19
What does the HYPERLINK function do in Excel?
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?
19 / 19
What does the formula =SUMIF(A1:A10, “>100”) do?
Your score is
The average score is 42%
Restart quiz
Your cart is currently empty!
Notifications
