Select cell H9 in the HomeDepot worksheet. Enter a formula into column H9 to calculate Sales per Employee for the year 1983. The formulas is Sales $\div$ (Employees *1000) Bulk copy (using the fill handle) this formula down all rows of the data table. What is the sales per employee value for the year 2020? $ 262.00 $ 333.76 $219.86 $201.22 $106.74 $ 207.36
Added by Johnathan A.
Close
Step 1
Step 1: Open the HomeDepot worksheet in your spreadsheet application. Show more…
Show all steps
Your feedback will help us improve your experience
Keondre Parker and 78 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Monthly net sales are given in Table 8,compute cumulative sales using Formula with appropriate cell references. Apply the "Monthly Net Sales" (B86) to determine the "Year To Date Cumulative Net Sales" in cell D86 and copy over and down through to cell D97. You should write a formula such that when the Formula is copied, it computes the "Year To Date Cumulative Net Sales" amount correctly. Hint: Please go through Learning Exercise 8.6, a similar exercise was solved. Table 8 : Cumulative Net sales Month Monthly Net sales Year to Date Cumulative Net sales January February March April May June July August September October November December 73,700 93,500 100,050 86,400 82,000 96,800 103,050 94,450 96,100 130,000 141,000 120,950
Akash M.
Supreeta N.
Excel question: An alpaca rancher would like to show how the size of her herd at the end of year 10 depends on the abduction rate and the number of annual acquisitions. She would like, for example, to have cell I7 give the number of year 10 alpacas if she acquires one animal per year and loses 10% each year. Using the information presented in the spreadsheet below, what would be the column input cell for a two-way data table? C$3 $C$2 C2 $C3
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD