The resulting spreadsheet can be found below. In cell G9 the first cell address

Question

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?

A) -ROUND(E9*$E$3,0)

B) +INT($E$3*E9,0)

C) -ROUNDUP(E9*$E$3,0)

D) None of the above

I 3 Quit rate 0.1 4 Hires per year 5|Starting number of facutly 80 Starting Ending 8 Year faculty Hires faculty 76 11 69 63 14 63 61 15 61 17 57 18 10 gy-76-72 69 66 63 61 59 57 55 53 TO 2 9 6 3 1 66665 G 4444444444 1234567890 D

Explanation / Answer

ROund up function should be used to measure the safe number.

Hence, the answer is -ROUNDUP(E9*$E$3,0) to round the starting faculty who didnt quit to a higher level

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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