mjb08a_E61_RETURNED - Price Demand Qty 1 Demand Qty 2 $1.00 10 14 $2.00 9 13 $3.00 8 12 $4.00 7 11 $5.00 6 10 $6.00 5 9 $7.00 4 8 $8.00 3 7 $9.00 2 6

1. Create Demand Qty 2 Data in the range C2:C11 using a formula by adding 4 to the B column data. 3. Make the Chart Title "Demand Data" 4. Make the X axis chart description be "Quantity Demanded" and make the Y axis chart description be "Price" 5. Resize the graph to fit the range D1:K11 2. Create a “Scatter with smooth lines without markers” chart for the data. Make Price the Y axis and Demand 1 and sure to source the Demand 1 and Demand 2 series names using a cell reference to cells B1 and B2.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Price Demand Qty 1 Demand Qty 2 $1.00 10 14 $2.00 9 13 $3.00 8 12 $4.00 7 11 $5.00 6 10 $6.00 5 9 $7.00 4 8 $8.00 3 7 $9.00 2 6 $10.00 1 5 2 4 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 Dema Quan Price 6 8 10 12 14 16 and Data Demand Qty 1 Demand Qty 2 tity Demanded Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email [email protected] Assignment E61 Assignment Assignment E61 Excel Activity...
View Full Document