Course completion quiz

Microsoft Excel Final Quiz

Answer 20 questions covering all ten lessons, including practical scenarios, troubleshooting, and choosing the right steps. Complete all ten lessons and score at least 85 percent (17 of 20 correct) to earn a printable course-completion certificate.

Final quiz

Choose one best answer for each question based on the course material. There are two questions from each lesson and four choices per question. Question and answer order changes each time. There is no time limit. After grading, read the explanations and use the lesson links to review before retaking the quiz.

1. Your contact list has Name in A1, Department in B1, and Extension in C1. Where does the second person's department belong? C2 B3 A3 B1

2. A colleague asks for the workbook, but you have only described the active worksheet. What distinction matters? Each cell is saved as a separate workbook automatically A workbook is the saved file and can contain several worksheets A worksheet is the saved file and contains several workbooks Only the active worksheet is included when saving an XLSX file

3. You need to change part of B3's existing text while preserving the rest. Which sequence fits? Go to B3, press Ctrl+F, and close Find Go to B3, press Ctrl+C, and move away Go to B3, press F2, edit, and confirm Go to B3, press Delete, and press Save

4. You copied Active from D2 to several rows. Which review checks the intended result? Check that the workbook opened without an error Check that D2 still says Active and stop there Confirm that the worksheet name stayed the same Read the destination cells and confirm only the intended rows changed

5. B2 contains 3 and C2 contains 12. What result should =B2*C2 produce? 36 4 9 15

6. You copy =B2*C2 from D2 to D3 using ordinary relative references. What formula should D3 contain? =B2*C2 =B3*C3 =B2+C2 =C2*D2

7. A cell stores 0.1 and should display as 10 percent. What should you change? Apply Currency number format Replace the value with 10 and apply Percentage Merge it with the neighboring label Apply Percentage number format

8. Red cells mean Needs Review, but no status words are present. What is the best improvement? Place the meaning only in the workbook filename Make every cell the same red color Use a brighter shade of red without adding text Add explicit status text while keeping useful color cues

9. After filtering Training Status to Not Started, several employees disappear. How should you restore the full list? Clear that filter and verify the rows return Change the worksheet name to All Employees Re-enter the missing employees as new records Undo every edit made since opening the workbook

10. You are converting a list with column labels into a table. What must be verified in the creation dialog? That every numeric column is formatted as currency Only the active cell's font and background color The full data range and the My table has headers setting That the workbook contains exactly one worksheet

11. B2 is 8 and C2 is 8. What does =IF(B2>=C2,"Complete","Needs Training") return? Complete 8 0 Needs Training

12. D2:D7 contains Complete three times and Needs Training three times. What does =COUNTIF(D2:D7,"Complete") return? 0 2 3 6

13. Summary!B1 contains =January!B8. January!B8 changes from 50 to 65. Under normal automatic calculation, what should Summary!B1 show? 65 0 50 115

14. You want January, February, and Summary in one saved file. Which organization fits? One worksheet with every monthly total typed over the previous one Three workbooks renamed to the same filename Three named worksheets within one workbook Three unrelated files with no summary formulas

15. A chart has good alt text, but a reader needs the exact monthly values. What should remain available? Only the highest monthly value The source data table with clear labels Only a larger image of the chart Only the chart's title and legend

16. Which chart description is most useful for the training report? What the chart compares and its main trend Every decorative color without naming the data A statement that the chart is a picture The chart's filename and creation time

17. Users enter Closed, closed-out, and Finished for the same status. Which feature can guide consistent new entries? A chart showing the existing status values A data-validation list of allowed status values A larger font for the Status column A renamed workbook without changing entry controls

18. You added a validation list for Status. What practical check should follow? Sort the sheet without testing any entry cells Confirm the workbook has an Instructions sheet and stop Check only that the worksheet contains the word Status Open the list in a target cell and verify its choices and behavior

19. One copied line-total formula uses the previous row's quantity. Which review would reveal the cause? Change the total's currency format Increase the chart's size Inspect that row's formula and compare its references with its inputs Rename the Summary worksheet

20. The final budget has totals and a chart but no source values accessible to readers. What is missing? A more decorative chart theme A second chart using the same inaccessible picture A shorter workbook filename Reviewable data and a text explanation supporting the results

Microsoft Excel Final Quiz

Final quiz

Create your certificate

Certificate of Course Completion