Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Date Product Region Amount 4/9/2019 Dairy Denmark 1 5/26/2019 Produce Denmark 1 12/7/2019 Produce Denmark 1 Denmark TCI 11/5/2019 Dairy Finland 7/12/2019 Dairy Finland 6/2/2019

image text in transcribed

Date Product Region Amount 4/9/2019 Dairy Denmark 1 5/26/2019 Produce Denmark 1 12/7/2019 Produce Denmark 1 Denmark TCI 11/5/2019 Dairy Finland 7/12/2019 Dairy Finland 6/2/2019 Grain Finland 1 Finland Tot 8/30/2019 Dairy Germany 7/26/2019 Dairy Germany 9/24/2019 Grain Germany 10/30/2019 Grain Germany 8/26/2019 Grain Germany 7/7/2019 Grain Germany 6/26/2019 Produce Germany 7/7/2019 Produce Germany Germany TCI 118/2019 Dairy Italy 1 2/13/2019 Dairy Italy 12/18/2019 Produce Italy 1 3/13/2019 Produce Italy Italy Total 1 1.148.00 1,530.00 1,423.50 4,101.50 192.10 351.00 560.40 1.103.50 470.00 17.40 1,405.00 470.00 17.40 747.00 17.40 747.00 3.891.20 3,194.20 438.43 3,194.20 438.43 7.265.26 Required 1. Format the values in the Amount column as Currency (Euro) with two decimal places. 2. Format the Date Column with Light Red Fill with Dark Red Text for dates that are occuring this month. 3. Format the Product Column with Yellow Fill with Dark Yellow Text for those cells that contain Grain. 4. Format the Amount Column with a Green Fill for those cells that are less than 500 euro

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

Recommended Textbook for

Cost Benefit Analysis With Reference To Environment And Ecology

Authors: James H. Meisel, K. Puttaswamaiah

1st Edition

1138521329, 978-1138521322

More Books

Students also viewed these Accounting questions

Question

=+ How about one you felt had acted in a hypocritical way?

Answered: 1 week ago