Advertisement Upgrade to remove ads

PMT allows you to determine a monthly payment for a loan

True

Cell protection is portions of a workbook that lets you show only the parts of the workbook that the user needs to see

False

The formula checker checks the formulas in a workbook in a manner similar to the way the spell checker checks for misspelled words.

True

Table is also called a database

True

Fields are data items that make up a record

True

A calculated column is a worksheet

False

Templates are special workbooks used to create a pattern

True

Business do not use templates ever.

False

Workbooks always have only two pages

False

A consolidation is the process of summarizing data included on multiple worksheets on one worksheet.

True

An alternative to a one-input table is a two-input table

True

A name assigned to a cell or cell range on one worksheet ina workbook cannot be used on other sheets in the same workbook to referenc ethe named cell or range.

False, they can

Excel does not allow you to format cells before you enter the values

False, it does

The HLOOKUP function is used when the table direction is vertical or down the worksheet

False(horizontal)

Conditional formatting allows you to create rules that change the formatting of a cell or rang eof cells based on teh value of a cell

True

The design tab on the ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly

True

When you select a template from the New Workbook or New dialog box to create a new workbook, Excel names the new workbook using the template name with an apppended digit 1

True

A workbook contains two worksheets by default

False

The number of worksheets you can have in a workbook is limited onlly by the amount of memory in your computer

True

Excel copies page setup characteristics when one sheet is copied to another

False, it does not.

To bold the Entire Worksheet, You click Orientation on the Page layout Tab.

False

You can Color a Cell by clicking the Fill button on the Reference Tab.

False

You can Center and Merge cells in an Excel worksheet.

True

To apply the title format to a cell it under cell style on the home tab.

True

Double clicka cell to adjust the font of text to fit in the cell

False

You can color the sheet tabs by the fill button on the home tab

False

Applying a border you can choose a medium or small line

True

=if(g3<=$e$3, PV($e$4), 0) is the PV function

True

After entering in a formula in any cell press the enter key to enter data.

True

The formula for entering a date is =0date

False

You can hide rows, columns, and sheets that contain sensitive data

True

Data is in descending sequence if it is sorted from A to Z

False

You can set up a criteria range and use it to manipulate records

True

Excel has 13 database functions

False

You can have multiple worksheets in Excel.

True

You can add text boxes to graphs using the shapes button

True

A header is printed at the top of every page in a printout

False

Cell protection does not ensure that users do not change values

False

An amortization schedule shows the beginning and ending balances of a loan

True.

The process of filtering activity based on one or more filter criteria is called a query.

True

The ____ checks forulas in a workbook in a manner similar to the way the spell checker checks for misspelled words

Formula checker

A field, or column, that contains formulas or functions is called a ____.

Calculated column

Data that is related to a person is called____.

Record

Data items that make up a record are called____.

Field

A table is also known as a ___.

Database

____ ensures that the data you enter into a cell or range of cells is within limits.

Data limiter

The process of summarizing data included on multiple worksheets on one worksheet is called___.

Consolidation

A special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets is called____.

Template

What function should be used on formulas that result in more decimal places than the format displays in a given cell?

ROUND function

The ___ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet and apply other special text formatting effects

WorArt

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