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.
Choose the BEST answer.
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
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. all of the above
4. If a cell shows #####, it means that _____.
the column is too narrow to show all of the number
the row is too short to show all of the number
Excel does not understand your formula
you tried to divide by zero
5. To copy just the formatting of a range
you could use _____
a. CTRL + Paste button
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.
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
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
Teachers: Request permission to use this site with your class
a local copy with no ads? - Download/CD
Want to help?
~~ 1 Cor. 10:31 ...whatever you do, do it all for the
glory of God. ~~
Last updated: January 1, 2013