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