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.