Spreadsheets Questions with Verified Answers Solved 100%
Each loan payment is referred to as a(n) - Answers period.
Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the
loan's ________. - Answers Your credit rating often influences the interest rate the lender will charge on
a loan.
You see ###### in a cell. This means that - Answers this is not an error. The cell needs to be expanded in
order to display the entire value.
When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign. - Answers
The equal sign (=) is the most important symbol in a spreadsheet. It indicates that the cell contains a
formula or a function.
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell
a(n) ________ reference. - Answers absolute
In spreadsheets, all functions and calculations begin with - Answers an equal sign (=).
Because they make it easy to arrange, display, and calculate numerical data, ________ programs are
commonly used in nearly every business setting. - Answers spreadsheet
Comma-separated format (.cvs) files are commonly used by those who are sending data but do not
know what spreadsheet the recipient uses. - Answers true
Select the spreadsheet formula that would correctly calculate the average (mean) of the following
values: 3, 2, 6, and 8. - Answers = (3 + 2 + 6 + 8) / 4
The total amount of money (principal + interest) that lender receives from a borrower at the end of the
loan is referred to as the loan's - Answers future value (FV).
Which two of the following refer to the amount of money a lender charges for borrowing money
(excluding any origination fees)? - Answers principal
Amount of money (principal) originally borrowed or owed - Answers Present Value (PV)
Annual percentage rate (APR) of interest - Answers Rate
Single payment - Answers Period
Length of loan in years - Answers Term
When displaying financial information, the accepted practice is that ________ indicates negative values.
- Answers red
Select two common uses of spreadsheets. - Answers word processing
Each loan payment is referred to as a(n) - Answers period.
Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the
loan's ________. - Answers Your credit rating often influences the interest rate the lender will charge on
a loan.
You see ###### in a cell. This means that - Answers this is not an error. The cell needs to be expanded in
order to display the entire value.
When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign. - Answers
The equal sign (=) is the most important symbol in a spreadsheet. It indicates that the cell contains a
formula or a function.
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell
a(n) ________ reference. - Answers absolute
In spreadsheets, all functions and calculations begin with - Answers an equal sign (=).
Because they make it easy to arrange, display, and calculate numerical data, ________ programs are
commonly used in nearly every business setting. - Answers spreadsheet
Comma-separated format (.cvs) files are commonly used by those who are sending data but do not
know what spreadsheet the recipient uses. - Answers true
Select the spreadsheet formula that would correctly calculate the average (mean) of the following
values: 3, 2, 6, and 8. - Answers = (3 + 2 + 6 + 8) / 4
The total amount of money (principal + interest) that lender receives from a borrower at the end of the
loan is referred to as the loan's - Answers future value (FV).
Which two of the following refer to the amount of money a lender charges for borrowing money
(excluding any origination fees)? - Answers principal
Amount of money (principal) originally borrowed or owed - Answers Present Value (PV)
Annual percentage rate (APR) of interest - Answers Rate
Single payment - Answers Period
Length of loan in years - Answers Term
When displaying financial information, the accepted practice is that ________ indicates negative values.
- Answers red
Select two common uses of spreadsheets. - Answers word processing
