Question: Figure 4 A B 1 D 2 3 4 1 3 6 5 4 6 7 7 00 UN 9 8 9 10 =A4*$A5+$B$4*B$5 14.

Figure 4 A B 1 D 2 3 4 1 3 6 5 4 6 7 7 00 UN 9 8 9 10 =A4*$A5+$B$4*B$5 14. For the model in figure 4, the value for cell 010 is 14. If the formula from D10 is copied to the cell F10, what should the value for cell F10 be (hint: first figure out what the formula would be for cell F10)? a. #REF! b. 0 c. 10 d. 12 e. 38 15. The value for cell D10 is 14. If the formula from D10 is copied to the cell F11, what should the value for cell F11 be? a. #REF! b. 0 c. 12 d. 38 e. None of the above 16. The value for cell D10 is 14. If the formula from D10 is copied to the cell 012, what should the value for cell D12 be? a. #REF! b. 0 C. 10 d. 12 e. None of the above 17. The value for cell D10 is 14. If the formula from D10 is copied to the cell C12, what should the value for cell C12 be? a. 0 b. 10 C. 38 d. None of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
