For Google find

Ch $4.$ "Calculate the gross margin ratio for each company in $2019$ and $2018.$ Use formulas with cell references. For $2019$ and $2018,$ select the company that earns more in gross margin for each dollar of net sales and fill in the cells with yellow. $($Select two cells as a team $--$ for each year choose Apple, Google, or Samsung.$)"$

Ch $4.$ For $2019$ and $2018,$ did your company's gross margin ratio underperform or outperform the $35\%$ industry average? Enter "underperform" or "outperform" for each company for each year.

Ch $4.$ Is the change from $2018$ to $2019$ in your company's gross margin ratio favorable or unfavorable? Enter "favorable" or "unfavorable" in your $2019$ column.

Ch $5.$ Calculate the inventory turnover for each company in $2019$ and $2018.$ Use formulas with cell references.

Ch $5.$ For $2019$ and $2018,$ did your company's inventory turnover underperform or outperform the industry's average turnover of $15?$ Enter "underperform" or "outperform" for each company for each year.

Ch $5.$ Calculate the days' sales in inventory for each company in $2019$ and $2018.$ Use formulas with cell references.

Ch $6.$ Calculate the days' sales uncollected for each company in $2019$ and $2018.$ Use formulas with cell references. For $2019$ and $2018,$ select the company that was most successful in collecting receivables and fill in the cells with yellow. $($Select two cells as a team $--$ for each year choose Apple, Google, or Samsung.$)$

Ch $7.$ Calculate the accounts receivable turnover for each company in $2019$ and $2018.$ Use formulas with cell references. For $2019$ and $2018,$ select the company that most quickly collects its accounts receivable and fill in the cells with yellow. $($Select two cells as a team $--$ for each year choose Apple, Google, or Samsung.$)$