eSkill - eSkill Assessment Microsoft Office Proficiency Questions and Answers

Question 1

A project manager is preparing a quarterly report in Microsoft Word that includes several charts linked from an Excel spreadsheet. They need to ensure that the report's text flows around the charts, rather than having large blank spaces. Which of the following options provides the most efficient way to control how text behaves around an object?

Accepted Answer

Using the 'Wrap Text' options in the 'Format' tab.

Answer

The 'Wrap Text' feature in Microsoft Word is specifically designed to control how text flows around images, charts, and other objects. Options like 'Square', 'Tight', or 'Through' allow the text to wrap closely to the object, eliminating awkward white space and creating a more professional document layout.

Question 2

In Microsoft Excel, what is the primary function of the VLOOKUP formula?

Accepted Answer

To find a value in the leftmost column of a table and return a corresponding value from another column in the same row.

Answer

VLOOKUP (Vertical Lookup) is a powerful function used to search for a specific value in the first column of a data range and retrieve a related value from a different column in the same row. It is essential for cross-referencing and merging data between different tables.

Question 3

A marketing team is creating a presentation in Microsoft PowerPoint for a major client. They want to ensure a consistent and professional look across all slides, including fonts, colors, and logo placement. Which of the following is the most effective tool to achieve this?

Accepted Answer

Utilizing the 'Slide Master' view to create a custom template.

Answer

The 'Slide Master' view in PowerPoint allows you to define the layout, fonts, colors, and other formatting for all slides in a presentation. By modifying the master slide, you can apply global changes instantly, ensuring a consistent and branded look throughout the entire presentation efficiently.

Question 4

An administrative assistant needs to schedule a recurring weekly meeting in Microsoft Outlook that will take place every Tuesday and Thursday at 10:00 AM for the next three months. Which of the following is the correct feature to use for this task?

Accepted Answer

Using the 'Recurrence' option within the appointment window.

Answer

The 'Recurrence' feature in Outlook is designed specifically for scheduling repeating appointments and meetings. It allows the user to set a pattern (daily, weekly, monthly, yearly) and an end date, which automates the process of adding the event to the calendar for the specified duration.

Question 5

You are working with a large dataset in Excel and want to quickly identify all cells in a selected range that contain a value greater than 500 by highlighting them in green. Which feature would you use to accomplish this task automatically?

Accepted Answer

Conditional Formatting

Answer

Conditional Formatting allows you to apply specific formatting (like colors, icons, or data bars) to cells that meet certain criteria. In this scenario, you would create a new rule to highlight cells with a value 'greater than' 500 with a green fill.

eSkill - eSkill Assessment Test Practice Test

eSkill - eSkill Assessment Test Practice Test

eSkill - eSkill Assessment Microsoft Office Proficiency Questions and Answers