Question
30. The local alpaca rancher begins year 1 with 80 animals. She acquires 4 additional animals each year, and each year 10% (rounded to the
30. The local alpaca rancher begins year 1 with 80 animals. She acquires 4 additional animals each year, and each year 10% (rounded to the nearest integer) of the alpacas present at the beginning of the year are stolen by rustlers. For example, in a year where there are 73 animals at the beginning of the year, 7 would be abducted at the end of the year. The rancher needs to know how many alpacas she will have at the end of year 10. The spreadsheet she employs can be found below. In cell E6 the first cell address referred to was cell C6. If the formula is entered in cell E6 and is copied down through E7:E15, what completes the formula?
A: + D6 -ROUND(C6*$C$1,0)
B: + D6 +INT($C$1*C6,0)
C: + D6 -ROUNDUP(C6*$C$1,0)
D: 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