Excel for Marketing Managers

Solving Systems of Equations

Solving
Systems of
Equations

1. Change the font style and size for the entire worksheet.
   In the extreme upper left hand corner, there is an empty box just to the left
   of Column A, and above Row 1. Clicking on that box highlights the entire
   worksheet. Go to the toolbar at the top of the page and change the Font to
   Arial and the Size to 12 by clicking on the small arrow to the right of each
   box and making the correct selection.


2. Create a title block.
   Move your cursor to cell C1. Left click and drag to the right until you get to
   cell Q1 and let go. While the cells are still highlighted, and with the cursor
   inside the highlighted range, right-click to open the Format Cells dialog
   box. Make the following changes:

a. Click on the Alignment tab, change the Horizontal Alignment to Center,

and click on the box next to Merge Cells under the Text Control Head-

ing.

b. Click on the Font tab, and change Size to 18. Click OK to exit.

c. Inside the merged cells, type in the following text:

Solving a System of Two Equations by Subtraction

Figure 258 Selecting the entire worksheet and changing the font