Microsoft Excel Certification

Time limit: 0

Test Summary

0 of 40 Questions completed

Questions:

Information

You have already completed the test before. Hence you can not start it again.

Test is loading…

You must sign in or sign up to start the test.

You must first complete the following:

Results

Test complete. Results are being recorded.

Results

Time has elapsed

Categories

Not categorized 0%

Congratulations!

Your Excel level certificate is ready

Get your certificate

Benefits of your Project Management certificate:

✔ Get an international verified certificate

✔ Download your certificate as a PDF immediately

✔ Easily add your certificate to your resume and LinkedIn Profile

Get your certificate

Congratulations!

Your Excel level certificate is ready

Get your certificate

Benefits of your Excel certificate:

✔ Get an international verified certificate

✔ Download your certificate as a PDF immediately

✔ Easily add your certificate to your resume and LinkedIn Profile

Get your certificate

Congratulations!

Your Excel level certificate is ready

Get your certificate

Benefits of your Excel certificate:

✔ Get an international verified certificate

✔ Download your certificate as a PDF immediately

✔ Easily add your certificate to your resume and LinkedIn Profile

Get your certificate

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

Current

Review

Answered

Correct

Incorrect

Question 1 of 40

1. Question

What does C5 represent?

Row C – Column 5

Column C – Row 5

Row 5

Column C

Question 2 of 40

2. Question

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

Row

Cell

Function

Column

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?

Toolbar

Formula bar

Menu bar

Worksheet

Question 5 of 40

5. Question

Which of the following retrieves the value of cell A1?

=A1

=A(1)

+A1

=1A

Question 6 of 40

6. Question

Which one is a valid Excel formula?

=(A5+B5)C5

=A5-7(C3:C5+7)

=(A15+B15)B19

=B15^[12/15]

Question 7 of 40

7. Question

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

=Sayfa2!B5

=Sayfa2!5

=B5

=B5Sayfa2

Question 8 of 40

8. Question

Which of the following correctly specifies a cell range?

A1:1C

1A:1B

A1:A8

A1:B4

Question 9 of 40

9. Question

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

=Sheet3!C8

=Sheet3!

=Sheet3!8C

=C8!Sheet3

Question 10 of 40

10. Question

Which of the following cannot be a formula?

A1+B1

=A1+B1

=(A1+B1)

=SUM(A1;B1)

Question 11 of 40

11. Question

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

=SUM(C2;C5)

=SUM(C2:C5)

=SUM(C2+C5)

=SUM(C2C5)

Question 12 of 40

12. Question

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

22

22,4

22,5

22,481

Question 13 of 40

13. Question

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

Averages the number in cell B5.

Averages the number in cell B1.

Takes the average of cells from B1 to B5.

Takes the average of cells B1 and 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?

C315+C3

=C315+C3

=C315%+C3

=C41,5+C3

Question 15 of 40

15. Question

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

Align Left – Align Right – Justify

Align Left – Center – Align Right

Align Right – Center – Align Left

Align Right – Center – Justify

Question 16 of 40

16. Question

What are the functions of the buttons below in order?

Decimal Increase – Decimal Decrease

Decimal Decrease – Decimal Increase

Indent Increase – Indent Decrease

Indent Decrease – Indent Increase

Question 17 of 40

17. Question

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

Align Left – Center – Align Right – Increase Decimal – Decrease Decimal – Merge Center

Align Left – Center – Align Right – Increase Indent – Decrease Indent – Merge Center

Align Left – Center – Align Right – Decrease Indent – Increase Indent – Merge Center

Align Left – Center – Align Right – Decrease Decimal – Increase Decimal – Merge Center

Question 18 of 40

18. Question

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

It is used to add small images to our Excel worksheet.

It is used to create a graph of the data table in our Excel worksheet.

It is used to create mini charts of the data table in our Excel worksheet.

It is used to add the SmartArt option to our Excel worksheet.

Question 19 of 40

19. Question

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

=AVERAGE(A1;A2;A3)

=AVERAGE(A1:A3)

=(A1+A2+A3)/3

=A1+A2+A3/3

Question 20 of 40

20. Question

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

=SUM(A1;A3)

=SUM(A1:A3)

=SUM(A1:A3)+SUM(A1:A3)

=SUM(A1)+SUM(A2)+SUM(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

=B3-A3

(B3-A3)

=(B3) DIFF (A3)

=DIFF(B3) DIFF(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?

AVERAGA(E1;E5)

=(E1:E5)/4

=AVERAGE(E1:E5)

(E1;E2;E3;E4;E5)/4

Question 23 of 40

23. Question

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

=SUM(A1;A3)

=TODAY(A1)

=SUM($A$1+B5)

=NOW(A1:A3)

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?

=B5-C5

=SUM(B5/C5)

=SUM(B5C5)

B5-C5

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?

=AVERAGE(B3:C3)

=SUM(B3:C3)

AVERAGE(B3:C3)

=SUM(B3;C3)

Question 26 of 40

26. Question

What is the purpose of the $ sign in Excel?

In Excel, a formula always starts with a dollar sign ($).

The dollar sign is used in Excel to lock the value of a cell.

The dollar sign is used in Excel to represent the value of a cell in dollars.

The dollar sign indicates that it comes from another page in the same Excel file.

Question 27 of 40

27. Question

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

=AVERAGE(B2:B5)

=AVERAGE(C2:C5)

=AVERAGE(C2;C5)

=AVERAGE(B2;B5)

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?

12

13

8

6

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?

=(B4-C4)+(B5-C5)

=SUM(B4:C5)

=SUM(D2:D5)

=B4+C5

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?

Scroll text

Merge text

Align text

Correct text

Question 31 of 40

31. Question

Which formula is not equivalent to the others?

=A3+A4+A5+A6

=SUM(A3:A6)

=SUM(A3,A6)

=SUM(A3,A4,A5,A6)

Question 32 of 40

32. Question

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

Product A

Product B

Product C

Product D

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?

B535+B5

=B535+B5

=B535%+B5

=B53,5+B5

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?

Function

Formula

Dollar

Equality

Question 35 of 40

35. Question

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

Data table

Data numbers

Data labels

Data values

Question 36 of 40

36. Question

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

Line chart

Bar chart

Pie chart

Scatter chart

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?

Select the entire table, go to the Insert tab, and click on PivotTable. Choose the "Product" column for Rows and the "Revenue" column for Values.

Select the entire table, go to the Home tab, and click on PivotTable. Choose the "Region" column for Rows and the "Sales Quantity" column for Values.

Select the entire table, go to the Data tab, and click on PivotTable. Choose the "Product" column for Columns and the "Revenue" column for Values.

Select the entire table, go to the Formulas tab, and click on PivotTable. Choose the "Region" column for Columns and the "Sales Quantity" column for Values.

Question 38 of 40

38. Question

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

5

6

10

12

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)?

Green

10

T-shirt

20

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?

February, March, April

January, January, January

Blank, Blank, Blank

January, February, March

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 Functions refers 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.

Best Free Online Courses & Certifications

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.