PROTECTED VIEW Be careful -files from the Internet can contain viruses. Unless you need to edit, it's s 17 Chapter 5 Using Excel S P5-48 Using Excel to prepare a multi-step income statement s Cougar Mountain Sports has prepared an adjusted trial balance for the fiscal year ended Jun 6 Use the blue shaded areas on the income statement worksheet for inputs 8 Requirements 1. Use Excel to prepare a multi-step income statement based on the adjusted trial b a Use formulas to link the balances on the adjusted trial balance to the amount areas of the income Statement. For example, the Rent Expense is divided into 10 b. Use a formula to add and subtract account amounts as indicated c. Format the numbers in the dollar columns with a comma and no decimal place column and at the total (e.g. $26.201). Make sure the decimal places align Double-underline the total. d. 2. Compute the gross profit margin percentage. Format percentages to two decimai 15 16 Excel Skills 1. Enter numbers or text into cells 2. use formulas to add or subtract 18 19 3. Select the number format (dollar signs). 20. 4. Select the percentage format (%) to two decimal places. 21 5. select the border (double underline) 6. Use the Increase indent button to indent items in the income statement 23 24 25 26 InstructionsAdjusted Trial Balance Income Statement Ready