Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Students also viewed these Databases questions

Question

Please also state the balance for the account in five years

Answered: 1 week ago

Question

What is the purpose of the Salary Structure Table?

Answered: 1 week ago

Question

What is the scope and use of a Job Family Table?

Answered: 1 week ago