77-882 무료 덤프문제 온라인 액세스

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report
of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created
a quarterly sales report of the department. After entering required data and inserting charts, you
want to give a professional look to the document. You want to produce the document with
soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to
accomplish the task with least administrative burden?

• A.Use the SmartArt option.
• B.Select all the text of the document. Change font style to Verdana and font color to light gray.
  Use vibrant colors for charts.
• C.Create a new workbook through a template. Copy all data and charts of the report to the new workbook.
• D.Choose one of the pre-built themes.

You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for
creating various types of reports. You have created a report in the format given below:

In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the
B7 cell. Which of the following formulas will provide the required result?

• A.COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
• B.COUNTIF(B2:C5,"=Yes")
• C.COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
• D.COUNTIFS(B2:C5,"=Yes")

You work as a Help Desk Technician for Tech Perfect Inc. Rick, a Sales Manager, uses Microsoft
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:

He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.

정답:

Explanation:
In order to accomplish the task, Rick should take the following steps:
Select the range for which the display of relative magnitude is required.
Select the Data Bars option through Home tab > Styles Group > Conditional Formatting.
The Conditional Formatting feature of Excel provides a facility to compare the relative magnitude
of values in a cell range by applying colors. According to the image shown in the question, relative
magnitude of values in a cell range is displayed by extending a band of color across the cell.
Hence, you should ask Rick to use the Data Bars option of the Conditional Formatting feature. The
Color Scales option of the Conditional Formatting feature compares the relative magnitude of
values in a cell range by applying colors from a two-or three-color set to the cells. Using this
option the same table will appear as follows:

The Format as Table option is used to configure the whole table in a certain style. It does not
provide the facility to compare values in a range of cells.
Reference:
Microsoft Excel Help, Contents: "Add, change, or clear conditional formats"

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook. The workbook was created by the Sales Manager who has asked you to fill in the sales figures in the table.
When you click in one of the cells, you see a message as shown below.

What function did the Sales Manager use to configure the alert message?

• A.The Data Validation function.
• B.The Protect Workbook function.
• C.The Allow Users to Edit Ranges function.
• D.The Share Workbook function.

You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs
the Microsoft Excel 2010 application on the network. You open the application and see various
changes in Excel 2010. You have to open an existing worksheet through the application. You are
unable to find the Office button. Mark the option that you will click to accomplish the task. Click
on the Correct Spot in the Image. Doing so will place the target icon at the clicked spot.

정답:

Explanation:
You will have to click File button to accomplish the task. Clicking the File button will open the
full- screen Backstage View of the sheet.

FactWhat is Backstage View?
Backstage View, introduced in Microsoft Office 2010, is a feature of MS Office to configure
options that affect the document as a whole, or the application itself. Backstage View can be In
Excel and houses the following commands: Saving, opening, and closing a document as well as
opening a new one Printing a document Changing Excel options Backstage View, a full-window
file menu, replaces the Office button of Office 2007 and can be accessed by pressing the File menu
button. It provides easy access to task-centered functions such as printing and sharing.
Reference:
Microsoft Office Help, Contents: "The File Button"