5 Written Questions

1. Shows patterns between two or more sets of data. The size of the data marker is determined by the 3rd value.
2. To change the size of a graphic to make it fit into a document.
3. A mode in which you can edit part of an entry rather than the entire contents of a cell.
4. A page break that you insert anywhere on a page.
5. A button on the Ribbon that, when selected, copies a format from one cell range to another.

5 Matching Questions

1. Workbook
2. Horizontal (category) axis
3. Cell range
4. Clear
5. Absolute reference

1. a A group of worksheet cells, which can be adjacent or nonadjacent. (AKA a range)
2. b The file in which Excel stores an electronic spreadsheet.
3. c On the horizontal axis, or x-axis, are the data series' category values, or x values.
4. d Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.
5. e To remove

5 Multiple Choice Questions

1. Shows stock market data like highs, lows, opening price and closing price.
   1. Active sheet
   2. Stock Chart
   3. Spreadsheet
   4. Sheet tab
2. A collection of related fields that are grouped together, in Excel, each row represents a record.
   1. Font
   2. Points
   3. Filter
   4. Record
3. Two or more text characters.
   1. Font style
   2. Data series
   3. Text string
   4. Font size
4. A spreadsheet program you use to display, organize, and analyze numerical data.
   1. Column header
   2. Microsoft Excel 2007
   3. Minor tick mark
   4. 3-D Reference
5. The actual data displayed in a chart.
   1. Series values
   2. Normal view
   3. Print title
   4. Series name

5 True/False Questions

1. Table style → An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row).

   True        False

2. Name box → The middle value in data.

   True        False

3. Sans serif font → Two or more text characters.

   True        False

4. Surface Chart → Compares three sets of values in a 3-D chart.

   True        False

5. Pie chart → A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.

   True        False