Now for a tip about using Microsoft Excel.  As mentioned in Technology Tip #25, Excel is a spreadsheet program that you can use to create simple databases and to calculate formulas.  The software has obvious applications for accountants but what could teachers use it for? 

In this Technology Tip we’re going to try doing a simple calculation in Excel.

1)      Open up Excel by clicking on the desktop icon or finding it on the START menu.  I'm afraid today's tip will be meaningless for you if you don't have access to this program.  To the right is a sample of the icon that you're looking for.

2)      Type the following information just as it appears below.  Make sure that the data is in separate cells on the spreadsheet.  For example “Apples” should be typed into cell A2 and the number “4” should be typed into cell B2

3)      Now for our first formula.  Select cell B5 by clicking in it.  A dark black rectangle will appear on it (just like the one on B5 above).

4)      In the formula bar type the following:  =sum(B2+B3+B4) 

5)      When you hit the Enter key the answer to the formula should appear in cell B5 “18”

6)      The cool part about the formulas in excel is that they are dynamic, meaning they change instantly.  For example, change the number of bananas to 4 and the total should automatically change from 18 to 20.

For more information about writing formulas in excel try this website:  Tutorials.Beginners.co.uk

Featured YouTube Video
Introduction to Excel

PRACTICE ACTIVITY:   Try the above activity.  After you have that down try changing the formula to subtract the numbers (using – for minus), multiply the numbers (using * for times) and divide two of the numbers (using / for division).

TO KEEP ON LEARNING:  If you'd like to learn more about creating formulas in Excel try searching the internet for:

Excel tutorials
Making formulas in excel
Excel templates

Have a great day! 

	Web www.180techtips.com

 

 

Technology Tips Index:
 

	Microsoft Windows
	Internet
	Computer Hardware
	MS Outlook
	MS PowerPoint
	MS Excel
	MS Word
1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
26	27	28	29	30
31	32	33	34	35
36	37	38	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
101	102	103	104	105
106	107	108	109	110
111	112	113	114	115
116	117	118	119	120
121	122	123	124	125
126	127	128	129	130
131	132	133	134	135
136	137	138	139	140
141	142	143	144	145
146	147	148	149	150
151	152	153	154	155
156	157	158	159	160
161	162	163	164	165
166	167	168	169	170
171	172	173	174	175
176	177	178	179	180

Home & Index
Mission Statement
Links

Sign Up Now!
to get
Free Daily Technology Tips