Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following 77-888 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

Microsoft Excel 2010 Expert Questions and Answers

Question 1

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
Question 2

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. Which of the following will you use to accomplish the task?

Options:

A.

Form control

B.

Trust Center

C.

Accounting template

D.

What-if analysis

Question 3

Rick works as an Office Assistant for Tech Perfect Inc. He is responsible for preparing sales

reports of the company. He has created a sales report in a workbook of Excel 2010 and this workbook contains various worksheets as shown in the image given below:

Rick wants the sheet tabs of the sheets containing charts to appear in red color. Which of the

following steps will Rick take to accomplish the task?

Options:

A.

Select the sheets containing charts. Select the Colors option in the Themes group on the

Page Layout page.

B.

Select the sheets containing charts. Right-click on the sheet tabs.

C.

Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color

Optionfrom the shortcut menu.

D.

Select the sheets containing charts. Select the Effects option in the Themes group on the

Page Layout page.