Excel for Marketing Managers

Solving Systems of Equations

Solving

Systems of

Equations

b. Click on cell L9, and drag to the right to cell P9. Press Ctrl+C to copy

the cells. Click on cell L11, and press Ctrl+V to paste the values into the

cells. Continue this process (click on a cell, then press Ctrl+V) in the fol-

lowing cells: L13, L15, L17, L23, and L24.

c. You will now change the background colors in some of the cells in Col-

umns K through Q. To make this a bit easier, you will use a similar

trick to the one you used to change non-contiguous columns in Step 6d.

Change the following cells to light green. Click on cell K9. Hold down

the Ctrl key and click on N9, Q9, K13, N13, and Q13. Now right-click

and change the Patterns color to the same light green as the text box in

row 9. Also, go to the Borders tab and select Outline.

d. Now do the same with these cells (change border and color), except

make them the same tan as the text box in row 11. Select cells K11,

N11, Q11, K15, N15, and Q15.

e. Cells K17, N17, and Q17 need to be changed to pink, the same color as

the text box in rows 17 and 18. Don’t forget the border (Outline).

f. Now highlight the range of cells K23:Q23; right-click and change their

color to the pale green from Step 7c.

g. Highlight the range of cells K25:Q25, and change their color to the tan

color from Step 19.

h. Click on cell L23. Hold down the Ctrl key and click on cell O23, L25,

and O25. Press the Delete key to remove the x and y characters in these

cells. Press Ctrl+1 to open the Format Cells dialog box and give these

cells an Outline border.

i. Click on cell I13. Hold down the Ctrl key again and click I15 and I20.

Press Ctrl+1 to open the Format Cells dialog box. Change the Pattern

color to pale yellow and place an Outline Border on the cells.

j. Move the mouse cursor in between the I and J at the top of the page.

Left click and drag to the left to change the cell width to 3.57 (30 pix-

els).