[2026] Microsoft Excel 2010 - 77-882 무료 시험 문제

문제1

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?

A. You should select the Clear All option.

B. You should select the Clear Comments option.

C. You should select the Clear Formats option.

D. You should select the Clear Contents option.

정답: A

문제2

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in
Excel 2010. You want to insert flow-chart in the sheet. Mark the option that you will choose to
insert flow- chart symbols in the report.

정답:

Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple
objects provided by Microsoft Office to add them to a document. A single shape or combined
multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines,
basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts.
Users can add text, bullets, numbering, and Quick Styles to these shapes after inserting them in the
document. Take the following steps to add a shape in a document:
1.Click on the Shapes option in the Illustrations group on the Insert tab. This will open the list of
shapes available in Microsoft Office.

2.Choose the required shape from the list.

문제3

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?

A. RATE()

B. PMT()

C. LOAN()

D. PV()

정답: B

문제4

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?

A. You should consider making use of the Sort Ascending function.

B. You should consider making use of the Sort Descending function.

C. You should consider making use of the Hide function.

D. You should consider making use of the AutoFilter function.

정답: D

문제5

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?

A. You should recommend that Kara creates an Excel Workspace that references the workbooks.

B. You should recommend that Kara creates shortcuts to all the workbooks and saves the shortcuts to a single folder.

C. You should recommend that Kara moves all the workbooks to a single folder.

D. You should recommend that Kara creates a new workbook that contains references to the workbooks.

정답: A

문제6

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. Select the Colors option in the Themes group on the Page
Layout page.

C. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color option
from the shortcut menu.

D. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Tab Color option
from the shortcut menu.

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제7

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report ready for a meeting with ABC.com senior management.
You want to print a table from your financial report.
Which combination of the following steps will print the table without printing the rest of the worksheet? Choose three.

A. Click the File tab button > Print.

B. Select Print Active Sheet in the Print Settings section.

C. Select the worksheet that contains the table.

D. Select Print Selection in the Print Settings section.

E. Click the File tab > Print > Print Preview.

F. Select Print Selected Table in the Print Settings section.

G. Select the table.

정답: A,F,G

문제8

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.

정답:

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.
Reference:
Microsoft Excel Help, Contents: "Fill data automatically in worksheet cells"

문제9

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.

정답:

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.

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.

Microsoft Excel 2010 - 77-882무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트