1. At Simpson University, students who register for at least 12 credits are considered to be Full-Time students and pay $4,800 tuition. Students who register for less than 12 credits are considered to be Part-Time students and pay $400 per credit. Create a worksheet that allows you to enter a student’s name and the number of credits for which he or she is registering. The worksheet should then display (1) the status of the student (Full-Time or Part-Time) and (2) the amount of tuition owed. Try it with your own name and the number of credits that you are taking this semester. Hint: Use the IF function.

The output of the excel functions is shown below
https://d2vlcm61l7u1fs.cloudfront.net/media%2F560%2F56000da0-d542-4307-a84e-8b57fd16a415%2FphpE2Pihc.png
https://d2vlcm61l7u1fs.cloudfront.net/media%2F99f%2F99f63b76-886c-45bd-8728-4c0bccc95d51%2FphpfZWvFp.png
Name No of credits Status Tution owed
Alan 12 full time 4800
John 11 Part-time 4400
Mike 13 full time 4800
Anna 12 full time 4800
Joshua 9 Part-time 3600
kristen 3 Part-time 1200
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"