The Hudson School Hoboken New Jersey
Dr. Terrell Neuage
Excel Monday 19 April

Part 1

Formulas (Mathematical Operations)

• Formulas are entered into the Formula Bar.
• Formulas must begin with an equal sign "=".

Example - Suppose you wanted to add the total amount of money earned in a bake sale.

The formula =B3+B4+B5 means:

Add:

• B3 (Monday's earnings),
• B4 (Tuesday's earnings),
• B5 (Wednesday's earnings)

Basic Functions

Functions can be a faster way of doing mathematical operations than formulas.

Example - if you wanted to add the values of cells D1 through D10, you could type the formula "=D1+D2+D3+D4+D5+D6+D7+D8+D9+D10".

A shorter way would be to use the SUM function and simply type "=SUM(D1:D10)".

Two popular functions and examples are given in the table below:

Sorting

To sort means to alphabetize.

The Sort Buttons

 

Autofill

The Autofill feature allows you to quickly fill cells with data such as months or numbers, and repeated text.

• Type the beginning number or date of a series or the text that will be repeated into a cell.
• Select the handle at the bottom, right corner of the cell with the left mouse button and drag it down as many cells as you want to fill.
• Release the mouse button.

Autofill Functions

Autofill can also be used to copy functions.

In the example, column A and column B each contain lists of numbers and column C contains the sums of columns A and B for each row.

The function in cell C2 would be "=SUM(A2:B2)".

To copy this function:

• Select the handle at the bottom, right corner of the cell.
• Hold down the left mouse button.
• Drag down as many cells as you want to fill.

Burger King http://www.bk.com/
Wendy's http://www.wendys.com/
McDonalds http://mobile.mcstate.com/nutrition/
Chick fil A http://www.chick-fil-a.com/#nutritiondata
See also http://www.nutritiondata.com/

How Healthy Are Your Fries? - Do a comparison of the calorie, fat and sodium content of fries for each fast food company.

Large Burgers – Do a comparison chart of the calorie, fat, sodium, and protein content of the largest burgers for each fast food company.

Shakes - Is there any difference in shakes from one company to another? Make a chart using variables you think will show the greatest differences from company to company.

Pretend you work for one of the fast food companies. Using the data for small burgers, make a chart using any variables that will make your company look more favorable than the others.

Mc Donald’s

Burger King

Wendy’s  

White Castle

Thursday 22 nd
Present the charts as follows:

• Make sure each chart has a title that is CAPITALIZED.
• Make sure each axis has a label and that all the words are spelled correctly.
• Copy and paste the charts into Word.
• When you are in Word, select FILE> PAGE SETUP> PAPERSIZE> and choose Landscape.
• Resize the chart so that it fits nicely on a page.
• Write a one or two sentence summary of the findings of your chart.
• Arrange the charts on poster board with titles, labels, etc.

Use Excel and the data below to make graphs of the following :

contact Myanmar 2014

Blog updated February 15, 2014  K - 12 technology (updated February 04, 2014). Travel Site (2014) updated February 14, 2014. Videos/Blogs on Youtube, Twitter, Wordpress, Photo albums. Updated 15 Second Street, Round Lake, New York and photos from parent's 1943 wedding as well as Leigh's page. Farmville page updated Thursday, March 17, 2011 5:58 PM. neuage.org updated February 11, 2014 10:31 PM     neuage.us updated February 05, 2014 7:21 PM.    Resume updated February 05, 2014    

Technology Coordinator and Computer Teacher at Dalian American International School, 2 Dianchi Road, Golden Pebble Beach, Dealian Development Area 116650 P.R. China        

Blog updated / Integrating Technology Blog February 10, 2014.  also: terrell.neuage.us and/or neuage.me

Today working on picture poem links starting around "better" (February 14, 2014). Picture poems are the digital format of work I did as a street artist in New Orleans in the 1970s, as well as New York City, Honolulu, San Francisco and Adelaide South Australia. Follow @neuage