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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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. Us10....
View Full Document

Page1 / 3

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online