CGS 2518 FINAL EXAM QUESTIONS
WITH COMPLETE ANSWERS
A field that is present in both tables, different tables are combined using this - Answer-
comment field
A collection of data values organized in a way so that they can be easily retrieved and
manipulated by the end-user - Answer-database
This is where databases are stored. It is a collection of data values arranged in rows or
records and columns or fields - Answer-tables
Retrieve data from multiple database tables and stores the data values in an Excel
workbook. Curated in the wizard by displaying for dialog boxes in sequence - Answer-
Microsoft query
Contains only text and numbers without any formulas, graphics, special fonts or
formatted text - Answer-text file
Depend on the value in the active cell for their results; identified by tracer arrows -
Answer-dependent cells
Supply data values to the Active cell - Answer-precedent cells
Error value; means that the cell contains an incorrect function name in the formula -
Answer-#NAME?
Calculates the internal rate of return for investment - Answer-IRR function
Calculates the PV of a series of future cash flows - Answer-NPV function
The return rate for a series of future cash flow - Answer-IRR
Calculates the payment. Required to pay off the loan or reach investment goal -
Answer-PMT Function
Function calculate the number of payments required to pay off a loan or reach an
investment goal - Answer-NPER
Calculates the per period. Interest rate required to pay off a loan investment goal -
Answer-RATE function
Provides the schedule of payments used to pay off a loan - Answer-amortization
schedule
, Calculate the amount of the loan payment applied to the principal - Answer-PPMT
The length of time before an investment recovers its initial cost, which occurs when the
values change from negative to positive - Answer-payback period.
And interest rate that compares the value of current dollars to future dollars from a
series of cash flows - Answer-rate of return or discount rate
The difference between the present value of an investment in the initial expenditure on
that investment - Answer-NPV(Net present value)
Calculate the amount of a loan payment used to pay off interest - Answer-IPMT function
Calculates the present value of a loan or an investment - Answer-PV function
Calculates The declining balance depreciation in which it depreciates by a consistent
percentage each time - Answer-DB Function
Changes values by a constant percentage - Answer-growth trend
Changes values by a constant amount - Answer-linear trend
Is used to extend a series from a single value or a few values in order to protect values -
Answer-extrapolation
Is used to fill in a series when do you know the starting and ending values of that series
- Answer-interpolation
The process of allocating the original cost of an asset over the lifetime of the asset -
Answer-depreciation
Our expenses not directly related to production - Answer-general expenses
Consist of expenses directly related to production - Answer-lost of goods sold
Displays how much money a person or business makes or loses over A specified period
of time - Answer-income statement or profit and loss statement
A positive value that represents money coming to the investor - Answer-positive cash
flow or cash inflow
A negative value that represents cash going away from the investor - Answer-negative
cash flow or cash outflow
Calculates the future value of a loan or an investment - Answer-FV Function
WITH COMPLETE ANSWERS
A field that is present in both tables, different tables are combined using this - Answer-
comment field
A collection of data values organized in a way so that they can be easily retrieved and
manipulated by the end-user - Answer-database
This is where databases are stored. It is a collection of data values arranged in rows or
records and columns or fields - Answer-tables
Retrieve data from multiple database tables and stores the data values in an Excel
workbook. Curated in the wizard by displaying for dialog boxes in sequence - Answer-
Microsoft query
Contains only text and numbers without any formulas, graphics, special fonts or
formatted text - Answer-text file
Depend on the value in the active cell for their results; identified by tracer arrows -
Answer-dependent cells
Supply data values to the Active cell - Answer-precedent cells
Error value; means that the cell contains an incorrect function name in the formula -
Answer-#NAME?
Calculates the internal rate of return for investment - Answer-IRR function
Calculates the PV of a series of future cash flows - Answer-NPV function
The return rate for a series of future cash flow - Answer-IRR
Calculates the payment. Required to pay off the loan or reach investment goal -
Answer-PMT Function
Function calculate the number of payments required to pay off a loan or reach an
investment goal - Answer-NPER
Calculates the per period. Interest rate required to pay off a loan investment goal -
Answer-RATE function
Provides the schedule of payments used to pay off a loan - Answer-amortization
schedule
, Calculate the amount of the loan payment applied to the principal - Answer-PPMT
The length of time before an investment recovers its initial cost, which occurs when the
values change from negative to positive - Answer-payback period.
And interest rate that compares the value of current dollars to future dollars from a
series of cash flows - Answer-rate of return or discount rate
The difference between the present value of an investment in the initial expenditure on
that investment - Answer-NPV(Net present value)
Calculate the amount of a loan payment used to pay off interest - Answer-IPMT function
Calculates the present value of a loan or an investment - Answer-PV function
Calculates The declining balance depreciation in which it depreciates by a consistent
percentage each time - Answer-DB Function
Changes values by a constant percentage - Answer-growth trend
Changes values by a constant amount - Answer-linear trend
Is used to extend a series from a single value or a few values in order to protect values -
Answer-extrapolation
Is used to fill in a series when do you know the starting and ending values of that series
- Answer-interpolation
The process of allocating the original cost of an asset over the lifetime of the asset -
Answer-depreciation
Our expenses not directly related to production - Answer-general expenses
Consist of expenses directly related to production - Answer-lost of goods sold
Displays how much money a person or business makes or loses over A specified period
of time - Answer-income statement or profit and loss statement
A positive value that represents money coming to the investor - Answer-positive cash
flow or cash inflow
A negative value that represents cash going away from the investor - Answer-negative
cash flow or cash outflow
Calculates the future value of a loan or an investment - Answer-FV Function
