Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cyber Security And Supply Chain Management

Authors: Steven Carnovale, Sengun Yeniyurt

1st Edition

9811231567, 978-9811231568

More Books

Students also viewed these General Management questions