Computer
posted by Shinal on .
12. Enter the following Marks for Assignment One figures:
Name
Assgn 1
John
10
Mary
12
Emma
15
Pita
15
Avi
15
Ramu
10
Sani
11
13. Due to a recent natural disaster, MAF11 students were unable to submit their assignments 2 and 3. The Course Coordinator then decided to award marks to each student based on the following criteria:
a. Assignment 2: Increase Assignment 1 mark by 10 percent.
b. Assignment 3: Take the average of Assignments 1 and 2 marks.
Create formulas that will achieve the above.

a. assignment 2
f(x)=1.1x
b. assignment 3
g(x)=(x+f(x))/2=(x+1.1x)/2=1.05x 
Please may you please explain it in the form of Microsoft Excel? please.

Create a third column (C) titled "assignment 2".
Assume John is in row 2.
In cell C2, enter
+1.1*B2
Copy Cell C2 to the remaining cells of column C.
Now create a fourth column (D) titled "assignment 3".
Again, assume John is in row 2.
In cell D2, enter
+(B2+C2)/2
Copy the cell D2 to the remaining cells of column D.
Sani (last student) should get 1.155 for assignment 2.
Adjust formatting to have a fixed number of decimals.