\"I NEED STEP BY STEP INSTRUCTION PLEASE, CORRECT ANSWER.. IF YOUR UNSURE DONT A

Question

"I NEED STEP BY STEP INSTRUCTION PLEASE, CORRECT ANSWER.. IF YOUR UNSURE DONT ATTENTED TO ANSWER THE QUESTIONS"

ONLY NEED HELP WITH NUMBERS #7 and #10.

nsert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied, if not, the student only pays the base price. Use appropriate relative and absolute cell references 8 Copy the formula from cell E5 to the range E6:E11. Apply Accounting number format to the range E5:E11 10 Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references

Explanation / Answer

Hi

For the 7th question,

Since, data provided is insufficient, I've made the following assumptions:

a)I could see that every student has a ring name against his/her name.Assuming that the D column has the values that tell whether the student has chosen to personalize the ring or not , i.e., If the value is Yes, the student has chosen to personalize the ring else the student has not chosen to personalize the ring.

b)Assuming that the student has not paid any advance amount, I am considering the total due amount same as the total cost to be paid

Note: You can change the condition if my assumption isn't matching your requirement.

Answer:

For the 10th question,

More information to calculate the monthly payment is required, for eg: What percent of the ring cost should be paid each month along with the interest if any.

Once you get a clarity on the requirement, you can try forming the logic.

All the best. Please revert in case of any queries.

Thanks

Manasa B

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.