# Computer

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.

asked by Shinal
1. a. assignment 2
f(x)=1.1x

b. assignment 3
g(x)=(x+f(x))/2=(x+1.1x)/2=1.05x

posted by MathMate
2. Please may you please explain it in the form of Microsoft Excel? please.

posted by Shinal
3. 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.

posted by MathMate

## Similar Questions

1. ### 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.
2. ### 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.
3. ### 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)
4. ### math

Mary and John are 128 miles apart. A car leaves Mary traveling towards John and another car leaves John at the same time traveling towards Mary. The car leaving Mary averages 10 miles per hour more than the other car and they meet
5. ### Linguistics

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) Mary is shorter than John Is the answer: (a) entails (b) OR (a)
6. ### 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
7. ### java programming

Create a Sales application that prompts the user for a series of sales figures and then implements a sorting routine on the sales figures. Output. Enter the number of sales made today: 15 Enter the amount of sales 1:25 Enter the
8. ### marshall

a will states that john is to get 3 times as much money as mary.the total amount they will receive is 12.00 how much will john and mary receive
9. ### Simple Math Question

two people, john and mary, are 200 miles apart and leave at the same time to meet. They are driving toward each other at constant rate on the same straight road. John is traveling at 45 mph and Mary is traveling at 35 mph. When
10. ### Algebra 2

two people, john and mary, are 200 miles apart and leave at the same time to meet. They are driving toward each other at constant rate on the same straight road. John is traveling at 45 mph and Mary is traveling at 35 mph. When

More Similar Questions