ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
The Interactive Features in Google Sheets
2
This is the Golden Rule in GSheets
3
4
Do this first!
To get your own interactive copy: Go to File > Make a copy... to save in your Google Drive
5
6
7
8
9
10
Things to pay attention to on an interactive spreadsheet
11
12
Five common items in GSheets
Features to check out
Actions of the features
13
14
type number in yellow cells
15
1
type a number in the yellow cell
then hit the enter key after typing
16
yellow cells supply information to other cells
17
18
don't type here - formula in blue cell to perform a calculation!!!
19
2
see what happens to the number
0
blue cells produce a result
20
21
22
cell with a note
23
3
put your cursor over this cell
cursor over
gives additional info!!!!
24
25
26
check boxes
27
4
click on the box in the middle of the cell
this is like an on-off switch
28
check and see a response
can turn data on-off on a graph
29
30
31
5
choices on a dropdown menu
dropdown menu
32
Which animal moos?
33
click on the dropdown menu and select a choice
pick an animal
this allows selection of different values or items
34
check out right and wrong selections
info can be supplied to a calculation and change results
35
36
37
38
Sinex 2024
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100