Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started