Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Select cell H 9 in the HomeDepot worksheet.Enter a formula into column H 9 to calculate Sales per Employee for the year 1 9 8

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 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 2000?Question 2 options:$ 333.76$ 262.00$ 219.86$ 106.74$ 201.22$ 207.36Hide hint for Question 2Sales are in colum D.Employees are in column B. The employee value must be multipled by 1000 to convert thousands of employees to actual employees.You can use a $ in front of the column letter for Sales to lock the sales part of this formula into column D.Do not use a $ in front of the row number for Sales; rows should be relative.Do not use a $ in front of the column letter for Employees. Column B should be a relative reference.Do not use a $ in front of the row number for Employees; rows should be relative.The value displayed in cell H9 should be $ 106.74

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

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions