Question: 10) Given that D= a - be where D, is demand, a and b are linear constants, and P, is price, from the below spreadsheet,

 10) Given that D= a - be where D, is demand,
"a" and "b" are linear constants, and P, is price, from the

10) Given that D= a - be where D, is demand, "a" and "b" are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing? A) B4-BS*A9 B) 84-85*A10 C) 85-86*A10 D) C5-C6A10 A) B4-B5*A9B) B4-B5*A10 C) 85-86*A10 D) C5-C6*A10 11) If, in the spreadsheet, cells 89 and 810 were empty, which of the following formulas should be entered in 38 so that the formula can be dragged to B9 and B10 to obtain their correct values? A) SB$4-$B$S SAB B ) B4-BS SA8 C ) $B4-85*SA8D ) 84-85*A8 10) Given that D= a - be where D, is demand, "a" and "b" are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing? A) B4-BS*A9 B) 84-85*A10 C) 85-86*A10 D) C5-C6A10 A) B4-B5*A9B) B4-B5*A10 C) 85-86*A10 D) C5-C6*A10 11) If, in the spreadsheet, cells 89 and 810 were empty, which of the following formulas should be entered in 38 so that the formula can be dragged to B9 and B10 to obtain their correct values? A) SB$4-$B$S SAB B ) B4-BS SA8 C ) $B4-85*SA8D ) 84-85*A8

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 Accounting Questions!