Question

guided practice activity #3 – charting your course the charts have been created from the following data table with columns a-f, rows 1-11: row 2 labeled
evenue per item per concert\; row 3 labeled \concert 1\, \concert 2\, \concert 3\, \totals\; rows 4-8: \soda\ with $56.00, $63.00, $53.00, $172.00; \water\ with $30.75, $45.00, $48.75, $124.50; \popcorn\ with $25.50, $30.00, $18.00, $73.50; \cookie\ with $36.00, $49.00, $44.50, $129.50; \hot dog\ with $68.00, $74.00, $54.00, $196.00; row 10 labeled \totals\ with $216.25, $261.00, $218.25, $695.50 1. what cell range was highlighted to create the second pie chart on the right above?

Explanation:

Step1: Analyze pie chart data source

Pie charts for revenue per item or per concert. Second pie chart likely for item totals (row 4 - 8, column F) or concert totals (row 10, columns C - E) or item names and totals. Looking at the table, item names (B4 - B8) and their totals (F4 - F8) or concert totals (C10 - E10) or item totals (F4 - F8) with labels. Wait, the "Totals" column is F (F4 - F8 for items, F10 for grand total). Also, row 10 is "Totals" for concerts (C10, D10, E10) and grand total F10. But second pie chart (assuming first is concert totals, second is item totals). So items are B4 - B8 (names) and F4 - F8 (totals). So cell range would be B4:F8 (items and their totals) or B4:B8 and F4:F8. Wait, the table has rows 4 - 8 as items (Soda, Water, Popcorn, Cookie, Hot Dog) with their totals in F4 - F8. So to create a pie chart of revenue per item (totals), we need the item names (B4 - B8) and their total revenues (F4 - F8). So the cell range is B4:F8 (columns B to F, rows 4 to 8) or B4:B8 and F4:F8 (but in Excel, you can select B4:B8 and F4:F8, but the range would be B4:F8 including names and totals). Alternatively, if it's the concert totals (row 10, C10 - E10), but row 10 is "Totals" for concerts. Wait, the first pie chart might be concert totals (C10, D10, E10), second would be item totals (F4 - F8) with labels (B4 - B8). So the cell range is B4:F8 (rows 4 - 8, columns B - F) which includes the item names (B4 - B8) and their total revenues (F4 - F8), and the middle columns (C - E) are per concert, but totals are in F. So to make a pie chart of each item's total revenue, we need the item names (B4 - B8) and their total (F4 - F8). So the range is B4:F8 (since columns B has names, F has totals, and C - E are per concert, but when creating a pie chart for item totals, we use B (names) and F (totals)). Alternatively, if the second pie chart is about the concert totals (row 10, C10 - E10), but row 10 is "Totals" with C10=$216.25, D10=$261.00, E10=$218.25, F10=$695.50. But the question says "second pie chart", assuming first is concert totals (C10 - E10), second is item totals (B4 - B8 and F4 - F8, i.e., B4:F8). Let's check the table:

Rows 4 - 8: Items (B4 - B8) with revenues per concert (C4 - E4) and totals (F4 - F8).

Row 10: Totals per concert (C10 - E10) and grand total (F10).

So if first pie chart is concert totals (C10 - E10), second would be item totals (B4 - B8 and F4 - F8), so the cell range is B4:F8 (columns B to F, rows 4 to 8) because it includes the item names (B4 - B8) and their total revenues (F4 - F8), and the per - concert revenues (C4 - E4) are included but for a pie chart of item totals, we can use the names and totals. Alternatively, if the pie chart is of the item totals (F4 - F8) with labels (B4 - B8), the range is B4:B8 and F4:F8, which in Excel is represented as B4:F8 (since it's a contiguous range including both names and totals).

Step2: Confirm the range

Looking at the table, the items are in rows 4 - 8, column B (names), and their total revenues are in column F (F4 - F8). To create a pie chart showing the revenue distribution per item (using their total revenues), we need to select the item names (B4 - B8) and their total revenues (F4 - F8). The cell range that includes both is B4:F8 (columns B to F, rows 4 to 8). Another possibility is if the second pie chart is about the grand total breakdown, but the grand total is F10, and the concert totals are C10 - E10. But the question is about the second pie chart, likely the one for item totals. So the cell range is B4:F8.

Answer:

B4:F8