77-882 무료 덤프문제 온라인 액세스

You are creating business report through Microsoft Office 2010. You want to add trend lines for

Choose the correct steps to accomplish the task.

정답:

Explanation:
In order to accomplish the task, you will have to take the following steps: Select the data range for
which trend lines are required.
Click the Insert tab and choose the Line option from the Sparkline ribbon.

Sparklines can be used in places where users need to show a snapshot of their data in an easy-to-
understand visual format.

John works as an Accounts Auditor for ABC.com. He is using Microsoft Office Excel 2010 to create a workbook.
John enters the following formula into a cell:
VLOOKUP (15, A4:D11, 4, FALSE)
Which two of the following options describe what action the formula performs? Choose two.

• A.Search for the value 15 in the last column of the rangeA4:D11.
• B.Search for the value 4 in the last column of the rangeA4:D11.
• C.Return the value that is contained in the 4th column of the range A4:D11 and on the same row as the value 15.
• D.Search for the value 15 in the first column of the rangeA4:D11.
• E.Search for the value 4 in the first column of the rangeA4:D11.
• F.Return the value that is contained in the 15th column of the range A4:D11and on the same row as the value 4.
• G.Return the value that is contained in the 4th column and the 15th row of the rangeA4:D11.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
You want to insert a Hierarchy Table like the one shown below into a worksheet.

Which Excel function should you use to insert a Hierarchy Table?

• A.You should use the SmartArt function in the Illustrations group on the Insert tab.
• B.You should use the Table function in the Table group on the Insert tab.
• C.You should use the ClipArt function in the Illustrations group on the Insert tab.
• D.You should use the Shapes function in the Illustrations group on the Insert tab.

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?

• A.The Lookup and Reference function in the Function Library group on the Formulas tab.
• B.The Research function in the Proofing group on the Review tab.
• C.The Thesaurus function in the Proofing group on the Review tab.
• D.The Format option in the Cells group on the Home tab.

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?

• A.You should use the Data Consolidation function on the Data tab.
• B.You should use the Format function on the Home tab.
• C.You should use the Data Validation function on the Data tab.
• D.You should use the Protect Workbook function on the Review tab.