Free 77-882 Exam Dumps PDF Preview

Question 1

Lab simulation

FILL BLANK

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft 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.

Reveal model answer Close model answer

Explanation: The Fill command is used to fill the active cell with the content of the adjacent cell. The Fill command is run through Home tab >
Editing group > Fill.

Click the Down, Right, Up, Left, or Series option to fill cells.

Question 2

Single choice

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

Reveal answer details Close answer details

Correct answerD

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 3

Single choice

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.

Reveal answer details Close answer details

Correct answerD

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 4

Single choice

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.

Reveal answer details Close answer details

Correct answerC

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 5

Lab simulation

FILL BLANK

You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have created an yearly sales report. The fragment of the report is shown below:

As the report is quite wide, printing this report involves three A4 size pages. You want the first column (column A) to repeat in every printed page. Mark the option that you will choose to accomplish the task.

Reveal model answer Close model answer

Explanation: The question states that the report is quite wide and takes three pages to print. You are required to repeat column A in each printed page. In order to repeat the column in every printed page, you will have to take the following steps: Choose the Print Titles option in the Page Setup group on the Page Layout tab. This will open the Page Setup window.

In the Columns to repeat at left option, provide the required column value.

These steps will enforce Excel to repeat column A at the left side of each printed page.

Question 6

Single choice

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team using Microsoft Excel. You want the report to appear in the following format:

You want the Remark column to be filled through a conditional formula. The criteria to give the remark is as follows: If the sales of the First Quarter is greater than or equal to 1200, display "Well Done" If the sales of the First Quarter is lesser than 1200, display "Improve in Next Quarter" You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

Which of the following conditional formulas will you insert to accomplish the task?

A
=IF(E2>1200,"Improve in Next Quarter","Well Done")
B
=IF(E2>=1200,"Well Done","Improve in Next Quarter")
C
=IF(E2>=1200,"Improve in Next Quarter","Well Done")
D
=IF(E2<=1200,"Well Done","Improve in Next Quarter")

Reveal answer details Close answer details

Correct answerB

Explanation

In order to accomplish the task, you will have to insert the following formula in the F2 cell:
=IF(E2>=1200,"Well Done","Improve in Next Quarter")

Question 7

Single choice

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

Reveal answer details Close answer details

Correct answerC

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

Lab simulation

FILL BLANK

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.

Reveal model answer Close model 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.

Question 9

Single choice

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010.
The report worksheet will include the sales made by all the sales managers in the month of January.

In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January.

Which of the following charts will you use to accomplish the task?

A
Line
B
Pie
C
Column
D
Bar

Reveal answer details Close answer details

Correct answerB

Explanation

In order to accomplish the task, you will have to insert a pie chart in the worksheet. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet. Pie charts display the size of items in one data series, proportional to the sum of the items.

The items in the pie chart are displayed as a percentage of the whole pie. Answer: C is incorrect. Excel provides column chart facility to display data that is arranged in columns or rows on a worksheet. In column charts, categories are organized along the horizontal axis and values along the vertical axis.

Column charts are used for showing data changes over a period of time or for illustrating comparisons among items.
Answer: A is incorrect. Excel provides a column chart facility to display data that is arranged in columns or rows on a worksheet. Line charts are used to display continuous data over time, set against a common scale. In a line chart, category data is distributed along the horizontal axis, and all value data is distributed along the vertical axis. Line charts are ideal for showing trends in data at equal intervals.

A line chart should be used where category labels are text, and are representing evenly spaced values such as months, quarters, or years.
Answer: D is incorrect. A bar chart is a feature provided in excel to graphically display data that is arranged in columns or rows on a worksheet. Bar charts are used for illustrating comparisons among individual items.

Bar charts are useful where axis labels are long.

VOL	TYPE	QUESTIONS
1	Single choice	6
2	Lab simulation	3

Free 77-882 Exam Dumps Preview

Excel 2010

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9