Testking Web 77-882 Exam - Microsoft Excel 2010 by Testkingweb

VIEWS: 289 PAGES: 10

Testking Web 77-882 Exam - Microsoft Excel 2010 Questions and Answers with detailed Explanations and Objectives.

More Info
									                                                   Total Questions: 81




    Questions and Answers
                                          with
         Detailed Explanations and Objectives




                              Vendor: Microsoft
           Certification: Microsoft Office Specialist
                             Exam Code: 77-882
                         Exam Name: Excel 2010
                             Total Questions: 81




http://www.testkingweb.com/microsoft-77-882.html            Page 1 of 77
                                                                               Total Questions: 81

Objectives

    A      Managing the Worksheet Environment

    B      Creating Cell Data

    C      Formatting Cells and Worksheets

    D      Managing Worksheets and Workbooks

    E      Applying Formulas and Functions

    F      Presenting Data Visually

   G       Sharing worksheet data with other users

   H       Analyzing and Organizing Data


Note: Relevant objective of each question is mentioned with Question number.




http://www.testkingweb.com/microsoft-77-882.html                                        Page 2 of 77
                                                                                Total Questions: 81

QUESTION NO: 1(A)
You have upgraded your Excel 2007 to Excel 2010. You want to personalize your Excel environment
through the Excel Options window given below:




You are unable to find the Office button. Choose the steps you will take to accomplish the task.

    1.   Click on the File menu.
    2.   Click on the Home menu.
    3.   Click Option to open the Excel Option window.
    4.   Click the Personalize option to open the Excel Option window.

ANSWER:
In order to accomplish the task, you will have to take the following steps:

    1. Click on the File menu.
    2. Click Option to open the Excel Option window.

 A major change in Office 2010 from Office 2007 is elimination of the Office button. Instead, it
incorporates a “Backstage View” for personalizing the office environment. Backstage View can be
evoked by clicking the File menu button.




http://www.testkingweb.com/microsoft-77-882.html                                             Page 3 of 77
                                                                                 Total Questions: 81




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:

    1. Saving, opening, and closing a document as well as opening a new one
    2. Printing a document
    3. 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:
http://technet.microsoft.com/en-us/library/cc179167.aspx

QUESTION NO: 2(A)
You work as an Office Assistant of Mark World Inc. You have created a report in a workbook in Excel
2010. You want to change the layout of the worksheet from portrait to landscape. Mark the option that
you will choose to accomplish the task.




ANSWER:
The question specifies that you have to change the layout of the worksheet from portrait to
landscape. The Portrait layout is the default configuration of Excel. The Orientation option in the Page
Setup group of the Page Layout tab is used to switch the pages in portrait of “landscape” layouts. In
order to accomplish the task, click the Orientation option in the Page Setup group of the Page Layout
tab, and then click the Landscape option.




http://www.testkingweb.com/microsoft-77-882.html                                              Page 4 of 77
                                                                                 Total Questions: 81




Reference:
Microsoft Excel Help, Contents: "Print with landscape orientation"

QUESTION NO: 3(A)
You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales reports
for the Sales department. You use Microsoft Excel 2010 to create these reports. You have created an
yearly sales report. The fragment of the report is shown below:




As the report is quite wide, printing this report involves three A4 size pages. You want the first column
(column A) to repeat in every printed page.




Mark the option that you will choose to accomplish the task.

ANSWER:
The question states that the report is quite wide and takes three pages to print. You are
required to repeat column A in each printed page. In order to repeat the column in every printed page,
you will have to take the following steps:

Choose the Print Titles option in the Page Setup group on the Page Layout tab. This will open the Page
Setup window.


http://www.testkingweb.com/microsoft-77-882.html                                               Page 5 of 77
                                                                                 Total Questions: 81




In the Columns to repeat at left option, provide the required column value.




These steps will enforce Excel to repeat column A at the left side of each printed page.

Reference:
Microsoft Excel Help, Contents: "Print row and column headings or labels on every page"

QUESTION NO: 4(A)
Sarah works as an Office Assistant for Perfect Wear Inc. She has created a sales report in a worksheet
using Microsoft Excel 2010. She has inserted a chart to summarize data visually. She wants to print a
chart without printing the rest of the accompanying worksheet. Choose the required steps that Sarah
will take to accomplish the task.

    1.   Select the chart.
    2.   Click the File button and select the Print option.
    3.   Click Ok.
    4.   Click Office button > Print > Print Chart.
    5.   In the Current Selection group on the Layout tab, select the Print option.


