Online Access Free 77-882 Exam Questions

Your work at ABC.com includes the preparation of company spreadsheets using Microsoft Office Excel 2010.
You are preparing a financial report that will be emailed to company managers. You want to add a background image of the company logo to the spreadsheet. The background image should not be printed if a manager decides to print a copy of the spreadsheet.
How should you configure the spreadsheet?

• A.You should use the SmartArt function on the Insert tab.
• B.You should use the Effects function on the Page Layout tab.
• C.You should use the Picture function on the Insert tab.
• D.You should use the Background function on the Page Layout tab.
• E.You should use the Text Box function on the Insert tab.

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.

Correct Answer:

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"

You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the
fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the
Auto Fill button appears.

You do not want to display the Auto Fill button. You open the Excel Options window. Mark the
check box that you will clear to accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, you will clear the Show Paste Options buttons check box in the
cut, copy, and paste section of the Advanced Excel Options window.

You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in
Excel. You have prepared a table as shown below:

You want to increase the height of each row in such a manner that all rows have the same height.
Which of the following steps will you take to accomplish the task easily?

• A.Select all rows in the table. Right-click on the selected rows and click the Row Height option. In
  the Row Height dialog box, provide the required value.
• B.Select individual rows. Drag the border of rows to the required height.
• C.Select all rows in the table. Drag the border of one of the selected rows to the required height.
• D.Select all rows in the table. Click the Format option in the Cells group on the Home tab. Click
  Row Height. In the Row Height dialog box, provide the required value.

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in
Excel 2010. You want to insert flow-chart in the sheet. Mark the option that you will choose to
insert flow- chart symbols in the report.

Correct Answer:

Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple
objects provided by Microsoft Office to add them to a document. A single shape or combined
multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines,
basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts.
Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the
document. Take the following steps to add a shape in a document:
1.Click on the Shapes option in the Illustrations group on the Insert tab. This will open the list of
shapes available in Microsoft Office.

2.Choose the required shape from the list.