unit 4 chapter 1 (excel)

A worksheet name can be up to _____ characters long.

31

What is the keyboard shortcut to open the spelling checker?

F7

A cell's column letter and row number can together be referred to using any of the following terms except

cell range

If you use the Auto Fill feature to make an entry that Excel does not recognize as part of a series, Excel

copies the entry to the area you are filling

Excel's spelling checker looks for errors in text entries and in formulas.

false

If you frequently mistype a word, Excel will begin to correct the spelling automatically.

false

In Excel, the active cell is identified by a black border.

false

The keyboard shortcut F5 opens the Go To dialog box, which enables you to jump quickly to a specific worksheet.

false

The range B1:E5 includes all the cells from row B, column 1 through row E, column 5.

false

You can add color to worksheet tabs, but all the tabs in a workbook must be the same color.

false

To add a header or a footer to your worksheet, begin by clicking the _____ tab.

insert

How many sheets in a workbook can be active at any given time?

one

Which of the following is a quick way to delete a row or column?

right-click the heading and then choose Delete

The entire contents of a data cell will display on the worksheet even if it is too long to fit in the cell as long as

the cell immediately to the right is empty

Why would you use the To book arrow in the Move or Copy dialog box, which appears when you right-click a worksheet tab name?

to move or copy a worksheet to another workbook

A series of pound signs (###) indicates that a numeric entry is too wide to display in a cell.

true

To finish an entry without moving the active cell to another cell, press Ctrl + Enter.

true

To see options for printing an Excel file, you can start at the Page Layout tab or the File tab.

true

You can create multiple worksheets in an Excel workbook.

true

In Excel, each file is called a _____ and is divided into _____.

workbook; worksheets