Microsoft Office Tutorials and References

In Depth Information

**To Enter Formulas Using Point Mode and Determine Totals in the Template**

The following steps use Point mode to enter the four formulas in Table 6–1 in the range D5:G5. After the

formulas are entered for JVC DVRs in row 5, the formulas will be copied for the remaining six companies. The Sum

button then is used to determine the totals in row 12.

1

•
Select cell D5, type
=
to start

the formula, click cell B5, type
*

(asterisk), click cell C5, and then

click the Enter box in the formula

bar (Figure 6–9).

formula assigned

to cell D5

value of 1

2

appears in cell D5

Figure 6–9

2

•
Select cell E5, type

=round(c5/(1-.42),2)
, and

then click the Enter box in the

formula bar to display the formula

=ROUND(C5/(1-0.42), 2) in the

formula bar and the value 3.45

(3.448276 rounded to two decimal

places) as the average unit price in

cell E5 (Figure 6–10).

ROUND function

assigned to cell E5

value of 2 / (1 - .42)

rounded to two decimal

places appears in cell E5

Figure 6–10