77-888 Microsoft Excel 2010 Expert - Practice Questions

Question 7

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?

Select an option, then click Submit answer.

○
Gantt Chart Template
○
Form control
○
Trust Center
○
Accounting template

Reference / correct answer:

Gantt Chart Template

The Gantt Chart Template Deluxe Edition for Excel is used to generate quick and easy Gantt charts that define the progress of a user's projects containing up to 100 project tasks and team members. Answer option B is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option D is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of months. Answer option C is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2010 programs.

Question 8

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:

You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell. Which of the following formulas will you insert to accomplish the task?

Select an option, then click Submit answer.

○
=&B&3/100 * E8
○
=B3/100 * E8
○
=B3/100 * &E&8
○
=$B$3/100 * E8
○
=B3/100 * $E$8

Question 9

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.

In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?

Select an option, then click Submit answer.

○
Bar
○
Line
○
Column
○
Pie

77-888 – Microsoft Excel 2010 Expert