NEW
Font size
WorksheetsExcel Module 5: Managing Multiple Workbooks
Total questions: 24
Worksheet time: 12mins
What is a data table?
A data table is a collection of rows and columns used to organize and display information.
A data table is a type of graph used to represent data visually.
A data table is a software application for data analysis.
A data table is a programming language for data manipulation.
An amortization schedule is:
A detailed plan for paying off a loan over time
A type of investment strategy
A method for calculating interest rates
A financial statement for a company
The PMT function is used for:
Calculating the payment for a loan based on constant payments and a constant interest rate.
Determining the principal amount of a loan.
Calculating the total interest paid over the life of a loan.
Estimating the future value of an investment.
The FV function is used to calculate:
Future Value of an investment
Frequency of a variable
Final Velocity in physics
Frictional Value in mechanics
What is a cell name in a spreadsheet?
A unique identifier for a cell
The content of a cell
The color of a cell
The formula used in a cell
What is cell protection in a spreadsheet?
A feature that prevents changes to the content of a cell
A tool to format cells
A function to calculate data
A method to sort data
A formula checker is:
a tool that verifies the correctness of mathematical formulas
a device used to measure temperature
a software for editing documents
a machine for printing papers
A one-input data table is used to analyze how changes in one variable affect the results of a formula.
True
False
What is a one-variable data table?
A table that uses one variable to display data
A chart that uses two variables to display data
A graph that uses multiple variables to display data
A diagram that uses no variables to display data
The PV function is used for:
Calculating the present value of an investment
Determining the future value of an investment
Calculating the interest rate of a loan
Determining the monthly payment of a mortgage
A range of cells that shows the resulting values when one or more input values are varied in a formula; in a chart, a grid containing the chart data is called a ____.
data table
chart grid
value matrix
result sheet
A schedule that shows loan balances and the payment amounts applied to principal and interest for each payment period is called a ____.
loan amortization schedule
payment ledger
interest breakdown chart
principal payment table
The financial function that calculates the payment schedule required to repay a loan based on constant payments and a constant interest rate is called a ____.
loan amortization schedule
loan interest calculator
loan repayment tracker
loan balance estimator
A function that returns the future value of an investment based on scheduled payments and an unchanging interest rate is called a ____.
future value of an investment function
present value function
net present value function
internal rate of return function
A name assigned to a cell or cell range that can be used in formulas is called a ____.
named range
cell reference
data label
formula name
Techniques that ensure users do not inadvertently change values that are critical to the worksheet are called ____.
Data Validation
Conditional Formatting
Cell Locking
Worksheet Protection
A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators such as +, -, *, and / is called a ____.
formula
function
equation
expression
A range of cells that shows resulting values when one input value in a formula is changed is called a ____.
data table
pivot table
chart
range
Also called a one-input data table, a range of cells that shows resulting values when one input value in a formula is changed is called a ____.
data table
pivot table
chart
graph
A function that returns the present value of an annuity is called a ____.
present value of an annuity
future value of an annuity
interest rate
amortization schedule
What is a two-input data table?
A table with two rows
A table with two columns
A table that uses two sets of input values
A table with two headers
An annuity is a financial product that provides a series of payments at regular intervals. What is an annuity?
A type of insurance policy
A financial product providing regular payments
A savings account
A type of loan
A series of fixed payments made at the end of each fixed period at a fixed interest rate is called:
Annuity
Perpetuity
Amortization
Sinking Fund
A data table in which you can vary the value in two cells and then see the recalculated results is called:
a two-variable data table
a pivot table
a single-variable data table
a chart
