Online Access Free 77-882 Practice Test

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. Some of the workbooks have the same name.
To avoid any confusion over which workbook you are currently working on, you want to display the full path and file name of the workbook in the workbook.
Which combination of the following actions would configure the workbook to display the filename and path in a worksheet cell? Choose all that apply.

• A.Select a cell in the workbook.
• B.Insert the formula =cell("filename").
• C.Navigate to the Insert tab and select the Header and Footer option.
• D.On the Design tab, select the File Name option.
• E.Insert the formula =filename("A1").
• F.Select the Header section.
• G.Select the Footer section.

You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the
fill handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the
Auto Fill button appears.

You do not want to display the Auto Fill button. You open the Excel Options window. Mark the
check box that you will clear to accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, you will clear the Show Paste Options buttons check box in the
cut, copy, and paste section of the Advanced Excel Options window.

You work in the Sales office at ABC.com. You are using Microsoft Office Excel 2010 to prepare a financial report.
The report is a complicated analysis of the company financial performance over the last year and projected growth for the next year based on the figures. The report will be sent to ABC.com board members.
You have used subtotals throughout the report to make it easier for you to verify the accuracy of the figures. After completing the report and verifying the totals, you want to remove the subtotals before you send the report to the board members.
Which combination of the following steps describes how to remove the subtotals from a worksheet? Choose two.

• A.Select the rows containing the subtotals.
• B.Click the Remove All button.
• C.Click the Subtotal option on the Data tab.
• D.Right click and select the Remove All Subtotals option from the context menu.
• E.Click the Delete key.
• F.Drag all the final totals.

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?

• A.Print Preview.
• B.Full Screen view.
• C.Page Layout view.
• D.Page Break Preview

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?

• A.You should select the Fill Days option.
• B.You should select the Fill Without Formatting option.
• C.You should select the Fill Formatting Only option.
• D.You should select the Copy Cells option.
• E.You should select the Fill Series option.