Excel Tutorial Part 2

Directions: Answer the question for sections I-III on a separate sheet of paper and build the Excel document below.

For this portion of the class you will be learning how to use Microsoft Excel by working through the tutorial at http://www.usd.edu/trio/tut/excel/index.html

 Begin this time with the web page under Specific formulas entitled SUM, and End at the MIN page!!!!!!!!!!!!!!!

Run both the Excel program and Internet Explorer so you can toggle back and forth between the tutorial and Excel.

I. Define the following terms in your own words to receive credit:

1. SUM function

2. Average function

3. MAX function

4. MIN function

II. Short Answer

Using the chart on the SUM page answer the following questions

1. What is the answer for the following SUM function  =sum (A1:A3)

2. What is the answer for the following SUM function  =sum (A1:A3, 100)

3. What does the : command do in the function above.

4. What is the answer for the following SUM function  =sum (A1+A4)

5. What is the answer for the following SUM function   =sum (A2+A)

Using the chart on the AVERAGE page answer the following questions

6. What is the answer for the following Average function =average (A1:A4)

7. What is the answer for the following Average function =average (A1:A3)

III. Multiple Choice

1. _________ is a way to get the highest number in a selected range of cells

a) SUM function  b) MAX function c) Average function     d) MIN function

2. _________ is a way to get the smallest number in a selected range of cells

a) SUM function  b) MAX function c) Average function     d) MIN function

3. _________ is a way to get the average of the specified data

a) SUM function  b) MAX function c) Average function     d) MIN function

4. _________ takes all of the values in each of the specified cells and totals their values

a) SUM function  b) MAX function c) Average function     d) MIN function

IV. Excel Activity

Step 1- Use the Excel Worksheet spreadsheet at the bottom of this page.

Step 2- In cell A1 type in the Label Grade 1, in cell A2 type in the Label Grade 2, in cell A3 type in the Label Grade 3, in cell A4 type in the Label Grade 4, in cell A5 type in the Label Grade 5, and in cell A6 type in the Label Grade 6, in cell A8 type in the Label Sum of the Grades, in cell A9 type in the Label Average Grade, in cell A10 type in the Label Highest Grade, and in cell A11 type in the Label Lowest Grade.

Step 3- In cell C1 type in 100, in cell C2 type in 80, in cell C3 type in 85, in cell C4 type in 90, in cell C5 type in 67, in cell C6 type in 70.

Step 4- In cell C8 type in =sum(C1:C6) and then press Enter on the keyboard.

Step 5- In cell C9 type in =average(C1:C6) and then press Enter on the keyboard.

Step 6- In cell C10 type in =max(C1:C6) and then press Enter on the keyboard. 

Step 7- In cell C11 type in =min(C1:C6) and then press Enter on the keyboard.

Step 8- Write the answers that you get for Steps 4-7.

Step 9- Using the same set of functions that you have done above go to cell C9 and type in =average(C1:C6,10)

Step 10- What is the new average?

Back to Assignments Main Page

---