Free 77-882 Braindumps

A. You should advise Kara to create a custom list for each department that contains the names
of the employees.
B. You should advise Kara to create a workbook saved as a template for each department that
contains the names of the employees.
C. You should advise Kara to create a single workbook saved as a template with the names of
the employees listed in separate columns for each department.
D. You should advise Kara to create a single workbook saved as a template with the names of
the employees listed in separate rows for each department.

Answer(s): A

QUESTION: 16
You work as an Office Assistant at Company.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?

A. Use the Select Al Sheets function. Click one of the sheets and enter the value into cell B2.
B. Use the Select Al Sheets function and enter the value into cell B2 on the active sheet.
C. Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet.
D. Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into
the other sheets.

Answer(s): B
QUESTION: 17
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. PV()
B. RATE()
C. LOAN()
D. PMT()

Answer(s): D
QUESTION: 18


9

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com