Exam

Name___________________________________

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)	To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a:	1) ______

	A)  pop-up comment box.
	B)  note.
	C)  diagram.
	D)  legend.

2)

A chart that separates one or more slices of pie is a(n) ________ pie chart.

2) ______

	A)  exploded
	B)  sliced
	C)  three-dimensional
	D)  segregated

3)

Data ________ are used to identify a data point.

3) ______

	A)  labels
	B)  text
	C)  series
	D)  stores

4)

________ column and row headings enable you to view data easily in large spreadsheets.

4) ______

	A)  Resizing
	B)  Freezing
	C)  Tiling
	D)  Formatting

5)

If there are certain columns of information that you do not want to be viewed by others, ________ the columns.

5) ______

	A)  delete
	B)  hide
	C)  freeze
	D)  format

6)

To go to the top of your spreadsheet quickly, use the ________ key(s).

6) ______

	A)  Arrow
	B)  Ctrl+End
	C)  Esc
	D)  Ctrl+Home

7)

To find predefined table layouts, access the ________ group.

7) ______

	A)  Template
	B)  Table Styles
	C)  Styles
	D)  Cells

8)

To display similar data in a single column, with each series of data distinguished by a different color, use a:

8) ______

	A)  stacked column chart.
	B)  box diagram.
	C)  3D column chart.
	D)  pie chart.

9)

Within the Chart Tools, which tab would you click on to find options to apply special effects to your chart?

9) ______

	A)  Format
	B)  Develop
	C)  Layout
	D)  Design

10)

A shape can be turned by selecting it and then clicking the green:

10) ______

	A)  star.
	B)  arrow.
	C)  rotation handle.
	D)  bullet.

11)

Cells must be ________ and the sheet protected to prevent edits being made to the data.

11) ______

	A)  values
	B)  formatted
	C)  locked
	D)  secured

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
12)	Titles are unnecessary, because they add little to the message of a chart.	12) ______

13)

Charts have no value other than to add color to a presentation.

13) ______

14)

If you have worksheets with confidential information, you may want to hide these sheets if others have access to your workbook.

14) ______

15)

Excel columns are the records in a table.

15) ______

16)

To unhide a column, you must select columns to the left and right of the hidden column before unhiding it.

16) ______

17)

Table labels should be in the first column of the table.

17) ______

18)

Filters can be used to extract very specific table data.

18) ______

19)

The range of cell data to use in your chart should be selected before you select the type of chart.

19) ______

20)

Even though a workbook is protected, you can still rename worksheets contained in it.

20) ______

21)

Excel tables function based on word processing concepts.

21) ______

22)

The order of table data is determined when you input your data.

22) ______

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
23)	________ are used to describe what the data points in a chart represent.	23) ______

24)

Match the following five terms to their meanings: I. chart area A. graphics image of data II. data label B. chart and its elements III. plot area C. identifies color representation IV. legend D. value that represents item V. data point E. describes item

24) ______

25)

When a worksheet is ________ and the cell locked, it cannot be edited.

25) ______