Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 spreadsheet can be found below. In cell G9 the first cell address referred to was cell E9. If the formula is entered in cell G9 and is copied down to G10: G18, what is it followed by? -ROUND(E9*$E$3, 0) +INT($E$3*E9, 0) -ROUNDUP(E9*$E$3, 0) None of the above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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