Page 202 - DCAP101_BASIC_COMPUTER_SKILLS
P. 202
Unit 10: Microsoft Excel
10.4.1 Doing Simple Calculations Notes
Using Excel 97, we can perform a wide range of mathematical calculations and function
according to what we need from our data. To calculate sums (totals) and percentages. the
mathematical operation of adding numbers to get a total, and then divide each number, that
was just added by that total.
Calculating the sum of schools with Web sites.
In the technology workbook, click cell E5, type Total Sites, and press enter.
Click cell E5 again, and on the Formatting toolbar, click the Bold button.
Click cell E6, and on the Formula toolbar click the Edit Formula (the = sign).
Click the Functions arrow, and choose Sum. (C6 : D6 appears in the H)
Click OK.
To sum each pair of numbers, click E6 and drag the fill handle from E6 to Amount Spent
Date % on Conveyance % on Miscellaneous Conveyance
Miscellaneous Total
6 j 1/1i95 85 110 195
.
7 ! 4/1i95 150 350 500
8 ‘ 7/1M 200 375 575
9 ; 10/1/95 275 600 875
10 13/1FJS 350 750 1100
11 1B/1FJ5 300 500 600
12; 21/1r95 875 1125
13
Calculating the percentage of Expenditure on Conveyance
Click cell F5, type % of Conveyance, and then press enter.
Click cell F5 again, and then click the Bold button on the Formatting toolbar Click cell G5,
type % of Miscellaneous, and press enter. Click cell G5 again, and on the Formatting toolbar
click the Bold button.
Click F6, and click the Edit Formula button (the = sign).
Type C6/E6, and click OK.
LOVELY PROFESSIONAL UNIVERSITY 195
