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

Microsoft 77-888 Dumps

Page: 1 / 2
Total 62 questions

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.

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.

Question 4

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft

Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will choose to accomplish the task.

Options:

Question 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

Question 6

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem?

Each correct answer represents a complete solution. Choose all that apply.

Options:

A.

You are inserting a new column, next to a column that is already formatted as text.

B.

Excel is trying to reference an invalid cell.

C.

The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.

D.

You are referencing an entire worksheet by clicking on the grey square at the top left of the

worksheet.

Question 7

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following are the reasons that are causing the above problem?

Each correct answer represents a complete solution. Choose all that apply.

Options:

A.

The lookup_value or the array you are searching resides in a cell containing unseen spaces at

the start or end of that cell.

B.

The contents of the cells that are being compared may have different data types.

C.

Excel is trying to reference an invalid cell.

D.

You are inserting a new column, next to a column that is already formatted as text.

Question 8

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.

Which of the following will you use to accomplish the task?

Each correct answer represents a complete solution. Choose all that apply.

Options:

A.

History tracking

B.

Onscreen highlighting

C.

Slicer-enabled highlighting

D.

Reviewing of changes

Question 9

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in

Microsoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task?

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

Options:

A.

Click OK.

B.

Choose Select a table or range under Choose the data that you want to analyze.

C.

Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.

D.

Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables

group on the Insert tab.

E.

Click a cell in the cell range that contains data for using worksheet data as the data source.

Page: 1 / 2
Total 62 questions