Question

objective 1 – creating charts
guided practice activity #3 – charting your course
the charts have been created from the following data
table with columns a–f, rows 1–11, showing “revenue per item per concert” (concert 1, concert 2, concert 3, totals) for soda, water, popcorn, cookie, hot dog, and row totals

1. what cell range was highlighted to create the second pie chart on the right above?

(handwritten: b4:f8)

1. what cell range was highlighted to make the following chart including the making the legend?

Explanation:

Question 1

Step1: Analyze the data for the second pie chart

The second pie chart (assuming it's about item totals) uses data from rows 4 - 8 (items: Soda, Water, Popcorn, Cookie, Hot Dog) and columns B - F (item names and their totals). So the range is B4:F8.

Step1: Analyze the chart with legend needs

To include legend (item names) and data (concert revenues and totals), the range should be B3:F8 (includes row 3 for labels: Concert 1, Concert 2, Concert 3, Totals and rows 4 - 8 for items and their data).

Answer:

B4:F8

Question 2