Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Area Europe S. Ameri Far East Australia N. Ameri 2005 Q4 $32 $26 $49 $22 $11 Q1 $33 $29 $62 $64 $67 Status Trend 33
Area Europe S. Ameri Far East Australia N. Ameri 2005 Q4 $32 $26 $49 $22 $11 Q1 $33 $29 $62 $64 $67 Status Trend 33 29 62 64 67 2006 Gross Profits (in Millions) Q2 Status Trend Q3 Status Trend $81 81 $72 72 $30 30 $42 42 $70 70 $43 43 $78 78 $38 38 $77 77 $35 35 Q4 $56 $69 $63 $45 $76 Status Trend 56 69 63 45 76 Require 1. For the Status Columns, format the cells with an Icon Set with a Green Check Mark for values greater than or equal to 50, a Yellow Exclamation mark for values less than 50 but greater than or equal to 45, and a Red X for all others. 2. Populate the cells in the Trend Columns with a formula that returns the difference between the most recent quarter and the quarter preceding it 3. For the Trend Columns, format the cells with an Icon Set that returns a Green Arrow oriented Up for values greater than or equal to 5, a Yellow Arrow oriented to the Right for values less than 5 and greater than or equal to 0, and a Red Arrow oriented Down for all others
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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