Exam 6: Excell: Introduction to Excel

Displaying cell formulas can help find errors in formulas more easily.

Match the following terms with their description: i. Paste Special II. Transpose III. Flash Fill IV. Accounting number format v. Currency number format

The ________ area is designed to contain formulas which are dependent on values in the input area.

A(n) ________ range contains multiple ranges that are not positioned in a contiguous cluster in the worksheet.

When you insert rows or columns all relative references are updated but not any absolute references.

Adding color to cells is considered a professional design strategy.

Which of the following is not a valid formula?

A(n) ________ is a collection of format characteristics that provides a consistent appearance within a worksheet and among similar workbooks.

Match the following terms with their description: i. XFD II. Range III. Value IV. Semi-selection v. Text

You can move a range by using the cut and paste commands.

The ________ feature displays any values in the column that match what the user has typed so far.

If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the ________ feature in Excel.

The default number format is ________.

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

Which of the following is not a valid number format?

What is the small green square in the bottom right of a cell called?

What is the best practice for centering a title over multiple columns?

The ________ feature can pull only part of a cell's value and place it into another cell.

It is acceptable to use values in formulas when you know those values will never change.

It is always a good practice to test each formula you enter for accuracy.