Question

ctech - 041 - cr: computer technology / unit 7: spreadsheets

1. what does a chart legend do?

indicates how famous the chart is
gives the chart a name
indicates what the colors or numbers in the chart represent
tells you where to find the data

1. what formula function would you use to get the maximum of a group of numbers?

sum
count
average
max

Explanation:

For question 3: A chart legend is used to clarify what different colors or symbols (which can be thought of as a form of "numbers" in a sense of representing data categories) in the chart represent.
For question 4:

• SUM is used to add up a group of numbers.
• COUNT is used to count the number of values in a group.
• AVERAGE is used to find the mean of a group of numbers.
• MAX is specifically designed to get the maximum value from a group of numbers.

Answer:

1. indicates what the colors or numbers in the chart represent
2. MAX