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?

Question

Alessandro Ross

Computers & Technology

Yesterday, 20:16

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?

+1

Answers (1)

Know the Answer?

Hodges · Answer 1

The correct answer to the following question will be "B9:B18-ROUND (0.1*B9:B18,0) + C9:C18".

Explanation:

The ROUND function of Excel seems to be an adaptive feature in excel that calculates the first round amount of a specific number with either the numerical value or digits to be given as just a statement.

For rounding rolling quantities to a defined degree of accuracy you can use this function named ROUND.

The description of the above statement is as follow:

The formula will be used in that manner B9 along with colon B18 after that subtract (-) and using the round function (In this we pass the range i. e B9:B18,0) Plus C9 : C18.