Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

77-888 Exam Dumps - Microsoft Office Specialist Questions and Answers

Page: 1 / 2
Questions 4

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.

Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

Options:

A.

Gantt Chart Template

B.

Form control

C.

Trust Center

D.

Accounting template

Buy Now
Questions 5

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common

variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?

Options:

A.

Goal Seek

B.

Solver add-in

C.

Data table

D.

Scenario

Buy Now
Questions 6

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

Options:

A.

Use the SmartArt option.

B.

Create a new workbook through a template.Copy all data and charts of the report to the new workbook.

C.

Choose one of the pre-built themes.

D.

Select all the text of the document.

Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Buy Now
Questions 7

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. He is creating a form through Microsoft Excel 2010. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?

Options:

A.

Form control

B.

Accounting template

C.

Trust Center

D.

ActiveX control

Buy Now
Page: 1 / 2
Exam Code: 77-888
Exam Name: Microsoft Excel 2010 Expert
Last Update: Apr 14, 2023
Questions: 62
77-888 pdf

77-888 PDF

$31.5  $90
77-888 Engine

77-888 Testing Engine

$36.75  $105
77-888 PDF + Engine

77-888 PDF + Testing Engine

$49  $140