77-882 - Excel 2010

Go back to Microsoft

Exam FAQ

What is the best way to study for the 77-882 exam?

Example Questions

Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010. You are working on a Sales report for the last quarter. You insert a table into a worksheet and populate the table with the names of the Sales people and their total sales over the last three months. Which of the following Excel functions can you NOT do if your workbook contains a table? You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report. Some of the cells in a worksheet are formatted using the Heading1 style and some are formatted using the Heading2 style. You select one of the cells formatted with the Heading1 style and press the Delete button on the keyboard. When you enter some new text into the cell, you discover that the new text is formatted with the Heading1 style. You want to delete the text and the formatting from all the cells formatted with the Heading1 or Heading2 styles. You select all the formatted cells and select the Clear icon in the Editing group on the Home tab. Which option should you select to delete the formatting and the contents of the selected cells? You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003. The computers in the Sales office run either Windows 7 Professional or Windows XP Professional. All computers have monitors with the display resolution set to 1024 x 768 pixels. A sales assistant named Kara Lang complains that she does not see all of the icons or the text to describe the commands on the Ribbon when compared to other computers. What should you do to resolve the problem? You work as a Sales Assistant at ABC.com. All users in the Sales department run Microsoft Office 2010. You currently have Excel 2010 open and are working on a new workbook. You want to open an existing workbook that is saved in your Documents folder. Which two of the following methods could you use to open an existing workbook? Choose two. You have been hired as an Accounts Auditor for ABC.com. The Accounts Manager has given you a workbook that he created using Microsoft Office Excel 2010. The workbook has multiple worksheets and contains several formulas. You select a cell in a worksheet. How can you view which formulas refer to the cell? 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 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 save the workbook and share it. One month later, you modify the workbook by adding a formula to a cell in one of the worksheets. The formula pulls data from other worksheets in the workbook. The formula does not work as expected. You suspect that the some of the data in the workbook is invalid. You select some cells and want to validate the data. You navigate to the Data tab but the Data Validation option is unavailable. What do you need to do before you can configure data validation rules? 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? Your work at ABC.com includes the preparation of company documents using Microsoft Office The workbook contains sensitive information. You want the word CONFIDENTIAL to be displayed on every page when the workbook is printed. You have a picture file named confidential.gif that contains the required CONFIDENTIAL message. What should you do with the picture file? You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report. You have data on three worksheets in the financial report. A formula in a cell on the third worksheet pulls data from cells in the first and second worksheets in the workbook. You want to view the value of the cell containing the formula while you make changes to the values of cells in the first worksheet. How can you view the value of the cell containing the formula on Sheet3 while working on Sheet1? You work as the Finance Manager at ABC.com. It is the end of the financial year and you are auditing the accounts for the last year. You have imported the records from last year’s company bank statements into a Microsoft Office Excel 2010 workbook. You want to list all payments to a partner company named Weyland Industries with the category name of Services. How can you configure the workbook to display only the records that contain Weyland Industries and Services? You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create and edit workbooks. Your workbook has multiple worksheets and each worksheet has many rows of information. You want to make several formatting changes to every cell in the workbook. You need to ensure that every cell has the same formatting. What is the easiest way to apply several formats to the cells throughout a workbook? You work as the Financial Director at ABC.com. You are using Microsoft Office Excel 2010 to review the end-of-year financial reports from the ABC.com Sales department and from a partner company named Weyland Industries. Weyland Industries is based in Mexico. The Weyland Industries financial report contains some text written in Spanish. To discover the meaning of the Spanish text, you navigate to the Proofing group on the Review tab and click the Translate button. Which of the following would also give you the option to translate the Spanish text? You work as an Office Administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook. When completed, the workbook will be sent to other users in the Sales department, company managers and board members. You have completed the workbook. You want to ensure that all hidden rows and columns, comments and personal information are removed from the workbook before you distribute it. What should you do before sending the workbook? You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports. You have finished creating a monthly company performance report. You will send the document to the company Managing Director when you have finished it. The Managing Director will need to ensure that the document he receives is the original document that you created. How can you ensure the integrity of the document? Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010. You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter "Monday" in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday.... down to cell C10. You drag the fill handle again and this time you click the AutoFill button. Which AutoFill option should you select to have Monday entered in cells C2 to C10? 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 sales of the company's product. The workbook will be updated by Sales Account Managers. You save the workbook to a network location and enable sharing of the workbook. You select the option to allow changes by more than one user at the same time. You want to keep any changes made by the Sales Account Managers for 60 days. How can you configure Excel to save changes for 60 days? You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports. It is the end of the financial year and you are working on a final sales report for the year. A copy of the report will be handed out to Sales Account Managers and Senior Management for discussion in an annual Sales Review meeting. There are five worksheets in the workbook, one worksheet for each quarter and a fifth worksheet with combined totals and analysis of the quarterly figures. You have entered all the data for each quarter and configured tables for the data. On the fifth worksheet, you have included graphical representations of the data using various types of charts. You now want apply a consistent formatting across the entire workbook. You want to give the workbook a professional look by applying graphics effects, light colors and easy to read fonts. What is the easiest way to prepare the workbook? 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 the Financial Controller at an engineering company. The company is considering taking out a loan to purchase some new machinery. You are in the process of evaluating the payment options for different loan amounts over different repayment periods. You are using Microsoft Office Excel 2010 to calculate the repayments. Assuming a constant interest rate and constant monthly payments, which Excel function would you use to calculate the loan repayments? You work in the Sales office at Weyland Industries. You are using Microsoft Office Excel 2010 to prepare a financial report. The report will be sent to managers at a partner company named ABC.com. ABC.com users use various versions of Microsoft Office including Microsoft Office 2003, 2007 and 2010. You need to ensure that your financial report can be viewed You should consider the managers at ABC.com irrespective of which version of Microsoft Office they are using. How can you ensure that the Excel features used in your spreadsheet are compatible with previous versions of Excel? You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report. You want to print copies of the report to distribute to other employees in a meeting. The report uses several columns. You view the printable area of the worksheet and see that the columns do not fit on a single page. To be able to print all the columns on a single page without scaling down the page, you want to change the layout of the worksheet from portrait to landscape. How can you change the layout to landscape? You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to edit a Sales report. The workbook contains twelve worksheets named January through December. Each worksheet contains a sales table listing the names of the Sales staff and the values of their sales for that month. The format and layout of the table is identical on each worksheet. You add another worksheet named Totals and Analysis to the Sales report workbook. You want to create formulas in the Totals and Analysis worksheet that use references to sales values from the tables on the other worksheets. What type of cell reference is used to refer to the same cells on multiple worksheets within a workbook? Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010. You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated. Which Excel function should you make use of in your spreadsheet? 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? You work as the Sales Manager at ABC.com. Sally works as an Office Assistant in the Sales Office. You have asked Sally to create a sales report on the sales targets for the previous quarter. Sally uses Microsoft Office Excel 2010 to create the report. Sally uses multiple conditional formatting rules to change the styles of the cells according to certain conditions. Sally completes the report and emails it to you. However, when you open the report, it does not look how it should according to your instructions. You note that only a few of the required conditional formatting rules are applying. Which of the following actions should you take? You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook. The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month. You want to enter a value in the cell B2 on each worksheet. What is the easiest way to insert the same value into the same cell on all worksheets in a workbook? Kara Lang works as the Human Resources manager at ABC.com. She is using Microsoft Office Excel 2010 to create a workbook. The workbook will be used to record days taken off for vacations or illness. The company contains departments named Sales, Marketing, Production and IT. Kara often needs to enter the names of company employees when she creates workbooks. Kara wants to be able to use the Fill Handle function to ease the task of entering names in a workbook. She asks you for assistance in enabling the Fill Handle function. How can you help Kara? 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 need to restrict the type of information that users can enter into the workbook. You want to ensure that customer's names are spelt correctly by using a list for users to select from and you want to limit the cells that users can enter numbers into. You also want users to be presented with a message when they enter invalid data. Which function of Excel should you use? Kara Lang works as the Financial Controller at ABC.com. She is using Microsoft Office Excel 2010 to edit multiple workbooks. She has workbooks open from different shared folders on the network. Kara often works on the same set of workbooks simultaneously and it takes her some time to connect to each folder location and open the individual workbooks. Kara has asked you to recommend a solution that makes opening the workbooks simpler and less time consuming. Which of the following solutions should you recommend? You work as the Finance Manager at ABC.com. It is the end of the financial year and you are auditing the accounts for the last year. You have imported the records from last year's company bank statements into a Microsoft Office Excel 2010 workbook. You want to list all payments to a partner company named Weyland Industries with the category name of Services. How can you configure the workbook to display only the records that contain Weyland Industries and Services? Your work at ABC.com includes the preparation of workbooks using Microsoft Office Excel 2010. You have finished a lengthy report about product sales for the past year and project sales for the next year. The workbook lists the name of a product multiple times. The company releases a new version of the product and the product name is changed to reflect the update. You want to use the Replace dialog box to change every instance of the product name throughout the spreadsheet. Which of the following key combinations opens the Replace dialog box? 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? 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 sales of the company’s product. The workbook will be updated by Sales Account Managers. You save the workbook to a network location and enable sharing of the workbook. You select the option to allow changes by more than one user at the same time. You want to keep any changes made by the Sales Account Managers for 60 days. How can you configure Excel to save changes for 60 days? 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? You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003. You are currently working on a Sales report in Microsoft Office Excel 2010. You maximize the worksheet viewing area by selecting the Full Screen option on the View tab. When you select Full Screen, all toolbars and menus disappear. How can you restore the worksheet view back to the Normal View so that you can see the toolbars? You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a document. The document will be sent to other users in the Sales department when completed. The Excel workbook contains three tabs with data on each tab. The tabs are named Sheet1, Sheet2 and Sheet3. While working on Sheet1, you navigate to the Review tab and click the Protect Sheet button. You leave the default options, enter a password and click ok. What effect will this have on the workbook? 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 save the workbook and share it. One month later, you modify the workbook by adding a formula to a cell in one of the worksheets. The formula pulls data from other worksheets in the workbook. The formula does not work as expected. You suspect that the some of the data in the workbook is invalid. You select some cells and want to validate the data. You navigate to the Data tab but the Data Validation option is unavailable. What do you need to do before you can configure data validation rules? Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010. You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter “Monday” in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday…. down to cell C10. You drag the fill handle again and this time you click the AutoFill button. Which AutoFill option should you select to have Monday entered in cells C2 to C10? Your work at ABC.com includes the preparation of company documents using Microsoft Office 2010. You are using Microsoft Office Excel 2010 to create a workbook. The workbook contains sensitive information. You want the word CONFIDENTIAL to be displayed on every page when the workbook is printed. You have a picture file named confidential.gif that contains the required CONFIDENTIAL message. What should you do with the picture file? You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales summary that will be printed out and handed to senior management. You want to ensure that you can print the sales summary in a single page without the need for scaling. How can you configure Excel to display a worksheet as it would appear on a printed page while you are working on the spreadsheet? 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 need to restrict the type of information that users can enter into the workbook. You want to ensure that customer’s names are spelt correctly by using a list for users to select from and you want to limit the cells that users can enter numbers into. You also want users to be presented with a message when they enter invalid data. Which function of Excel should you use?

Study Guides