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

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 Assistant for Blue Well Inc. The company has a Windows-based network. You want to get the trend of the Business data range. For this purpose, you want to use trendlines in the chart. Which of the following steps will you take to apply the trendlines in the chart?

Each correct answer represents a part of the solution. Choose all that apply.

Options:

A.

Clear the check box of any Trendline fields to disconnect a slicer.

B.

Select the type that you want from Trendline options.

C.

Click the Insert Trendline arrow, and then click Trendline Connections on the Options tab in theSort & Filter group.

D.

Select a chart and then navigate to the Chart Tools Layout tab.

Buy Now
Question 2

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.

Question 3

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