Home > Microsoft Excel > Quizzes > Microsoft Excel 2010 Test
Microsoft Excel 2010 Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 23% • Most missed: “Relative cell reference consists of the column letter and row number surrounded …”

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.

Microsoft Excel 2010 Test
Time left 00:00
25 Questions

1. Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
2. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List - calculates the aggregates of columns?
3. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
4. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
5. Microsoft Excel Services is a component of:
6. When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010 - Excel creates new ________ with data corresponding to the pivot report value.
7. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
8. Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members to be able to see the report remotely on a web browser - and edit the report - as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
9. In the given screenshot - there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?
10. With reference to the screenshot given - which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?
11. Which of the following tools is used to format Excel worksheet data - as shown in the figure above?
12. Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value - lookup_vector - result_vector) The values in the lookup_vector must be placed in ________ order.
13. Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?
14. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
15. What does the icon marked with a red square in the figure above signify?
16. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
17. State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: An Absolute cell reference consists of the column letter and row number.
18. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
19. State whether the following is true or false:Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
20. Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?
21. What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
22. Excel keeps the changed history of a workbook for ________ days by default.
23. Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value - lookup_vector - result_vector) Which of the following arguments of the LOOKUP function is optional?
24. Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
25. Microsoft Excel 2010 supports 3D rotation of images.

⚡ 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.