Show me your basic Excel worksheet skills. 1) Begin by creating a new sheet IN THIS...

Transcribed Image Text:

Show me your basic Excel worksheet skills. 1) Begin by creating a new sheet IN THIS Workbook. 2) Format in landscape with narrow margins AND for Printing! 3) Name your file according to the convention in our Syllabus. 4) Create a multi-step income statement using the appropriate titles, account names, and formatting. You may need to look back to ACCT 221 studies. 5) Format numbers and USE formulas! I should see all the math handled in Excel. 6) Use Fill Color an Borders as appropriate. 7) Calculate the gross margin and profit margin below the statement.) In its income statement for the year ended December 31, 2022, Darren Company reported the following condensed data. Salaries and wages expense $465,000 Loss on disposal of plant asset $83,500 Cost of goods sold 987,000 Sales revenue 2,210,000 Interest expense 71,000 Income tax expense 25,000 Interest revenue 65,000 Sales discounts 160,000 Depreciation expense 310,000 Utilities expense 110,000 Show me your basic Excel worksheet skills. 1) Begin by creating a new sheet IN THIS Workbook. 2) Format in landscape with narrow margins AND for Printing! 3) Name your file according to the convention in our Syllabus. 4) Create a multi-step income statement using the appropriate titles, account names, and formatting. You may need to look back to ACCT 221 studies. 5) Format numbers and USE formulas! I should see all the math handled in Excel. 6) Use Fill Color an Borders as appropriate. 7) Calculate the gross margin and profit margin below the statement.) In its income statement for the year ended December 31, 2022, Darren Company reported the following condensed data. Salaries and wages expense $465,000 Loss on disposal of plant asset $83,500 Cost of goods sold 987,000 Sales revenue 2,210,000 Interest expense 71,000 Income tax expense 25,000 Interest revenue 65,000 Sales discounts 160,000 Depreciation expense 310,000 Utilities expense 110,000