Quiz: Format | Jan's Working with Numbers

For each question, click on

the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

1. When you change the theme for the document, you change _____.

a. all of the colors and fonts

b. colors and fonts that were applied with a cell style or a table style

c. colors and fonts that were chosen from the theme palette of colors and the two theme fonts

d. only the colors and fonts that you apply after changing the theme

2. Once you have created a chart you may change _____.

a. only the formatting for text like titles and data labels

b. only by recreating the chart

c. everything about the chart

d. the text formatting and the data series patterns only

3. If your sheet is too wide to print on one sheet, to make it fit on one page you can try _____.

a. make the column widths smaller

b. make the margins smaller

c. use the Fit to… setting in the Scaling section of Page Setup or the Scaling section of the Page Layout tab

d. change the orientation to Landscape

e. any of the above

4. If a cell shows #####, it means that _____.

a. the column is too narrow to show all of the number

b. the row is too short to show all of the number

c. Excel does not understand your formula

d. you tried to divide by zero

5. To copy just the formatting of a range you could use _____

a. CTRL + Paste button

b. Format Painter

c. Paste Special > Formats

d. Paste button > Formatting icon

e. either b or c

f. either b, c, or d

g. either c or d

6. If you drag a selection on top of cells that have data, then _____.

a. the old data is overwritten with what you dragged

b. the old data is moved down and to the right so it is out of the way

c. you are asked if you want to replace the data

d. you are told that you cannot do that since the cells are not empty

7. Settings to wrap text in a cell and to merge cells are found in the Format Cells dialog on the _____ tab as well as on the ribbon.

a. Number

b. Alignment

c. Font

d. Border

8. You have selected Sheet1, Sheet2, and Sheet3 at the same time so they are grouped. On Sheet1, cell F6 contains the number 55. On Sheet2, cell F6 contains the word Income. On Sheet3, cell F6 contains the formula =D6*E6. You select the contents of cell B1 which contains the number 2000, then click the Copy button, and paste to cell F6 on Sheet1. Which of the following are true:

a. The contents of F6 on Sheet1 is now 2000 but the other sheets are not changed

b. The contents of F6 on all three sheets is changed to 2000.

c. The contents of F6 is changed on Sheet1 and Sheet2 but not on Sheet3 since it has a formula.

d. You are asked if you want to move the contents to the right or down or delete the whole row or column

9. On the Home tab, you can use choices in the Styles tab group to apply _____.

a. paragraph styles, character styles, and cell styles.

b. only cell styles

c. cell styles and table styles

d. only table styles

10. To clear just the formats from a selection you can _____.

a. click the Clear button > Clear Formats

b. use the key combo CTRL + F

c. right click on the selection and choose Clear Formats

d. right click on the selection and choose Format Cells... and then check the Clear Formats box on the General tab

Jan's Working with Numbers

Format: Quiz