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 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
Get step-by-step solutions from verified subject matter experts
