Lesson 10

What is the maximum width of a column?

255 Characters

Which of the following chart types compares values over time?

BAR

Which of the following key combinations closes a workbook?

CTRL W

It is preferred to use five or six fonts in a worksheet to make the worksheet more attractive and easier to understand. (T/F)

False

New rows are inserted below the current row. (T/F)

False

Only one workbook can be open at a time. (T/F)

False

What does the arrow on each column heading mean?

In Excel, arrows to the right of each column heading that appear when AutoFilter is selected for a list; click the arrows to open a menu containing options for filtering and sorting the list data

Formatting does not affect any underlying values. (T/F)

True

If you copy a formula with a relative cell address and paste it to another cell, Excel will automatically adjust the cell references in the pasted cell to reflect the new location. (T/F)

True

The AutoFilter can find rows where a cell is equal to a specific value or set of values. (T/F)

True

The Backstage view is displayed when you start Microsoft Excel. (T/F)

True

You can enter or edit data directly in the active cell or use the Formula bar for long data entries. (T/F)

True

You should avoid dark colors and dense patterns that can obscure the information in the cells. (T/F)

True

Which option do you select to center a text label across several cells?

merge caenter

When you copy or fill a cell, you copy its format along with the cell contents. (T/F)

true

Which of the following alignment options is the default for values entered into a worksheet?

use general alignment

What is the default file type for a new Excel file?

xlsx