Chapter 3

9 If you enter the value $45.50 into a cell with default formatting, Excel automatically Choose one answer. a. applies currency formatting to the number. b. removes the dollar sign but leaves the number as a decimal. c. rounds the value to a whole number (45). d. removes the dollar sign and rounds the value up (46).

a. applies currency formatting to the number.

2 By default, all columns in a worksheet Choose one answer. a. are the same width. b. are hidden. c. expand automatically to accommodate longer values. d. are different widths.

a. are the same width.

4 By default, when inserting a column in a worksheet, the new column is placed Choose one answer. a. immediately to the left of the column containing the active cell. b. one column to the left of the last column of the worksheet that contains data. c. immediately to the right of the column containing the active cell. d. at the far left of the worksheet.

a. immediately to the left of the column containing the active cell.

3 By default, numbers typed in a cell are formatted to Choose one answer. a. right-align, with no decimals or commas unless they are typed in the cell. b. left-align, with one decimal place and commas for the thousand separator. c. right-align, with two decimal places and no commas. d. left-align, with no decimals or commas unless they are typed in the cell.

a. right-align, with no decimals or commas unless they are typed in the cell.

5 Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats. Choose one answer. a. Cell Format b. Number Format c. General d. Formatting

b. Number Format

8 If you enter numbers into a cell, they will be automatically aligned Choose one answer. a. in the center of the cell. b. at the right side of the cell. c. the same as the cell to the left of the active cell. d. at the left edge of the cell.

b. at the right side of the cell.

1 Approximately how many points are contained in a vertical inch? Choose one answer. a. 112 b. 12 c. 72 d. 48

c. 72

7 How is clearing cell contents different from deleting cells? Choose one answer. a. Clearing cells is only temporary; the cell contents and formatting are restored when the workbook is saved. b. Clearing cells must be done on an entire row or column, not on individual cells. c. Clearing cell contents gives you the option of removing both contents and formatting from a cell. d. Clearing cells only removes entered data; it does not remove formulas.

c. Clearing cell contents gives you the option of removing both contents and formatting from a cell.

10 If you want to apply the formatting you have just applied to one cell to other cells in your worksheet, you can use the Repeat command, which is executed by pressing Choose one answer. a. Ctrl + R. b. F9. c. the Tab key. d. Ctrl + Y.

d. Ctrl + Y.

6 Excel measures row height in _____ and column width in _____. Choose one answer. a. characters; points b. inches; values c. values; inches d. points; characters

d. points; characters