5, 11, 12, 13, 14, 16, 18 could have multiple answers

1. A pie chart displays

a) the magnitude of change over time

b) the trends in multiple data series as a continuous curve

c) one data series as a part of the whole

d) profit or loss from a bakery

2. An area chart displays

a) the magnitude of change over time

b) the trends in multiple data series as a continuous curve

c) one data series as a part of the whole

d) pairs of data to establish concentrations

3. An XY (scatter) chart displays

a) the magnitude of change over time

b) the trends in multiple data series as a continuous curve

c) one data series as a part of the whole

d) pairs of data to establish concentrations

4. A surface chart displays

a) the magnitude of change over time

b) the trends in multiple data series as a continuous curve

c) one data series as a part of the whole

d) pairs of data to establish concentrations

5. Pictures may be in files with the file format

a) .jpg

b) .bmp

c) .gif

6. Clip art is

a) generally small drawings and icons

b) simple graphics of common building-block drawings

c) shapes that have been enhanced and grouped together with text

d) a graphic capture of what is displayed on a screen

7. A shape is

a) generally small drawings and icons

b) simple graphics of common building-block drawings

c) shapes that have been enhanced and grouped together with text

d) a graphic capture of what is displayed on a screen

8. SmartArt is

a) generally small drawings and icons

b) simple graphics of common building-block drawings

c) shapes that have been enhanced and grouped together with text

d) a graphic capture of what is displayed on a screen

9. A screenshot is

a) generally small drawings and icons

b) simple graphics of common building-block drawings

c) shapes that have been enhanced and grouped together with text

d) a graphic capture of what is displayed on a screen

10. A Table in Excel is like a

a) a place to insert a diagram

b) a place to meet others who work on the spreadsheet

c) a "flat" spreadsheet

d) database

e) all of the above

11. An Excel table may have

a) column headings

b) a "totals" column

c) alternating row colors

12. When working with an Excel Table you may

a) add a column or a row

b) delete a column or a row

c) apply styles to the Table

13. Data inserted into an Excel Table may be validated to ensure that it is

a) the correct type of data

b) within the correct range of permissible values

c) taken from a list of permissible values

14. In Excel, you may sort data by

a) the values in the columns

b) the fill color or font color

c) cell icons

d) custom lists

15. AutoFilter allows you to

a) quickly hide rows

b) quickly hide columns

c) quickly hide rows or coulmns

d) quickly hide rows and columns

e) all of the above

f) answers 1 & 2

16. Using Autofilter you may filter by

a) values

b) empty cells

c) cell fill

17. We may find and replace based on

a) "wild cards"

b) the time when the text was entered

c) the subject of the paragraph

d) all of the above

18. Colors may be modeled by

a) RGB

b) HSL

c) Red, Green, Blue