{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

mjb08a_E62_RETURNED - 1 In the Column B Dark Red area...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1. In the Column B Dark Red area B3:B21 on the Perfect tab, use a formula to add 2 to the previous row. 2. In the Column C Bright Red area C3:C21, use a formula to calculate the slope of column B. 3. In the Column D gold area D3:D21, use a formula to add 1 to the previous row. 4. In the Column E Bright Yellow area E3:E21, use a formula to calculate the slope of column D. 5. In the Column F Light Green area F3:F21, use a formula to add 0.5 to the previous row. 6. In the Column G Dark Green area G3:G21, use a formula to calculate the slope of column F. 7. Insert an X Y Scatter Graph, Scatter with Smooth Lines without markers. 8. Remove any Data Series that have been added by Excel. 9. Add a Legend Entries Series using a cell reference to Quantity Supplied 1 cell to create the series name. Use the da Quantity Supplied 1 column to create the Series X Values. Use the data under the Price column to create the Series Y 10. Add another Legend Entries Series using a cell reference to Quantity Supplied 2 cell to create the series name. Us the Quantity Supplied 2 column to create the Series X Values. Use the data under the Price column to create the Serie 11. Add another Legend Entries Series using a cell reference to Quantity Supplied 3 cell to create the series name. Us the Quantity Supplied 3 column to create the Series X Values. Use the data under the Price column to create the Serie
Background image of page 1

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

View Full Document Right Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}