Using the SUM function.

If you have multiple cells to add, the SUM function can save you a lot of time and space.  Instead of typing something like =a1+b1+c1+d1+e1, all you have to do is use the SUM function.  See the following steps to do this.

1.  Open Excel.  In Excel 2013 hit the Escape or Enter key one time to open a blank spread sheet.
2.  Go to cell a51.
3.  Type =SUM(a1:a50)
4.  Tap enter one time.
5.  Up arrow one time and you will hear that this cell has a formula.
6.  Go to cell a1.
7.  Type any number.
8.  Tap enter.
9.  Type any number and hit Enter again and again until you have ten numbers going down in a list.
10.  Go to cell a51 and see the answer.
11.  Press control c to copy the function/formula.
12.  Release these keys.
13.  Press and hold the shift key and tap the right arrow key two times.
14.  Release these keys.
15.  Press control c to copy the function/formula into the highlighted cells.
16.  Go to cell b1 and type a number.
17.  Tap enter.
18.  Type another number—do this until you have ten of fifteen numbers.
19.  Press control g.
20.  Type b51.
21.  Tap enter and you will hear the answer for all of the added numbers in column b.
22.  Go to cell c1 and repeat the above sequence.
23.  Go to cell a1—let's say you meant to make this column currency, but forgot.  Press and hold down the control and shift keys and tap the down arrow key one time.
24.  Release all keys and your data from cell a1 through a51 will be highlighted.
25.  Press and hold the control and shift keys and tap the number 4.
26.  Release all keys and you will notice by exploring with the down arrow key that all data in the a column is currency.
27.  Do the above sequence in column b.
28.  Go to column c1.
29.  Type the number starting with a decimal point .05.
30.  Tap enter.
31.  Type the number starting with a decimal point .99.
32.  Tap enter.
33.  Type the number starting with a decimal point  .49.
34.  Tap enter.
35.  Type the number starting with a decimal point .53.
36.  Tap enter.
37.  Go to cell c51 to hear your answer.
38.  Go to cell c1.
39.  Press and hold down the control and shift keys and tap the down arrow key two times.  Note, there were blank cells between cell c4 and cell c51, therefore, we had to tap down arrow twice in order to highlight the first four sequential numbers, and the answer in cell c51.
40.  Release these keys.
41.  Press and hold down the control and shift keys and tap the number 5 key.
42.  Release these keys.
43.  Down arrow one time and you will hear your number as a percent—look at other numbers in column c and you will find they are also in percent form.
44.  Press alt f4 to close Excel.  A box will come up asking if you want to save the workbook.  Tap the letter n to indicate “no.”
 
Assignment:  Open Excel.  Type a SUM function in cell a7.  Copy this function into cells b7 and c7.  Have column a be plain numbers, column b be currency, and column c be percents.  Remember, if you are doing percents and want your percent not to be below 100, you must type a decimal point before you type the number.  Make sure to have your name in cell a1, the date in cell a2, and the time in cell a3.  Widen the column to the width of your name.  Save the file as “Excel Assignment 10”.  Print two copies.  Keep one for yourself, and give one to the teacher.

NOTE:  If you are at the bottom of a list of numbers or just to the right of a row of numbers, you can press and hold the Alt key and hit the = (equals) key, and then hit Enter or Tab to automatically write the SUM function for those numbers.

BACK