Excel Test Review 1

A visual representation of worksheet data.

• Column
• Data
• Chart
• Legend

This describes what is charted. It can be placed above or below the chart.

• Chart title
• chart area
• bar chart
• pie chart

Once you have created a chart you cannot add another data series.

• True
• False

A chart can be moved to a separate sheet.

• True
• False

To find the biggest value in a cell range you would use the MAX function. 

• TRUE
• FALSE

What is a visual representation of worksheet data?

• Legend
• Chart
• Spreadsheet
• Table

A chart Legend does what?

• Identifies the values of each axis.
• Identifies what each data series represents.
• The entire chart and all chart elements. 
• A single chart symbol that represents 1 value in a data series. 

What is the active cell in this picture? 

• A1
• D3
• B4
• C4

Columns are labeled with _________. Rows are labeled with _______.

• Letters / Numbers
• Numbers / Letters 
• Colors / Numbers
• Letters / Colors

What function calculates the average value of a range of cells?

• SUM
• MIN
• MAX
• AVERAGE