Essential Office Computer Skills Quiz Day 2

What is the primary purpose of Microsoft Word?

• To create, edit, and format text-based documents

• To manage email communications

• To design visual content

• To create and edit spreadsheets

Which Microsoft 365 tool is used for effective communication and collaboration?

• SharePoint

• Excel

• PowerPoint

• Outlook

What is a key component of an official letter?

• Data visualization

• Project timeline

• Meeting agenda

• Letter head

What feature in Excel allows you to automatically format cells based on specific criteria?

• Conditional Formatting

• Data Visualization

• Pivot Table

• Drop Down List

What is the purpose of a Project Proposal?

• To create visual content

• To record meeting minutes

• To analyze sales data

• To outline the objectives and tasks required to complete a project

Which of the following is NOT a function of Microsoft Excel?

• Creating charts

• Email management

• Data organization

• Data analysis

What is the purpose of creating a Pie Chart in Excel?

• To visualize sales trends over time

• To show the contribution of each category to total sales

• To analyze employee performance

• To create a summary of project expenses

What is the main benefit of using SharePoint?

• Creating presentations

• Writing code

• Storing and sharing files securely

• Editing images

Which of the following is a feature of Microsoft Excel?

• Sending emails

• Designing visual content

• Developing test case reports

• Creating official letters

What is the purpose of Conditional Formatting in Excel?

• To create a new worksheet

• To insert charts

• To format cells based on criteria

• To manage email lists