Excel Module 5: Managing Multiple Workbooks

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