A B C D E F G M N O P Q 1 Function: SUM; Formula: Add, Subtract; Cell Referencing 3 Using Excel to Prepare a Partial Income Statement Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. 5 Barto Company provides the following information for the month Use cell references to the Problem area along with mathematical 6 ended October 31, 2022. formulas for amounts not given. Sales on credit $ 300,000 9 Cash sales 150,000 Prepare the sales section of a multiple-step income statement based 10 Sales discounts 5,000 on this information. 11 Sales returns and allowances 19,000 12 Barto Company 13 Income Statement (Partial) 14 For the Month Ended October 31, 2022 15 Sales 16 17 Less: 18 19 20 25HINT The order of items on your multiple step income statement should be the order shown below. In other words, the order of some items on the multiple step income statement have more than one acceptable option in real life, but for this spreadsheet, you must use the order below. PW Audio Supply, Inc. Income Statement (partial) Sales Sales revenue $480,000 Less: Sales returns and allowances $12,000 Sales discounts 8,000 20,000 Net sales $460,000 Bee