Excel for Marketing Managers

Arithmetic Facts Quiz

Arithmetic
Facts Quiz

4. Add a border.
   Click on cell A1, and drag to the right to also select cell B1. Right-click in
   the grayed area and select Format Cells, and then the Border tab. On the
   left edge, select the third box down to put a border on the bottom edge of
   the two cells, and then click OK.


5. Add a place for student’s name.
   Click on cell A2, and drag to the right to select cell B2. Right-click, select
   Format Cells, and then the Alignment tab. Under Text alignment, Horizon-
   tal, click on the arrow and select Center. Under Text Control, select Merge
   cells. Click OK to exit. Select cell A2 again. Type in the word Name and
   then press Enter.


6. Copy and paste the first range.
   Click on cell A1, and drag down and to the right to select the range A1:B15,
   and copy by selecting Edit → Copy (or press Ctrl+C). Move the mouse to
   cell D1, and paste by selecting Edit → Paste (or press Ctrl+V). Paste twice
   more, once each in cells G1 and J1.

Figure 105

Centering text

horizontally and

merging cells