Answered step by step
Verified Expert Solution
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 H in the HomeDepot worksheet.Enter a formula into column H to calculate Sales per Employee for the year 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 Question options:$ $ $ $ $ $ Hide hint for Question Sales are in colum DEmployees are in column B The employee value must be multipled by 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 DDo 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 H should be $
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