80.2K

Verified Solution

Link Copied!

Figure 1 A B 1 Price Cost per unit 25 3 2 3 4 5 6 7 8 9 Quantity 5 Cost =C5*C7 10 11 12 Revenue =C7*C4 13 3 Profit =C11-09 Figure 2 B Price Cost per unit 25 3 1 2 3 4 5 6 7 8 9 10 11 12 13 Quantity 5 Cost 15 Revenue 125 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. a. There is a formula associated with cell C9 b. There is a value associated with cell C9 c. There is both a formula and a value associated with cell C9 d. There is neither a formula nor a value associated with cell 09 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! 1.115 0 d. 110 None of the above C. e. a. 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? #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 D4:013, without selecting any Paste Special options, what value would appear in cell D13 a. #NUM! b. -15 0 d. 110 e. None of the above C

Answer & Explanation Solved by verified expert

See Answer