CGS 2518 CHAPTER #6 EXAM
QUESTIONS AND ANSWERS
"A" update - Answer-indicates the link is updated automatically when you open the
workbook or when both the source and destination
"M" Update - Answer-link must be manually updated by the user
Status - Answer-shows whether excel successfully accessed the link and updated the
values from the source document -> status will read OK. Or excel has not attempted to
update the links in this session -> UNKNOWN
Template - Answer-workbook with labels, formats, and formulas already built into it with
data removed.
Hyperlink - Answer-a link in a file such as a workbook to information within that file or
another file.
default template - Answer-blank template that shows up when you open excel. no text
or formulas. calibri 11 font, labels aligned to the left, numbers and values to the right,
column width 8.43, three worksheets in the workbook.
custom template - Answer-created by the user
office web apps - Answer-web based versions of microsoft office programs.
windows live - Answer-used for use of office web apps
Function to calculate the value at the end of a financial transaction - Answer-FV
Function to calculate the interest percentage per period of a financial transaction -
Answer-RATE
Function to calculate the value at the beginning of a financial transaction - Answer-PV
Function to calculate the number of compounding periods in a financial transaction -
Answer-NPER
Function to calculate periodic payments into or out of a financial transaction - Answer-
PMT
Use a 0 for this argument to indicate that interest will be paid at the end of each
compounding period - Answer-TYPE
QUESTIONS AND ANSWERS
"A" update - Answer-indicates the link is updated automatically when you open the
workbook or when both the source and destination
"M" Update - Answer-link must be manually updated by the user
Status - Answer-shows whether excel successfully accessed the link and updated the
values from the source document -> status will read OK. Or excel has not attempted to
update the links in this session -> UNKNOWN
Template - Answer-workbook with labels, formats, and formulas already built into it with
data removed.
Hyperlink - Answer-a link in a file such as a workbook to information within that file or
another file.
default template - Answer-blank template that shows up when you open excel. no text
or formulas. calibri 11 font, labels aligned to the left, numbers and values to the right,
column width 8.43, three worksheets in the workbook.
custom template - Answer-created by the user
office web apps - Answer-web based versions of microsoft office programs.
windows live - Answer-used for use of office web apps
Function to calculate the value at the end of a financial transaction - Answer-FV
Function to calculate the interest percentage per period of a financial transaction -
Answer-RATE
Function to calculate the value at the beginning of a financial transaction - Answer-PV
Function to calculate the number of compounding periods in a financial transaction -
Answer-NPER
Function to calculate periodic payments into or out of a financial transaction - Answer-
PMT
Use a 0 for this argument to indicate that interest will be paid at the end of each
compounding period - Answer-TYPE
