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