Excel for Marketing Managers

Math Exercise Sheets

Math
Exercise
Sheets

Figure 97 shows a formula that concatenates the value in A with a plus sign,

then the value in B, then an equals sign, and several underscore characters to

provide a place for the student to write the answer.

To join a value with text, use the concatenation operator – the ampersand (&).

If you want to join a value with a Literal, such as the equals or the plus sign,

you have to include the literal in double quotes.

Caution!

There is one annoying “bug” that shows up as you enter this formula. Notice in the

above figure that there is a space on either side of the plus sign. You generally have

to hold down the Shift key to type the plus sign. You may accidentally continue to

hold down the Shift key when you type the spacebar after the plus sign. Unfortu-

nately, Shift+Spacebar is an Excel shortcut to select the entire row. If you suddenly

see your formula change to Figure 98, you inadvertently typed Shift+Spacebar

instead of just the Spacebar. Simply type the Backspace to get rid of the 3:3 entry.

Figure 96

Worksheet with pairs of random

numbers between 1 and 20

Figure 97

Adding plus signs and

underscores for

student’s answers

Figure 98

Result of holding down Shift key while pressing Spacebar