BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 83

macrosprogramsprocedures
Question 10. Question :
(TCO 2) To simplify entering ranges in
formulas, you can use _____.
range names
a cell's relative locationboth an absolute and a relative cell reference
a cell's specific location
Question 11. Question :
(TCO 2) When calculating a PMT
function, the RATE would be described best by which of the
following?
It is the periodic interest rate, such as a monthly interest rate.
It is the total number of payment periods.
It is a word or a string of characters that represent one or more
cells.It is the present value of the loan.
Question 12. Question :
(TCO 7) A _____ helps to ensure
consistency and standardization for similar workbooks, such as
detailed income statements for all 12 months in a year.
templatemacro
web query
functionQuestion 13. Question :
(TCO 7) To unlock cells, click
the _____ tab, then click Format in the Cells group and select Lock
Cell.
homepage layout