Advertisement Upgrade to remove ads

Assumptions

____are values in cells you can change to determine new values for formulas.

insert

The __ command on the shortcut menu allows you to insert rows between rows that already contain data.

Drag and drop

Using the mouse to move or copy cells is called____.

#Ref!

Excel displays the error message ____ to indicate a cell reference error.

Freeze

Excel allows you to __ titles, so that Excel displays the titles on the screen, no matter how far down you scroll.

Date stamp

The__ is used to show the date in a workbook.

Absolute cell reference

A formula using ___ instructs Excel to keep the cell reference constant as it is copied to other cells.

If Function

The __ is a useful function when you want to assign a value to a cell based on a logical test.

Drawing tool bar chart

The __ provides tools that can simplify adding lines, boxes and other geometric figures.

pie chart

A __ is a type of chart used to show the relationship or porportion of parts to a whole, with each slice representing what percent that slice contributes to the whole.

chart sheet

A chart can reside on a separate sheet, called a (n) __, which contains only the chart.

catergory names

The names that identify the slices of a pie chart are called___.

data series

The entries that determine the size of the slices in a pie chart are called____.

chart title

In step 3 of 4 in the chart wizard, the chart title is entered in the ___ text box.

Split

When working with a large worksheet, the Excel window can be __ into two or four window panes to view different parts of the worksheet at the same time.

Hiding

__portions of a workbook lets you show only the parts of the workbook that the user needs to see.

name

A cell name is created through the use of the __ command.

PMT

Excel's _ function is used to determine a monthly payment using the interest rate, the periods or number of payments and the loan amount.

data table

A __ is a range of cells tha shows the answers generated by formulas in which different values have been substituted.

table

The _ command on the data menu is uded to define a range of cells as a data table.

Amortization schedule

A ____shows the beginning and ending balances and amount of payment that applies to the principal and interest for each year over the life of the loan.

annunity

A__ is a series of fixed payments at a fixed interest rate.

PV Function

The __ function returns the present value of an annuity.

Unprotected cell

_________ are cells whose values you can change at any time.

protected cells

___________ cells are cells that you cannot change.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set