Microsoft 77-882 Online Practice Questions and Exam Preparation

Microsoft 77-882 Online Questions & Answers

• Question 1:

  You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2010. Your workbook includes several worksheets as shown in the image given below:

  

  You want the sheet tabs of the sheets containing charts to appear in red color. Which of the following steps will you take to accomplish the task?

  A. Select the sheets containing charts. Select the Effects option in the Themes group on the Page Layout page.
  B. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.
  C. Select the sheets containing charts. Select the Colors option in the Themes group on the Page Layout page.
  D. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color option from the shortcut menu.
  B. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.

  ---

  According to the question, you want the sheet tabs of the sheets containing chart to appear in red color. In order to accomplish the task, you will have to take the following steps: 1.Select the sheets containing charts.

  

  2.Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.

  

• Question 2:

  You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in Excel 2010. Before creating a final report, you are required to test some logical conditions. You enter test data in a worksheet in the report. The fragment of the sheet is shown below:

  

  You are testing logical conditions to use them in your report later. Which of the following conditional formulas will return "True"?

  A. =OR(E3>E4, E3
  B. =AND(E3E5)
  C. =AND(E3>E4, E3
  D. =NOT(E3+E4=34)
  A. =OR(E3>E4, E3

  ---

  By using the AND, OR, NOT functions and other mathematical operators, you can create a conditional formula that results in a logical value. In the current scenario, the following formula will return "True" value:

  =OR(E3>E4, E3

  The OR() function in Excel evaluates logical values and returns the value "True" if any argument is true. The function returns "False" only when all the arguments are false.

  Syntax

  OR(LogicalCondition1,LogicalCondition2,..)

  Here, LogicalCondition1, LogicalCondition2 are test conditions that can be either TRUE or FALSE. There can be 1 to 255 logical conditions that can be provided as arguments with the OR() function.

  Example

  

  The OR() function can also be used to evaluate values in arrays. Answer: C and B are incorrect. The given formula will return "False" as at least one of the arguments is false. The AND()

  function in Excel evaluates logical values and returns the value "True" if all arguments are true. The function returns "False" if one or all arguments are false.

  Syntax

  AND(LogicalCondition1,LogicalCondition2,..)

  Here, LogicalCondition1, LogicalCondition2 are test conditions that can be either TRUE or FALSE. There can be 1 to 255 logical conditions that can be provided as arguments with the AND() function.

  Example

  

  The AND() function can also be used to evaluate values in arrays. Answer: D is incorrect. The given formula will return "False" as the given argument is true. The NOT() function in Excel reverses the value of its argument.

  Syntax

  AND(LogicalCondition)

  Here, Logical is a value or expression that can either be TRUE or FALSE. If logical is FALSE, NOT() returns TRUE; if logical is TRUE, NOT() returns FALSE.

  Example

  

• Question 3:

  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. Normal
  B. Print Preview
  C. Page Layout
  D. Page Break
  C. Page Layout

  ---

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

  

  The Page Layout View is one of the several views provided by Excel. This view was 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: A is incorrect. The Normal view will not allow you to work on your worksheet while showing how it will appear in printed format.

  Answer: D 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: B is incorrect. There is no such view as Print Preview in Excel 2010.

• Question 4:

  You work as an Office Assistant for Peach Tree Inc. You have created a sales report worksheet in Excel 2010. In the worksheet, you have created a chart to visually summarize the sales achieved by Mark:

  

  You want to transfer the chart to a new worksheet named MarkSales. Which of the following steps will you take to accomplish the task?

  

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

  ---

  

  Explanation: In order to accomplish the task, you will have to take the following steps: Select the chart.

  

• Question 5:

  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.

  

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

  ---

  

  Mark the option that you will click to accomplish the task. 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.

  

• Question 6:

  Rick works as an Office Executive for Perfect Wear Inc. He uses Microsoft Excel 2010 to maintain sales record of each day. He needs to print the daily sales report. The management of the company wants to ensure that each crucial report

  printed, must print a picture named conf.gif as a watermark showing the confidential message.

  Which of the following options should he use to accomplish the task?

  A. Use Page Layout > Page Setup > Background.
  B. Use Insert > Text > Headers and Footers.
  C. Use Insert > Illustrations > Picture.
  D. Use Page Layout > Page Setup > Print Titles.
  B. Use Insert > Text > Headers and Footers.

  ---

  Excel does not provide a facility to use image as a watermark. However, a user can mimic this facility by using the Header and Footer option. If Rick wants to display an image on every printed page, he can insert the image in a header or footer. This configuration will enable the image to appear behind the text, at the top or bottom of every page. He can also resize or scale the graphic to fill the page. Answer: D is incorrect. Print Titles option is used to configure printing options of a worksheet. Answer: C is incorrect. Through the Picture option in Illustrations, pictures can be inserted into the sheet. But this cannot be

  used as watermark.

  Answer: A is incorrect. The Background option in the Page Setup group, on the Page Layout tab is used to add background in a worksheet. However, this background does not get printed while printing the sheet.

• Question 7:

  You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in Microsoft Excel 2010. You have to insert a Venn-diagram in a worksheet. Mark the option you will choose to accomplish the task.

  

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

  ---

  

  Explanation: In order to accomplish the task, you will have to choose the SmartArt option. Through the SmartArt option in Office 2010, you can insert complex graphics, such as a Venn-diagram in a document. SmartArt is a group of easily editable and formatted diagrams provided in Microsoft Excel. There are 115 preset SmartArt graphics layout templates, such as List, Process, Cycle, Hierarchy, etc. SmartArt graphics can automatically change their colors, fonts, and effects to match the document's theme. The SmartArt option appears under the Insert tab.

  

  Each SmartArt graphic maps the text outline onto the graphic and automatically resizes the graphic for best fit. A number of quick styles can be used for each graphic shapes. Users can also manually change SmartArt graphics colors, fonts, and effects to match the document's theme.

• Question 8:

  You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 to create different reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.

  

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

  ---

  

  Explanation: Excel provides multiple methods for fast data entry into a worksheet. These data entry techniques help users to quickly enter data wherever required. The following methods help users in speeding-up their data entry work:

  AutoFill: The AutoFill feature recognizes the series a user wants to enter and fills the series when the fill handle is dragged.

  FillSeries: In FillSeries method, a user enters the first two values in a series and then by selecting both the cells and dragging the selected cells through the fill handle, extends the series. AutoComplete: The AutoComplete feature provides

  users a facility to enter few words in a cell. If this entry matches with any of the entries done before in other cells, it suggests users for the same. The user can press the Enter key to get the same entry in the cell. Pick from Dro

  

  Ctrl + Enter: Ctrl + Enter key combination is used to quickly fill a range of cells with the same entry. For this, select a range of cells to contain the same data, type the data in the active cell, and press Ctrl + Enter keys.

• Question 9:

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

  ---

  In order to accomplish the task, you will have to choose one of the pre-built themes. Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document.

  

  Microsoft Excel 2010 comes with a large collection of pre-built themes. Users can create their own themes for a document. Themes can be specified through Page Layout > Themes. Answer: D is incorrect. The SmartArt option does not

  produce soothing graphic effects, soft fonts, and light colors.

  Answer: B and C are incorrect. These options involve manual processing. Therefore, any formatting done manually will increase the administrative burden.

• Question 10:

  You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that contains various tables, headings, charts, and SmartArt objects. In order to give it a professional look, you choose Office theme as shown below:

  

  You like the appearance of the sheet in this theme; however, you want to use the Lucida Calligraphy font for heading and Arial font for the body text. You often use this font combination for formatting office sheets. You are required to

  accomplish the following tasks:

  Use the font combination in your current document.

  Enable Excel to provide this combination in other office documents too.

  Choose the required steps to accomplish the tasks.

  

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

  ---

  

  Explanation: In order to accomplish the tasks, you will have to take the following steps: Choose the Fonts option in the Themes group on the Page Layout tab.

  

  Open the Create New Theme Fonts dialog box by clicking the Create New Theme Fonts option from the Theme Fonts list.

  

  In the dialog box, provide the required font names for header and body texts, provide name for the new theme.

  

  These steps will create a custom theme, which will be available for other office documents too.

  

  Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document. Microsoft Excel comes with a large collection of pre-built themes. Users can create their own themes for a document. Themes can be specified through Page Layout > Themes.