Home > Microsoft Excel > Quizzes > Excel Fundamentals Test (Upwork)
Excel Fundamentals Test (Upwork)
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 34% • Most missed: “Which worksheet function extracts from a database a single record that matches t…”

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.

Excel Fundamentals Test (Upwork)
Time left 00:00
25 Questions

1. How many workbooks can a user maintain open simultaneously?
2. Which worksheet function Estimates the standard deviation based on a sample of selected database entries?
3. Which one of the following formulas cannot be calculated by Excel?
4. The formula QUARTILE(a1:a100
5. Using IF()
6. Which worksheet function returns the most common value in a data set?
7. The following functions are listed when the office button is selected:
8. A user can sort a maximum of...
9. Each Excel file is called a workbook because
10. How do you make sure that a formula's result will always fit into the cell?
11. The key board short-cut to insert TODAY'S DATE in a cell is:
12. If a set of numbers has an even number of items
13. The difference between the COUNT function and the COUNTA function is:
14. It is normal practice that numbers are treated as decimals when entering into a cell
15. Formulas in excel start with?
16. Cell A1 contains the formula =$F$39. Copying that formula to cell B2 will result in:
17. Cells D3 through Z3 list sales total for various months. What does the equation '=SUM(D3:Z3)' show?
18. You can convert your Excel document into a Google doc.
19. When a list is filtered (showing only rows that meet the criteria) and highlighted
20. What does the 'V' in 'VLOOKUP' stand for?
21. What function converts a text string into a cell reference?
22. True or False: There is only ONE way to group a pivot table item.
23. Which of the following Excel screen components CANNOT be turned on or off?
24. Which of the following is NOT a way to align a cell?
25. A ________________ consists of a grid made from columns and rows?

⚡ 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 Prove It - Microsoft Excel 2 MS Excel 2007 Test
 
❤ 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.