Home > Microsoft Excel > Quizzes > MS Excel 2007 Test
MS Excel 2007 Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 20% • Most missed: “Which option would you choose to display a list of formula used in the current P…”

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.

MS Excel 2007 Test
Time left 00:00
25 Questions

1. What would be the result - when =T(A4) is applied on the given table?
2. Which of the following options should be used to create a connection to a shared network folder - as shown in the picture?
3. Which Chart type is displayed in the given picture?
4. Which option would you choose to display a list of formula used in the current PivotTable report?
5. Which of the following is not true about an offline cube file?
6. Which keyboard shortcut should be used to enter the current time?
7. What is the significance of the red symbol at the top right corner of the cell - as shown in the picture?
8. What is the purpose of using the Keep text flat option - as shown in the picture?
9. State whether true or false: When you sign the stamp signature line in an Office document - you add both a visible stamp and a digital signature.
10. How would you assign a Macro to a graphic?
11. When would the data validation command be unavailable on the data tab?
12. How should blank cells be inserted on a Worksheet?
13. Which of the following options would you choose to clear a PivotChart report?
14. State whether true or false: Macro project can be digitally signed.
15. Which keyboard shortcut re-calculates all formulas in all open workbooks - regardless of whether or not they have changed since the last time?
16. Which of the following options is not available on the Status bar?
17. Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
18. Which database function estimates variance based on a sample from selected database entries?
19. Referring to the given image - point out which option should be selected to automatically save a backup copy of a workbook.
20. Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?
21. Which keyboard shortcut should be used to minimize or restore the ribbon?
22. Where can the 'Show All Comments' command be found?
23. Which part of the formula displays references in the given picture?
24. Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?
25. Which chart displays axes but cannot display axis titles?

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