What formula should you type into column c$,$ in order to calculate the amount of sales planned for this year? Use an absolute cell reference to refer to the cell that contains $30\%.$ If done correctly, cell C$7$ shouldnresult in $$1,960\mathrm{.}00.$