Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Enter the following data in a worksheet (this are data NOT user input cells): Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales $65,400

image text in transcribed
Enter the following data in a worksheet (this are data NOT user input cells): Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales $65,400 $68,900 893,500 $49.100 Advertising Expense Rent Expense Wage Expense Total Operating Expenses 9.100 $10,200 $15,000 $1,900 $1,900 $1,900 $2,200 $2,200 $20,000 $21,000 $25,000 $28,000 Operating Income Complete all of the following required items: Add formulas that calculate the Total Operating Expenses and Operating Income for each quarter. Add formulas in the Year column that sum the total for the year by adding up the four quarters for each item. Conditionally format the quarterly rent expense cells so that every cell containing $1,900 is formatted with Green Fill with Dark Green Text. Conditionally format the quarterly operating income cells so that the three smallest quarterly operating income amounts are formatted with Light Red Fill and Dark Red Text. Conditionally format the year total amounts for advertising expense, rent expense, and wage expense with a solid fill data bar (your choice of color). . Conditionally format the four quarterly sales amounts with an icon set of your choice. In the cell below the total operating income for the year, create a formula using an IF function and an IS function. If the total operating income is even, then display "Great Income!" If the income is odd, then display "What an odd income." Conditionally format the header (first) row of the data such that if a cell contains the word Year, then the cell has yellow fill, red text, and uses the bold italic font style (you will have to customize the conditional formatting to get this resulta

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

Students also viewed these Accounting questions