Computer
posted by Shinal .
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.
Respond to this Question
Similar Questions

Social studies
I need help on the assignment that is due on 11/26. I am requesting Angela Cooper for assistant. Please let me know and I will submit the assignment. 
physics
Mary and John are on opposite sides of a seesaw. Mary has 3x the mass of John. If Mary is sitting at a distance of .5m from the fulcrum, how far must John site in order to keep it balanced. 
Linguistics
Determine whether the following are entailment, presupposition, or both. 1) (A) Mary murdered the platypus (B) Mary killed something Is the answer: (a) entails (b) OR (a) presupposes (b) OR both 2) (A) John is taller than Mary (B) … 
Math
Find the ages of John and Mary if four times John's age equals three times Mary's age, and Mary is ten years older than John. 
english
Questions about Avi(the author) Why was school a constant struggle for him? 
math
Two students, Mary and John, play a game. Each time Mary passes “start” she received $25. Each time John passes “start” he receives 15% of the amount he already has. Both students start with $200. a. How much money will Mary … 
math
there are 15 students including john and mary, in the art club of a school a committee of 3 men consists of chairman secretary and treasurer is selected from the club. if john and mary cannot be both selected how many different committees … 
science computer
The program will accept the final marks of a group of students in a class. The lecturer can choose '1' to finds the highest and lowest marks in the class. The lecturer choose '2' to find the average marks of that class. If user enter … 
computer
Write an algorithm to enter marks of three subject for 100 students and find average and percentage if age is greater than 20 and less than 25 
Maths
There are fifty students in a class. In a 100 marks exam, 20 students scored less than 30 marks, 5 students scored more than 70 marks and the remaining scored between 30 and 70 marks. If passing score is 55 marks and 40% students have …