{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

mjb08a_E61_RETURNED - Price Demand Qty 1 Demand Qty 2 $1.00...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
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

{[ snackBarMessage ]}