Figure 1 A B 1 Price Cost per unit 25 3 2 3 4 5 6 7 8 9 10 11 Quantity 5 Cost =C5*C7 Revenue =C7*C4 12 13 Profit =C11-09 Figure 2 A B 25 NMONO Price Cost per unit Quantity 5 9 Cost 15 10 11 Revenue 125 12 13 Profit 110 7. Figure 2 shows the values for all the cells from the model shown in Figure 1. It is the same spreadsheet, just using the values view instead of the formula view. Considering cell C9 in both figure 1 and figure 2, which of the following is true. There is a formula associated with cell 09 b. There is a value associated with cell C9 There is both a formula and a value associated with cell C9 d. There is neither a formula nor a value associated with cell C9 a. C. 8. If the formula for profit in cell C13 was copied and pasted to the cell C15, what value would appear in cell C15? a. #NUM! 16.15 C. o d. 110 e. None of the above 9. If the formula for profit in cell C13 from figure 1 was copied and pasted to the cell E13, what value would appear in cell C15? a. #NUM! b. -15 C. 0 d. 110 e. None of the above 10. If you were to copy and paste the contents of cells C4:C13 to the range 04:013, without selecting any Paste Special options, what value would appear in cell D13 a. #NUM! b. -15 c. 0 d. 110 None of the above e