ABCDEFGHIJKLMNOPQRST
1
BEFORE YOU BEGIN, YOU NEED TO GO TO THE FILE MENU (NOT AT TOP OF SCREEN) THAT IS DIRECTLY BELOW "SUMMERCORE GOOGLE SS EXERCISES" AND MAKE A COPY!
2
3
Skill NameDescriptionSampleNow You Do Your Work on this Side -- the Yellow rectangles show where you need to work
4
5
(1) Adding numbersA formula such as =sum(C6:C8) is used to add up a block of numbers. Note that there no spaces in the formula. Also, upper vs lowercase is irrelevant!(1) Adding numbersPlease type in the correct formula in the yellow cell so that you get the SUM of the 3 numbers above it.
6
3333
7
3434
8
3535
9
102
10
11
(2) Averaging numbersA formula such as =AVERAGE(C12:C14) is used to add up a block of numbers. Note that there no spaces in the formula. Also, upper vs lowercase is irrelevant!(2) Averaging numbers
12
2323
13
3333
14
5353
15
10331033
16
285.5
17
18
(3) Sorting words or namesYou can put a list of words or names in order by choosing the right feature under the DATA menu. First you need to HIGHLIGHT or SELECT the desired cells. Then you choose the fourth feature under DATA where it says SORT RANGE by ???. Note that the first two items under DATA sort the entire row and not just a few cells.(3) Sorting words or names
19
GeorgiaLarry
20
KevinKevin
21
LarryRobert
22
MariahGeorgia
23
RobertMariah
24
25
26
(4) Sorting RowsIn our next exercise, we have data spanning rows from A to F. So this time you are going to HIGHLIGHT or SELECT the rectangle from A27 to F31 and then choose the fifth feature under DATA called SORT RANGE.(4) Sorting Rows
27
GeorgiaBird33 momFrench Lick IN
28
KevinMcHale32HibblingMN
29
LarryBird33French Lick IN
30
MariahBird33 daughterNaplesFL
31
RobertParish00ShreveportLA
32
33
(5) Making text wrap in 2 cellsIn this example, we have typed a sentence about the fact that Larry Bird was born on Pearl Harbor Day Dec 7th and made it wrap into 2 cells B31 and C31.(5) Making text wrap in 2 cellsIn this example, we have typed a sentence about the fact that Larry Bird was born on Pearl Harbor Day Dec 7th and you need to make it wrap into 2 cells B31 and C31.
34
35
36
37
38
(6) Making text fancyOn the right you will see samples of what you can do make text look fancy -- Larry1 is red, Larry2 has a color fill, Larry 3 has both and Larry 4 has a border and is centered both left/right and up/down. Larry 5 is wrapped in one cell so you need to choose WRAP for the example on the right.(6) Making text fancySee if you make Larry 1 thru Larry 4 match the ones on the left
39
Larry1Larry1
40
Larry2Larry2
41
Larry3Larry3
42
Larry4Larry4
43
Larry5 is wrapped in the one cellLarry5 is wrapped in just one cell.
44
45
46
47
48
49
(7) Making your own formula: the TIPTo multiple a cell by 18%, you use a formula such as =C48*1.18 which increases the number by 18%. Some people prefer the formula =C48+(C48*.18)(7) Making your own formula: the TIPSee if you can find out what the \$65 meal would cost with a 19% tipto reveal answer click on the black rectangle, then go to the FILL BUCKET and choose RESET
50
restaurant bill\$65.00restaurant bill\$65.00
51
with 18% tip\$76.70with 19% tip\$77.35
52
53
54
to reveal answer click on the black rectangle, then go to the FILL BUCKET and choose RESET
55
(8) Making your own formula: INTEREST RATE(8) Making your own formula: INTEREST RATE
56
Here is a typical spreadsheet problem: \$100 is deposited in the bank for 9 years at 8% interest. Calculate how much money will be in the bank at the end of each of the next 9 years\$100.00See if you can do the same. One trick for the years is to put =F54+1 into cell F55. Do you see why? Yes, it will increase 2013 by 1 so if you then fill this formula down, you will get all your years!Once you have the years, you can focus on the bank interest which is surprisingly the same as the tip in the restaurant.\$100.00You put the formula = 1.08*G53 into cell G54 and then push ENTER or RETURN. You then fill this formula down
57
2013\$108.002013
58
2014\$116.64
59
2015\$125.97
60
2016\$136.05
61
2017\$146.93
62
2018\$158.69
63
2019\$171.38
64
2020\$185.09
65
2021\$199.90
66
67
(9) Formats of NumbersSo you now in the previous example can see how money can be formatted. Here are a variety of numerical formats, each one applied to the same number 12.345(9) Formats of NumbersNow you try it using highlighting one cell at a time and choosing the FORMAT menu and the subchoice of NUMBER. Note that the NUMBER subchoice itself has items called OTHER CURRENCIES and MORE FORMATS.
68
normal12.34512.345
69
scientific notation1.23E+0112.345
70
money\$12.3512.345
71
per cent1234.50%12.345
72
date1/11/190012.345
73
euros€ 12.3512.345
74
yen¥ 12.3512.345
75
date12/7/201312/7/2013
76
date alteredDec-712/7/2013
77
and altered again12-07-1312/7/2013
78
79
(10) Conditional Formatting(10) Conditional Formatting
80
You can make a cell change to a different color based on how big it is. in this example, we have program these numbers to be green or yellow or red according to the rules of green=90 or above, yellow = 80 to 89.9 and red below 80.It all begins by going to CONDITIONAL FORMATTING under the FORMAT menu. You need to program 3 rules. Click the 75 in cell F77, then click CONDITIONAL FORMATTING and see if you can program the one rule "if value is over 90 then green"picture on right should help you
81
7575
82
8585
83
9595
84
7878
85
8888
86
9898
87
88
89
(11) Random PickingThe formula =RANDBETWEEN(#,#) lets you pick a random number between the lower one and the higher one. In this example, each formula is (1.6) to simlulate a die. Then the formula below adds up the two dice to get a number between 2 and 12.(11) Random PickingTry to generate the two individual dice here and then add them. Did you know that 7 is the most likely outcome when you roll two dice?
90
One Die4
91
Another Die3
92
TOTAL 7
93
94
(11) Random Picking of a NameYou can use random numbers to make the computer pick a random student.See if you can make this happen using the last names of the same 5 people.
95
GeorgiaBird
96
KevinMcHale
97
LarryBird
98
MariahBird
99
RobertParish
100
Pick a random number from 1 to 52