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
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?
-
Question 2 of 40
2. Question
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?