I need the excel formula to solve each question, not just the answer.

Formula: Divide; Cell Referencing Using Excel to Perform Vertical Analysis PROBLEM Data from the comparative balance sheets of Rollaird Company are presented here. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. Perform vertical analysis. Accounts receivable (net) Inventory Total assets December 31, December 31, 2020 2019 $ 460,000 $ 400,000 780,000 650,000 3,164,000 2,800,000 December 31, 2020 Amount Percent December 31, 2019 Amount Percent 400,000 Accounts receivable (net) $ 460,000 $ Inventory 780,000 650,000 5 Total assets 3,164,000 2,800,000