What is the name of the green-bordered area shown on the Excel screen?

Question 3 of 40

3. Question

Which symbol is used for the “Multiplication” operation on an Excel worksheet?

Question 4 of 40

4. Question

What is the term for the red-bordered area shown on the Excel screen?

Question 5 of 40

5. Question

Which of the following retrieves the value of cell A1?

Question 6 of 40

6. Question

Which one is a valid Excel formula?

Question 7 of 40

7. Question

Which of the following retrieves the Honor 30 Lite stock information?

Question 8 of 40

8. Question

Which of the following correctly specifies a cell range?

Question 9 of 40

9. Question

Which of the following retrieves the value of cell C8 from Worksheet 3?

Question 10 of 40

10. Question

Which of the following cannot be a formula?

Question 11 of 40

11. Question

Which of the following is the equivalent of the formula =C2+C3+C4+C5?

Question 12 of 40

12. Question

What is the result of the formula =ROUND(22,481, 1)?

Question 13 of 40

13. Question

What is the function of the formula =AVERAGE(B1:B5)?

Question 14 of 40

14. Question

There is a house rent in cell C3. Rent will be increased by 15% inflation rate. In this regard, which of the following formulas calculates the new house rent?

Question 15 of 40

15. Question

What are the functions of the buttons below, in order?

Question 16 of 40

16. Question

What are the functions of the buttons below in order?

Question 17 of 40

17. Question

In which option is the order of the following buttons correctly given?

Question 18 of 40

18. Question

What is the purpose of the following icon group in Excel?

Question 19 of 40

19. Question

Which of the options below does not calculate the arithmetic average of cells A1, A2, and A3?

Question 20 of 40

20. Question

Which of the following formulas sums the numbers entered into cells A1, A2, and A3?

Question 21 of 40

21. Question

Which of the following formulas calculates the difference between the number in cell B3 and the number in cell A3

Question 22 of 40

22. Question

Which of the following formulas provides the average of the numbers in cells E1, E2, E3, E4, and E5?

Question 23 of 40

23. Question

In which of the following formulas is the cell address fixed?

Question 24 of 40

24. Question

Which of the following formulas is in cell D5, providing the profit for the year 2000 in the table below?

Question 25 of 40

25. Question

Which of the following formulas provides Eric’s average for the 1st and 2nd midterms in the table below?

Question 26 of 40

26. Question

What is the purpose of the $ sign in Excel?

Question 27 of 40

27. Question

According to the table below, which of the following formulas provides the monthly average expense?

Question 28 of 40

28. Question

If we drag the formula from cell B1 to cell B3 after writing it in the data table below, what result will we get in cell B3?

Question 29 of 40

29. Question

What is the formula that provides the total profits for the years 1999 and 2000 in the table below?

Question 30 of 40

30. Question

You’re working on a document where column width and font size should not be changed. However, the columns are too narrow to display all the text in each cell. Which tool should you use to solve this problem?

Question 31 of 40

31. Question

Which formula is not equivalent to the others?

Question 32 of 40

32. Question

According to the data in the Excel table, which product has generated the highest profit?

Question 33 of 40

33. Question

In cell B5, there is a monthly electricity expense. Starting from next month, there will be a 35% inflation rate in the electricity kWh price. Which of the following formulas calculates the new electricity expense?

Question 34 of 40

34. Question

What is the term given to an expression that begins with an equal sign and is entered into a worksheet cell?

Question 35 of 40

35. Question

What is the name given to the numbers inside or above each column in a column chart?

Question 36 of 40

36. Question

Which of the following types of charts is used to compare values across different categories?

Question 37 of 40

37. Question

You have a table named “SalesData” with the following table. The table contains four columns: “Region,” “Product,” “Sales Quantity,” and “Sales Revenue.” You want to create a PivotTable to analyze the total revenue for each product in different regions. What steps should you follow to create the PivotTable?

Question 38 of 40

38. Question

According to the data in the table, what is the result of the formula =COUNT(A18:G20)?

Question 39 of 40

39. Question

According to the data in the table, what is the result of the formula =VLOOKUP(A3,A3:B7,2,FALSE)?

Question 40 of 40

40. Question

If you drag the fill handle located at the bottom right corner of cell A2 downwards to cells A3, A4, and A5, what content will appear in these cells?

EXCEL

Excel Level Test

Excel Level Test measures how you use Excel, apply Excel formulas and have a good Excel skills. Excel exam will evaluate your Excel skills and give an Excel score. At the end you will find out your Excel level quickly and you will receive your Excel certificate immediately.

Test your Excel online, fast & accurate

Take the test online anytime, anywhere

Certify your Excel level

Get your certificate of Excel proficiency immediately

Present your level on your resume

Highlight your Excel skill on your resume

Microsoft Excel Levels

This Excel Quiz is designed to help you evaluate your knowledge of basic Excel functions and formulas and has 3 levels.

⭐

Basic

⭐ ⭐

Intermediate

⭐ ⭐ ⭐

Advanced

Get your Excel certificate

You can find out your Microsoft Excel level right away by completing the free test. If you want, you can get a personal Microsoft Excel Level Certificate that you can add to your LinkedIn profile or CV.

✓ Get a personalized Microsoft Excel level certificate

✓ Add your level determined according to international levels to your CV

✓ Download your certificate as PDF

✓ Easily add your certificate to LinkedIn Profile

Excel Test Testimonials

Is your excel knowledge high enough to be considered an expert? Take this excel test and see your excel level instantly!

“As a Digital Marketing Specialist, I work in a fast-paced business environment with a high growth rate. Within Microsoft Office, especially Excel is the most important application I use in my work. This has helped me learn my test level and how much more I need to improve myself.”

Jennifer

“Excel knowledge is among the most frequently asked questions by Human Resources professionals in job interviews. By solving the test, I learned my real level and added it to my CV in the most accurate way. Thus, I can now express my level much more comfortably in interviews. Thank you.”

Matt

Excel Certifications

Internatonal English Test is one of the global leaders in providing Excel Tests and Excel certification services online.

Advanced Excel

Advanced Excel Functionsrefers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more.

Excel Formula

A formula in Microsoft Excel is an expression that modifies values in a set of cells.

Even if the result is incorrect, these formulas nonetheless return a result. You may execute calculations like addition, subtraction, multiplication, and division using Excel formulae.

Excel also allows you to work with date and time values, discover averages and percentages for a range of cells, and perform a lot more things.

Vlookup Excel

Excel’s VLOOKUP function is arguably its most well-known feature, for both good and bad reasons.

On the plus side, VLOOKUP is simple to use and performs a highly valuable function. It is quite gratifying to watch VLOOKUP scan a table, locate a match, and deliver the right result, especially for beginning users.

Many Excel users consider successfully using VLOOKUP to be a rite of passage.