U5

To fill a row of selected cells with the entry in the leftmost cell, click the Fill button in the _____ and then click the Right option.

a. Editing group on the Home tab

If the contents of a cell display only partially in the cell, you can look at the _____ to see the entire contents.

a. Formula bar

What does Excel's spelling checker feature review?

a. text

To delete a row, select any cell in the row, click the Delete button arrow in the _____, and then click Delete Sheet Rows.

b. Cells group on the Home tab

Suppose that cell D3 is the active cell. To make cell A1 active, you can press

b. Ctrl + Home.

To use the Auto Fill feature, make a cell active and then hover the mouse pointer over the lower right corner until the mouse pointer becomes a

b. black crosshair.

If a large number in a cell displays as a series of pound signs (###), you must _____ for the contents to display properly.

b. increase the column width

Which of the following types of cell entries is left-aligned by default?

b. phone numbers

Which of the following characters can be used in a worksheet name?

b. space ( )

When you open Excel you can create a blank

b. workbook containing one worksheet.

Which of the following cell entries would not be treated as text by Excel?

c. 12.5

You can customize Excel's _____ feature to correct typos you make often, such as transposing two letters in your name.

c. AutoCorrect

Press _____ to finish an entry without moving the active cell to another cell.

c. Ctrl + Enter

What should you do if you accidentally delete a row or column?

c. Immediately click the Undo button.

How many cells can an Excel worksheet contain?

c. It depends on the amount of RAM available to your computer.

How are columns labeled in an Excel worksheet?

c. with capital letters (A, B, C, ...)

To display the content of cell B7 in cell C20, type

d. =B7 in cell C20

The _____ feature automatically inserts data into a cell when you begin typing the same text as a previous entry.

d. AutoComplete

Which of the following is not a correct example of a cell range?

d. B4:8J

Using the _____ key allows you to select multiple worksheet tabs.

d. Ctrl

Which of the following methods is most efficient for handling multiple sets of related data?

d. Divide the data into several worksheets in the same workbook.

Which of the following best describes the Auto Fill feature in Excel?

d. It enables you to copy an entry across a row or down a column or create a series of entries across a row or down a column.

To create a copy of Sheet1, right-click the Sheet1 worksheet tab, click _____, click the Create a copy check box, and then click OK.

d. Move or Copy

When you click the Header & Footer button on the Insert tab, Excel switches to _____ View.

d. Page Layout

How can you change the color of a worksheet tab?

d. Right-click the sheet tab, point to Tab Color, and then click the color you want.

How can you move the active cell from cell B5 to cell K43?

d. Type K43 in the Name box.

What type of software application is Microsoft Excel?

d. a spreadsheet application

To rename a tab, _____ the tab, click Rename, type the new name, and then press Enter.

d. right-click

To insert a column, _____ and then click Insert.

d. right-click a column heading

To adjust your printout to fit on one page, use the _____ options in the last option box in the Settings category of the Print backstage area.

d. scaling