Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. There are multiple conditional formatting rules applied to cells in the Financial Data worksheet. Make changes to the conditional formatting rules on this worksheet

image text in transcribed
3. There are multiple conditional formatting rules applied to cells in the Financial Data worksheet. Make changes to the conditional formatting rules on this worksheet only. a. There should be three conditional formatting rules: a Top 2 rule, a Bottom 2 rule, and an Icon Set rule. Delete all the extra rules. b. Correct the cell range for the remaining rules. All the rules should be applied to cells D5:G20. c. Fix the remaining conditional formatting rules so if the value of the cell is in the top 2 values or the bottom 2 values, the icon rule is not applied. 4. Now that the conditional formatting rules have been fixed, sort the data alphabetically by the value in the Location column and then by icon in the Quarter 1 column so rows with the up arrow are at the top and rows with the bottom arrow are at the bottom. a. If necessary, be sure to click a cell in the data set to deselect the D5:G20 cell range or the sort will be applied to only the selected cells and your data will be mixed up. b. You will need to use the Sort dialog as this requires a multilevel sort. c. If the sort is performed correctly, the data will be sorted by location, and then within each location, by the icon in the Quarter 1 column. 5. An advanced filter should be performed to find any locations with a profit/loss for any quarter less than or equal to 10,000. The results should be copied to cell 14. a. The criteria range beginning in cell A23 is set up incorrectly. The criteria for this filter should include values

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

Students also viewed these Accounting questions