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

0 of 40 Questions answered correctly

Your time:

Time has elapsed

Categories

1. Not categorized 0%

• Congratulations, you’ve earned the Excel certificate!

    

  Get your certificate

   

• Congratulations, you’ve earned the Excel certificate!

   

  Get your certificate

   

• Congratulations, you’ve earned the Excel certificate!

   

  Get your certificate

   

1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40

1. Current
2. Review
3. Answered
4. Correct
5. Incorrect

1. Question 1 of 40

   1. Question

   What does C5 represent?

   

   • Row C – Column 5
   • Column C – Row 5
   • Row 5
   • Column C
2. Question 2 of 40

   2. Question

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

   

   • Row
   • Cell
   • Function
   • Column
3. Question 3 of 40

   3. Question

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

   • Σ
   • α
   • /
   • *
4. 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
5. Question 5 of 40

   5. Question

   Which of the following retrieves the value of cell A1?

   • =A1
   • =A(1)
   • +A1
   • =1A
6. 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]
7. Question 7 of 40

   7. Question

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

   

   • =Sayfa2!B5
   • =Sayfa2!5
   • =B5
   • =B5Sayfa2
8. Question 8 of 40

   8. Question

   Which of the following correctly specifies a cell range?

   

   • A1:1C
   • 1A:1B
   • A1:A8
   • A1:B4
9. 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
10. Question 10 of 40

    10. Question

    Which of the following cannot be a formula?

    • A1+B1
    • =A1+B1
    • =(A1+B1)
    • =SUM(A1;B1)
11. 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(C2*C5)
12. Question 12 of 40

    12. Question

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

    • 22
    • 22,4
    • 22,5
    • 22,481
13. 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.
14. 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?

    • C3*15+C3
    • =C3*15+C3
    • =C3*15%+C3
    • =C4*1,5+C3
15. 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
16. 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
17. 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
18. 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.
19. 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
20. 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)
21. 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)
22. 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
23. 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)
24. 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(B5*C5)
    • B5-C5
25. 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)
26. 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.
27. 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)
28. 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
29. 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
30. 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
31. 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)
32. 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
33. 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?

    • B5*35+B5
    • =B5*35+B5
    • =B5*35%+B5
    • =B5*3,5+B5
34. 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
35. 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
36. 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
37. 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.
38. 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
39. 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
40. 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

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

⭐ ⭐ ⭐

Advanced