Question: Modify the formula so that the cell references are partially absolute - that is the row number is anchored ( has a $ sign in
Modify the formula so that the cell references are partially absolute that is the row number is anchored has a $ sign in front of it but the column letter is not.
Caiculate in C the Dally Labour Cost for the Small Shop as the Hours per Day Available times the Workshop Labour Cost per Hour an assumption Again, this should use only a partal absolute reference to the assumption value anchoring just the row number.
In cell we need to calculate the tolal number of hours it will take to produce the tem indicated in cells C:C Fven though cells and will only ever be we want to be sure the formula covers all options. Create a formu a that adds together the products of the Number of ltems beng made times the Time to Make assumption associated w th that ttem.
The formula should look something like this not the complete formula:
Assumptionsi$CS CAssumptions $$dots
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
