Using an Excel worksheet, which one of the following formulas is correct when calculating the MPI $2023$ sales forecast in B$7?$

a$.$

$=$TREND$($B$$2$:B$$5$;A$$2$:A$$6$;A$7$;TRUE$)$

b$.$

$=$TREND$($B$$3$:B$$6$;A$$2$:A$$6$;A$7$;TRUE$)$

c$.$

$=$TREND$($B$$2$:B$$6$;A$$2$:A$$6$;A$7$;TRUE$)$

d$.$

$=$TREND$($B$$2$:B$$7$;A$$2$:A$$6$;A$6$;TRUE$)$