ANSWER:
In order to accomplish the task, Sarah will have to take the following steps:

    1. Select the chart.
    2. Click the File button and select the Print option.
    3. Click the Print button.

When a user first selects the chart and then gives the print command, Excel adds and selects the
Selected Chart option in Settings. This is the only option that is enabled.




http://www.testkingweb.com/microsoft-77-882.html                                             Page 6 of 77
                                                                                Total Questions: 81




QUESTION NO: 5(A)
You work as a Sales Manager for Net World Inc. You are creating a sales report in Microsoft Excel 2010.
You want to create the report while keeping an eye on how it will look in printed format. Which of the
following “views” will you have to work on?

A.   Page Layout
B.   Normal
C.   Page Break
D.   Print Preview

ANSWER: A

EXPLANATION:
In order to fulfill the requirement of the question, you will have to work on Page Layout View.




http://www.testkingweb.com/microsoft-77-882.html                                             Page 7 of 77
                                                                                 Total Questions: 81




Page Layout View is one of the several views provided by Excel. This view has been introduced in Excel
2007 to enable users to create a worksheet while keeping an eye on how it will look in printed format.
Users can work with page headers, footers, margin settings in the worksheet in this view. It also enables
a user to place various objects, such as charts, at the place where the user wants to print them. Various
page setup options are also available in this view. It enables users to quickly set the worksheet page for
printing purposes.

Answer option B is incorrect. The Normal view will not allow you to work on your worksheet while
showing how it will appear in printed format.

Answer option C is incorrect. Although the Page Break view will show the print breaks of the worksheet
pages, it will not provide different printing options to work on.

Answer option D is incorrect. There is no such view as Print Preview in Excel 2010.


Reference:
Microsoft Excel Help, Contents: "Page Layout View"

QUESTION NO: 6(A)
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have
selected all worksheets available in the workbook as shown below:




Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task
with least administrative effort?

A. Right-click the selected sheets.
   Click the Ungroup Sheets option from the shortcut menu.


http://www.testkingweb.com/microsoft-77-882.html                                              Page 8 of 77
                                                                                   Total Questions: 81

B.   Double-click on one of the selected sheets.
C.   Click on one of the selected sheets.
D.   Click any unselected sheet.
E.   Click the Single Sheet options in the Sheet Options group on the Page Layout tab.

ANSWER: A

EXPLANATION:
When multiple sheets are selected, Excel groups the sheet and the *“Group”+ appears in the title bar as
shown below:




To unselect the sheet, you are required to click any unselected sheet. However, the question states that
all sheets are selected. In such a case, in order to unselect the sheets, you will have to take the following
steps:

         Right-click the selected sheets.
          Click the Ungroup Sheets option from the shortcut menu.

Answer options B and C are incorrect. These options will not ungroup the sheets.

Answer option D is incorrect. The question states that all the sheets are selected. Hence, no unselected
sheet will be available.

Answer option E is incorrect. No option such as Single Sheet is available in Excel.

Reference:
Microsoft Excel Help, Contents: "Select one or multiple worksheets"

QUESTION NO: 7(A)
Which of the following options of the Formula Auditing group on the Formulas tab should be enabled to
print formulas instead of their values in cells in Excel 2010?

A.   Trace Precedents
B.   Error Checking
C.   Watch Window
D.   Show Formula




http://www.testkingweb.com/microsoft-77-882.html                                                Page 9 of 77
                                                                             Total Questions: 81

ANSWER: D

QUESTION NO: 8(A)
Which of the following menu buttons is pressed to open the Backstage View?

A.   File
B.   Home
C.   Page Layout
D.   Data

ANSWER: A

QUESTION NO: 9(A)
Which task does the icon in the given image perform?



A.   Add a worksheet
B.   Save a worksheet
C.   Delete a worksheet
D.   Rename a worksheet
E.   Create a folder to save a worksheet

ANSWER: A

QUESTION NO: 10(A)
By default, how many worksheets does a workbook consist of?

A.   2
B.   3
C.   5
D.   1

ANSWER: B

QUESTION NO: 11(A)
Which of the following commands in the Print Preview window allows you to resize the print area and
edit the worksheet?

A.   Zoom
B.   Setup
C.   Page Break Preview
D.   Margins

ANSWER: C

QUESTION NO: 12(A)



http://www.testkingweb.com/microsoft-77-882.html                                        Page 10 of 77

								
To top