Multiple Choice
If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values?
A) B4-B5*A8
B) B4-B5*$A8
C) $B4-B5*$A8
D) $B$4-$B$5*$A8
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q4: Use the data given below to
Q5: If purchase quantities of 25 units or
Q6: Use the data given below to
Q7: If cell G7 contains the function ,
Q8: What is the Insert function in Excel?
Q10: To copy a formula from a single
Q11: For which of the following MATCH functions
Q12: Trace the process of copying and pasting
Q13: The function returns a value or reference
Q14: Use the data given below to