Adjust the size of the columns as needed. Calculate the final average in G – average the 3 test grades and multiply them by .90 (90%) add in the 10% of the participation grade. =c5*.3+d5*.3+e5*.3+f5*.1 Now calculate the average for columns C, D, and E. After completing the Excel exercises, please upload the Excel file with your results to SLP 1 Dropbox.

This is the assignment below, when I am in excel do I need to input the formula =c5*.3+d5*.3+e5*.3+f5*.1    ? It is so confusing if so where does it go?

A B C D E F G1 ITM 389 

2 Fall 2020 

3 Test1 Test2 Test3 FINAL

4 STUDENT NAMES STUDENT ID #1 #2 #3 PART. AVERAGE

5 Tilly, Susan 999-25-5683 84 65 89 90 

6 Shulz, Ben 999-52-6938 93 71 97 70 

7 Raymond, Dorthy 998-71-2838 62 83 58 90 

8 Smith, Betty 997-74-4447 95 94 80 90 

Adjust the size of the columns as needed.

Calculate the final average in G – average the 3 test grades and multiply them by .90 (90%) add in the 10% of the participation grade. =c5*.3+d5*.3+e5*.3+f5*.1

Now calculate the average for columns C, D, and E.

After completing the Excel exercises, please upload the Excel file with your results to SLP 1 Dropbox.

SLP Assignment Expectations

Your assignments will be graded following these expectations:

• The assignment file must be developed in Excel and saved as .xls file.

• Precision: The questions asked are answered.

• Clarity: Your answers are clear and show your good understanding of the topic.