CJ 3rd QER TLE 7

A ___ is a way of formatting data so that data may be sorted. It also displays rows in alternating colors to make the data easier to read.

• table

• excel

A ___ is a data summarization tool within Excel. It can sort, count, total and average the data within a table or spreadsheet.

• pivot table

• round table

A ___ is a visual representative of data in both columns and rows. This is usually used to analyze trends and patterns in data sets. You can also use charts to compare set targets against actual achievements.

• table

• chart

The title should clearly describe what the chart is illustrating.

• Vertical Axis

• Chart Title

This is also known as the y axis, is the vertical part of the chart.

• Vertical Axis

• horizontal axis

The ___ consists of the related data points in a chart.

• data series

• vertical axis

This is also known as the x axis, is the horizontal part of the chart.

• horizontal axis

• vertical axis

It Identifies which data series each color on the chart represents.

• cells

• legend

If your spreadsheet contains sensitive data that you don't want displayed on the screen or included in printouts, then you can ___ the corresponding rows or columns.

• Hide

• Check

The ___ feature allows you to specify particular rows and columns that will always remain visible as you scroll through the worksheet.

• Freeze Panes

• Hide and unhide