Question $9(3$ points$)$

Given that D $=$ a$-$bP$,$ where D$,$ is demand, $"$a$"$ and $"$b$,"$ are linear constants, and P$,$ is price, from the below spreadsheet, how will the formula in B$9$ be represented in Excel using relative addressing

A B C

$1$ Demand Prediction Models

$2$

$3$ Linear Model

$4$ a $10,000$

$5$ b $10$

$6$

$7$ Price Demand

$8$ $$509,500$

$9$ $$559,450$

$10$ $$459,550$

$11$

Question $9$ options:

B$4-$B$5*$A$9$

C$5-$C$6*$A$10$

B$4-$B$5*$A$10$

B$5-$B$6*$A$10$