Unit test

1. Which of the following is the correct file extension for a Microsoft Excel workbook?

• A. .docx

• B. .xlsx

• C. .pptx

• D. .xlsm

2. You want to calculate the total price in Column C by multiplying quantity (Column A) and price per unit (Column B). What formula would you type in C2?

• =A2-B2
• =B2/A2
• =A2+B2
• =A2*B2

1. What is the correct formula to find the average of the values in cells A1 to A10?

• =AVERAGE(A1:A10)

• =MEDIAN(A1:A10)

• =SUM(A1:A10)/10

• =COUNT(A1:A10)

2. Which function would you use to count the number of cells in a range that contain numbers?

• =COUNTA(A1:A10)

• =COUNT(A1:A10)

• =SUM(A1:A10)

• =COUNTIF(A1:A10, ">0")

1. What function would you use to find the maximum value in a range of cells?

• =AVERAGE(A1:A10)

• =SUM(A1:A10)

• =MIN(A1:A10)

• =MAX(A1:A10)

6. You’re creating a presentation to explain climate change. Which slide layout would best organize your comparison of "Causes" and "Effects"?

• A. Title Slide

• B. Title and Content

• C. Two Content

• D. Blank

7. Your presentation has too much text on some slides. What is the best way to improve clarity and audience engagement?

• A. Increase the font size

• B. Change the slide background

• C. Add bullet points, visuals, or split the content across slides

• D. Use fancy fonts

8. You're assigned to present a group project. To ensure a smooth delivery, you add slide notes and rehearse timings. Which feature helps most with this preparation?

• Presenter View
• Animation Effects
• Slide Transitions
• Text Formatting

9. You want to emphasize a key point in your presentation without distracting your audience. Which is the best way to do this?

• Read the entire slide verbatim to ensure clarity.
• Use loud background music to grab attention.
• Use a subtle visual aid to highlight the key point.
• Distract the audience with a funny video.

10. You’ve used many transitions and animations, but your teacher says it feels overwhelming. What is the most appropriate revision?

• Limit the number of transitions and animations used.
• Include sound effects with every animation.
• Use a different color scheme for each transition.
• Add more flashy animations to grab attention.