Microsoft 77-882 Actual Free Exam Questions & Community Discussion

You work as the Sales Assistant at ABC.com. The Sales Manager has sent you a workbook containing a sales report and asked you to edit it. You open the sales report using Microsoft Office Excel 2010.
You are currently using the default Normal view to view the workbook. You have seen a printed version of the sales report. The printed version has a page header that contains the title of the sales report. However, you cannot see the header when viewing the workbook in normal view.
Which Excel view would display the header and footer placeholders while allowing you to edit the cells in the worksheet?

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.

Martha works as an Office Executive for Tech Profile Inc. She uses Microsoft Excel 2010 to create
office reports. She often needs to fill names of all employees in each department of the company in
her reports. Which of the following steps should she take to ease her task?

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Excel 2010.
He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will
choose to accomplish the task.

You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network.
You want to arrange the workbook windows so that you can view the titles of all the workbooks that you have open.
How should you configure the view?

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.

You work in the office at ABC.com. Your computer has just been uABCraded from Microsoft Office 2007 to Microsoft Office 2010.
You create a workbook using Microsoft Office Excel 2010. Microsoft Office 2010 has a new feature called the Backstage View. The Backstage View gives you access to functions that affect the workbook as a whole and to settings that affect the application itself.
How do you get to the Backstage View?

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook will be used to track deployments of the company's product to customers. The workbook will be updated by members of the deployment team and by other users in the Sales department.
You want to be able to view the changes made to the workbook. You save the workbook to a network location and enable the Track Changes option.
Some users complain that when they open the workbook, it opens in Read Only mode.
How can you ensure that multiple users can open the workbook in Edit mode?