Home > Microsoft Excel > Quizzes > Microsoft Excel Test
Microsoft Excel Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 17% • Most missed: “Which function returns a reference to a cell (or cell range) that is a specified…”

Microsoft Excel MCQs For LinkedIn Skill Assessments.

Microsoft Excel Test
Time left 00:00
25 Questions

1. In the worksheet shown below, cell C6 contains the 'formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE)'. What is the most likely reason that '#N/A' is returned in cell 'C6' instead of mallory's 'ID (2H54)'
2. The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?
3. If you start a date series by dragging down the fill handle of a single cell that contains the date 12/1/19, what will you get?
4. In the worksheet below, what do the symbols in rows 4, 6, 7, and 11 indicate?
5. Monthly revenues of 2019 are entered in B2:M2, as shown below, To get year-to-date running total revenues, what formula should you enter in B3 and autofill through M3?
6. Which formula returns the value in cell A10 of the worksheet named Budget Variances?
7. 0 + 3 + 6 + 3 = 12. The formula only dislays 'Too Many Tardy Days' when it is more than 12.
101. What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?
8. After activating a chart, which sequence adds a trendline to the chart?
9. In the image below, which option(s) can you select so that the appropriate field headers appear in cells A4 and B3 instead of the terms Row Labels and Column Labels, respectively?
10. When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the \_.
11. Which Excel feature allows you to hide rows or columns with an easily visible expand/collapse?
12. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
13. 'because it needs to be transposed without creating a reference'
65. Which function returns the number of characters in a text string in cell A1?"
14. Which formula returns the value in cell A1 of the worksheet named MySheet?
15. How can you create the lower table from the top one when the tables are 'not' linked?
16. How can you drill down into a PivotTable to show details?
17. In this PivotTable, the continuous variable weight is shown in the _
Row_ field. Another continuous variable is in the _Sum
Values_ field. It is important to reduce a long list of body weights to a smaller set of weight categories. How do you do this?
!
18. To ensure shapes and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and then click \_.
19. The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?
20. You are determining '%' growth by dividing Growth by Sales. Which Excel function would you use to avoid #DIV/0! errors?
21. You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?
22. What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?
23. In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?
24. The charts below are based on the data in cells A3:G5. The chart on the right was created by copying the one on the left. Which ribbon button was clicked to change the layout of the chart on the right?
25. Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice Test Prove It - Microsoft Excel Test Microsoft Excel (MS Excel) Practice Test: All Topics Counting and Rounding Formulas Useful Excel Vocabulary Management Science MGSC 290 Final Excel Fundamentals Test (Upwork) Prove It - Microsoft Excel 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.