Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CALLING ALL EXCEL EXPERTS !!! A university begins Year 1 with 80 faculty. They hire 4 faculty each year. During each year 10% (rounded to
CALLING ALL EXCEL EXPERTS !!!
A university begins Year 1 with 80 faculty. They hire 4 faculty each year. During each year 10% (rounded to the nearest integer) of the faculty present at the beginning of the year leave the university. For example, in a year where there are 73 faculty at the beginning of the year, 7 would leave the university at the end of the year. The university wants to know how many faculty they will have at the end of year 10. The resulting spread sheet can be found below. In cell G9 the first cell address referred to was cell E9. The formula entered in cell G9 and copied down to G10:G18 was E9+F9 followed by -ROUND(E9*SE$3, 0) +INT(SE$3'E9, 0) -ROUNDUP(E9'$ES3, 0) None of the above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started