Quarter Test 1

Which Excel function would you use to find the highest value in a range of numbers?

• MAX

• COUNT

• MIN

• AVERAGE

What is the primary purpose of the Mail Merge feature in Microsoft Word?

• To create customized letters for multiple recipients

• To design newsletters for printing and distribution

• To integrate text and images into a single document

• To generate automated reports from a database

In a Mail Merge operation, which of the following is typically used as a data source?

• An Excel spreadsheet containing recipient data

• A Word document with a table of values

• A PDF document with text and images

• A PowerPoint file with various slides

When promoting an event on social media, which strategy is most effective?

• Post the event details once and avoid too much follow-up

• Avoid using hashtags and focus on text-based posts

• Create an event page and encourage followers to share it widely

• Send private invitations to a small group of friends only

How can conditional formatting in Excel assist in data analysis?

• It merges multiple cells into one large cell

• It adds comments to cells for additional notes

• It highlights cells based on specific criteria set by the user

• It automatically sorts data in ascending order

When preparing a newsletter in Microsoft Word using Mail Merge, what is the next step after writing the content?

• Connect to a data source to personalize the newsletter

• Insert additional images to enhance visual appeal

• Print the document to check for any errors

• Save the document in multiple formats for distribution

To ensure data security when collecting responses via Google Forms, what should you do?

• Share the form link widely across various platforms

• Allow respondents to edit their responses at any time

• Collect responses anonymously without using any encryption

• Restrict access to the form by requiring user authentication

Which type of chart in Excel is best for showing the proportion of each part to the whole?

• Bar Chart

• Line Chart

• Scatter Plot

• Pie Chart

How do you ensure that a Mail Merge document is personalized for each recipient?

• Use placeholders in the template to be filled with recipient data

• Manually type each recipient’s details into the document

• Write a generic message that applies to all recipients

• Edit each document individually before sending it out

What is a good practice for keeping a podcast engaging for listeners?

• Record episodes without any editing or content review

• Discuss multiple unrelated topics in a single episode

• Make episodes as long as possible, regardless of the content

• Focus on a specific topic and keep episodes concise and informative