COSC 1301: CH08 Review

Which of the following is not a valid entry for a formula?

(A1+A2)*A3

Which of the following is not a valid cell reference?

15BZ

Which character separates the top left cell reference from the lower right cell reference when specifying a range?

: (colon)

How can you tell when a column's width has been made too narrow to show all the characters?

A series of pound symbols (#####) display in the cells within the column.

You are working on a worksheet that currently has data in rows 1 through 25. You delete row 10. What happens to the data in rows 11 through 25 after row 10 is deleted?

All data shifts up to fill the space; the last row with data is now row 24.

The _____ feature can enter many common text or number series in adjacent cells based on the entry in the active cell.

Auto Fill

What is the advantage to formatting a worksheet using Cell Styles?

Cell Styles promote consistency in formatting headings, totals, and accented cells.

Which scaling option shrinks the size of text so that all of the active worksheet prints on one page?

Fit Sheet on One Page

Which button moves the text in a cell approximately one character width inward from the left edge of the cell?

Increase Indent

Which feature is often used to center a worksheet title in a worksheet?

Merge & Center

You have a large worksheet and notice that when you scroll down, the column headings in rows 1 and 2 are not visible. What can you do to fix rows 1 and 2 in place?

Move the active cell to A3 and then use the Freeze Panes option.

The _____ function adds a column or row of numbers.

SUM

The New sheet button is located on the

Sheet tab bar.

What does the Accounting Number Format include that the Comma Style does not?

a currency symbol

The AutoFit feature automatically changes the column width to fit the contents of the

active cell.

A new column is inserted _____ in which the active cell is located.

at the left of the column

The Fill Color button applies color to the _____ of a cell.

background

The Show Formulas button switches the display back and forth between showing the formulas in cells and showing _____ in cells.

results

What is the first step to sort worksheet data by more than one column?

select the range

A file that you save in Excel is called a(n)

workbook.