Conditional Formatting Format as Table Editing Analyze Data Check for Updates Patte Liberation Sans 12 AA BIU 1415 %* Number Cel Styles Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 120 xfx A Using Excel to Prepare a Partial Income Statement 4 PROBLEM D Student Work Area 3 + ent 5 Barto Company provides the following information for the month ended 6 October 31, 2022. 7 Sales on credit Cash sales 10 Sales discounts 11 Sales returns and allowances 12 13 14 15 16 17 19 20 Enter Answer + $ 300,000 150,000 5,000 19.000 Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area along with mathematical formulas for amounts not given. Prepare the sales section of a multiple-step income statement based on this Information. Sales Barto Company Income Statement (Partal) For the Month Ended October 31, 2022 Sales Revenue 450,000 Less: Sales discount Sales retums and allowances Net Sales 5,000 19.000 $ 426,000 Sun, Mar 19, 2023, 11:10:23 AM (America/Los Angeles -07:00) 100%