Modify homework number 3 and add a column for Tuition and a column for Total. Al

Question

Modify homework number 3 and add a column for Tuition and a column for Total. Also, name the current Sheet Report. Add a new sheet called Tuition.

Above is the data for the Tuition Sheet. Tuition is calculated based on the number of credits. 1 to 3 credits 350 per credit.   4 to 6 credits 300 per credit.  7 to 9 credits 250 per credit.  10 credits and over 200 per credit. Maximum credit charge is for 12 credits. The Total is the sum of the Registration Fee plus the Tuition.

Upload the Excel spreadsheet

Tuition Credits Amount 3 350 6 300 9 250 12 200

Explanation / Answer

Sum of the registration fees plus the Tuition is 3300.

Workings:-

Tuition Sheet Credits Amounts Tuition Total 3 350 1050 1050 6 300 900 1950 9 250 750 2700 12 200 600 3300

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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