Chapter_10_Applying_Excel_Student_Form-1.xIsx File Edit Insert Format Help All changes saved at-/MyFiles/Downloa Aequired informution Chapter 10: Applying Excel [LO10-1, LO10-2] the text. Chapter 10: Applying Excel: Excel Worksheet (Part 1 of 2) Downiond the Applying Eacel form and enter formulas in all cells that contain qutsten marks. Werify that your worksheer matches the Peviled Probiem in the tent these answes, find the entrs is your worktheet and conect them. Part 2. \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{O he } \\ \hline 1 & Chapter 10: Applying Excel & \\ \hline 2 & & \\ \hline 3 & Data & \\ \hline 4 & Sales & $25,000,000 \\ \hline 5 & Net operating income & $3,000,000 \\ \hline 6 & Average operating assets & $9,000,000 \\ \hline 7 & Minimum required rate of return & 25% \\ \hline 8 & & \\ \hline \end{tabular} 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: Return on Investment (ROI) and Relidual Income 11 12 Compute the ROI \begin{tabular}{l|l|l} 13 & Margin & ? \\ 14 & Turnover & ? \\ 15 & ROI & ? \end{tabular} 16 17 Compute the residual income 18 Average operating assets 19 Net operating income 20 Minimum required return 21 Residual income 22 23 24 25 26 27