March Sale Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Microsoft 77-888 Microsoft Excel 2010 Expert Exam Practice Test

Note! Following 77-888 Exam is Retired now. Please select the alternative replacement for your Exam Certification.
Page: 1 / 6
Total 62 questions

Microsoft Excel 2010 Expert Questions and Answers

Question 1

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

Excel 2010. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will

Rick use to accomplish the task?

Options:

A.

Accounting template

B.

Trust Center

C.

Form control

D.

Evaluate Formula

Question 2

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

Rick has to perform the following tasks:

Summarize large amounts of data. Analyze numeric data.

Answer unexpected questions about data.

Which of the following actions will Rick take to accomplish the task?

Options:

A.

He will create the accounting template.

B.

He will use stand-alone slicers.

C.

He will create a PivotTable report.

D.

He will configure form controls.

Question 3

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?

Options:

A.

Goal Seek

B.

Data table

C.

Scenario

D.

Solver add-in

Question 4

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the

company's high selling products. You are trying to intersect two ranges that do not intersect each

other. Which of the following errors will be occurred in this situation?

Options:

A.

#VALUE!

B.

#NAME?

C.

#NULL!

D.

#DIV/0!

Question 5

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?

Options:

A.

Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Vertical option.

B.

Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

C.

Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Cascade option.

D.

Select the cell which is to be monitored.

On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Question 6

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; Excel is not able to recognize the matching value. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. 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.

Select the Text to Columns option from the Data tab at the top of the Excel workbook.

B.

SelectText and click the Finish button in Column Data Formats.

C.

Select theDelimited option and click Next

D.

Make sure that all delimiter options are unselected, and then again click Next.

E.

Remove the unseen spaces at the start or end of the first Macro cell.

F.

Select the cells to convert their data to text.

Question 7

You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro.

While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this?

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

Options:

A.

The default workbook or a workbook loaded from the XLStart folder is opened before running the macro.

B.

The workbook is opened programmatically using the Open method.

C.

TheworkbookwhereauserwantstosavetheAuto_Openmacroalreadycontainsa

VBAprocedure in its Open event.

D.

The workbook is based on the record button that is disabled by default before running the

Auto_Open macro.

Question 8

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team

Using Microsoft Excel. You want the report to appear in the following format:

You want the Remark column to be filled through a conditional formula. The criteria to give the

remark is as follows:

If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the

sales of the First Quarter is less than 1200, display "Improve in Next Quarter"

You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

Which of the following conditional formulas will you insert to accomplish the task?

Options:

A.

=IF(E2>=1200,"Improve in Next Quarter","Well Done")

B.

=IF(E2<=1200,"Well Done","Improve in Next Quarter")

C.

=IF(E2>=1200,"Well Done","Improve in Next Quarter")

D.

=IF(E2>1200,"Improve in Next Quarter","Well Done")

Question 9

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.

Question # 9

Options:

Page: 1 / 6
Total 62 questions