Microsoft 77-882 Online Practice Questions and Exam Preparation

Microsoft 77-882 Online Questions & Answers

• Question 1:

  You need to create a worksheet containing sales data of different salesmen of a company. You are using Microsoft Excel 2010 to create the sheet. Your assistant has compiled the required data in a text file. You need to import data from the text file. Mark the option you will choose to accomplish this task.

  

  A. Check the answer below.
  A. Check the answer below.

  ---

  explanation:

  

  Explanation: You can use Microsoft Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in the way you want to be.

• Question 2:

  You are working on a report on Microsoft Excel 2010 for your organization. You need to link a cell to a Web page that displays some graphical reports of the past accounting year. Which of the following options will you use in the spreadsheet to accomplish the task?

  A. Pivot Table in the Tables ribbon at the Insert tab.
  B. Conditional Formatting in the Styles ribbon at the Home tab.
  C. Hyperlink in the Links ribbon at the Insert tab.
  D. Screenshot in the Illustrations ribbon at the Insert tab.
  C. Hyperlink in the Links ribbon at the Insert tab.

  ---

  explanation:

  According to the question, you are required to link a cell to a Web page. In order to accomplish the task, you will have to create a hyperlink for the cell. For this, use the Hyperlink option in the Links ribbon at the Insert tab. In Excel 2010, a hyperlink refers to the setting where a cell can be linked to a Web page, a picture, an e-mail address, or a program. A cell can be hyperlinked through the Hyperlink option in the Links ribbon in the Insert Tab.

  

  When a hyperlink is applied to a cell, on clicking the link, it opens the linked item in a separate window. Answer: A, B, and D are incorrect. These steps will not accomplish the task.

• Question 3:

  Martha has created a report in Excel 2010. She wants to construct header and footer before printing the report. How can she accomplish the task?

  A. Through the Style ribbon in the Home tab.
  B. Through the Sheet Options ribbon in the Page Layout tab.
  C. Through the Page Setup ribbon in the Page Layout tab.
  D. Through the Changes ribbon in the Review tab.
  C. Through the Page Setup ribbon in the Page Layout tab.

  ---

  explanation:

  In order to construct header and footer, Martha will need to open the Page Setup window through the Page Setup ribbon in the Page Layout tab.

  

  In the Header/Footer tab, Martha can provide appropriate values to construct header and footer before printing her report.

  Apart from constructing header and footer, the Page Setup window provides lots of other options to set for the printing, such as setting page orientation, scaling, paper size, print quality, margins, printing gridlines, etc.

• Question 4:

  While printing a spreadsheet in Excel 2010, all of the following scaling options are available except which one?

  A. Fit Sheet on One Page
  B. Fit All Sheets on One Page
  C. Fit All Rows on One Page
  D. No Scaling
  E. Fit All Columns on One Page
  B. Fit All Sheets on One Page

  ---

  explanation:

  There is no such option as Fit All Sheets on One Page available in Microsoft Excel 2010. Answer: D, A, E, and C are incorrect. Microsoft Excel 2010 provides various scaling options while printing a spreadsheet. Users can choose one of the four scaling options shown below:

  

• Question 5:

  Rick is working on a worksheet in Excel 2010. He has entered data in the worksheet as shown in the image below:

  

  He wants to hide column B of the worksheet. Which of the following options will he choose to accomplish the task with least amount of effort?

  A. Select the column B > Use Ctrl+X command to cut the column > Paste the column in the different worksheet.
  B. Select the column B > Use Ctrl+X command to cut the column > Paste the column at the last column in the worksheet.
  C. Select the column B > Click the Hide option in the Window ribbon at the View tab.
  D. Select the column B > Right-click on the selected column > Click the Hide option in the menu.
  D. Select the column B > Right-click on the selected column > Click the Hide option in the menu.

  ---

  explanation:

  According to the question, Rick wants to hide column B. Take the following steps to hide a column: 1.Select the column you want to hide.

  

  2.Right click on the selected column. Click the Hide option on the menu.

  

  3.The selected column will hide.

  

  Answer: B and A are incorrect. These options will move the contents of the column. They will not hide the column. Answer: C is incorrect. This will hide the current window opened in Excel.

• Question 6:

  You are creating a worksheet in Excel 2010. You need to merge five adjacent cells of rows 1 to 5 in your worksheet to make them a large cell. You select the five rows and columns. Mark the merge option that you will choose to accomplish the task.

  

  A. Check the answer below.
  A. Check the answer below.

  ---

  explanation:

  

  Explanation: In order to accomplish the task, you will have to use the Merge Across option. Excel 2010 provides four merge options for cells in Excel 2010. These options are described below:

  

• Question 7:

  Martha has just upgraded her Office 2007 to Office 2010. She is creating a report on Excel 2010 and needs to print it. From where can she check the preview of her spreadsheet and print it?

  A. Page Layout tab > Print ribbon
  B. Edit Tab > Print ribbon
  C. Backstage > Print tab
  D. Home Tab > Print ribbon
  C. Backstage > Print tab

  ---

  explanation:

  Marhta should go to the Print tab at the Backstage to preview and print her spreadsheet. In Excel 2010, the Print options are a part of the Backstage. For accessing Backstage, click on the File tab

  

  . On the Print tab in the Backstage view, a user can preview and print Office files from one location.

  

  On the Print tab, the properties for the default printer automatically appear in the first section, and the preview of the workbook automatically appears in the second section. Answer: D, B, and A are incorrect. No ribbon such as Print is available in Excel 2010.

• Question 8:

  You are creating a worksheet on Excel 2010. You want to select entire worksheet (including the blank cells). Through which of the following steps can you accomplish your task? Each correct answer represents a complete solution. Choose two.

  A. Press Ctrl+A twice
  B. Click the Select Entire region button
  C. Press Ctrl+A
  D. Click the Select All button
  A. Press Ctrl+A twice
  D. Click the Select All button

  ---

  explanation:

  According to the question, you are required to select entire worksheet including the blank cells. In order to accomplish the task, you can take either of these two steps:

  Press Ctrl+A twice.

  Click the Select All button.

  

  Microsoft Excel provides various ways to select cells or ranges based on a user's requirement. The following table describes the action to be taken for different requirements of selection:

  

  To cancel a selection of cells, click any cell on the worksheet. Answer: C is incorrect. Pressing Ctrl+A will select the current region. Answer: B is incorrect. No such button is available in Excel 2010.

• Question 9:

  You are editing a worksheet on Excel 2010. You are required to join two cells into one large cell. Which of the following tabs contains options for merging two or more cells into a large cell?

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

  ---

  explanation:

  You can find merge options in the Alignment ribbon of the Home tab. Excel 2010 provides four merge options for cells in Excel 2010. These options are described below:

  

• Question 10:

  You are editing a worksheet in Excel 2010. After doing formatting of your sheet, you insert column.

  

  You want to format column A as column B is formatted. Mark the tool that will help you in accomplishing the task.

  

  A. Check the answer below.

  ---

  explanation:

  

  Explanation: According to the question, you want to format column A as column B is formatted. In order to accomplish the task, you will use the format painter. The Format Painter is a formatting tool of Microsoft office. It is used to copy the

  format of the selected text and paste the selected attributes to the target text. By using the Format Painter, a user can copy various formatting attributes, such as font size, font style, indentation, alignment, etc.

  It helps to save time and duplicated effort. It eliminates the effort of manually applying the font, font effects, centered paragraph alignment, and other formatting to each new section heading. A user can quickly copy all of the formatting

  attributes by using one toolbar button, i.e., the Format Painter button.