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.
6. Caiculate in C6 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.
7. In cell C13, we need to calculate the tolal number of hours it will take to produce the tem indicated in cells C8:C11. Fven though cells C10 and C11 will only ever be 0, 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):
=C8** Assumptionsi$CS6+ C9*Assumptions 1$C$7+dots
 Modify the formula so that the cell references are partially absolute

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!