Excel for Marketing Managers

Calculation Basics

Calculation
Basics

Entering Division Problems...........................................................................................

There are two slash signs on the keyboard. File paths in Windows typically

require the backslash, located above the Enter key. Luckily, division problems

require the forward slash, located on the same key as the question mark. The

image below shows a division problem.

Entering Fraction Problems

Sometimes Excel expects your students to understand higher mathematical

concepts, such as that a fraction is really a division problem. That is, one-ninth

is actually one divided by nine. For fractions in Excel, enter the numerator, the

forward slash, and the denominator, as seen in the formula bar in Figure 22.

Figure 21

Division problems use a forward slash

Figure 22

Expressing fractions as division

problems