L B C D G H E JK Apply conditional 2-color-scale formatting to the Dollars column...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
L B C D G H E JK Apply conditional 2-color-scale formatting to the "Dollars" column in such a manner that the cells with lowest (minimum) 2 values are yellow and cells with highest (maximum) values are green. Apply an additional rule which changes the color of the entire row (including the "Dollars" column that contains a return (negative dollar value) to red. B + 5 5 Assume that no transactions will be added or deleted from the list but the data about the transactions may change and the colors should update in response to these changes. DO NOT make any other format changes to the input cells other that what the assignment is asking. 7 8 Make sure to use the correct order of rules when applying the formats 0 1 When setting up conditional formatting, apply colors from the Standard Colors group: 2 Place the mouse pointer over colors to make sure that they are "Red" "Yellow" and "Geen" and not their light or dark versions 3 The above instruction applies only to picking colors (not to the gradient mechanically generated by the scale). 4 5 60 7 00 8 6 0 1 234 8 9 56700σO 12345 Trans Number Name 1 Betsy 2 Hallagan Date Product 5/1/2018 lip gloss 4/10/2018 foundation Units Dollars 45 $137.20 50 $152.01 3/25/2019 lipstick 3 Ashley 4 Hallagan 6/22/2020 lip gloss 55 $167.08 9 $ 28.72 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 7/17/2018 lip gloss 12/27/2019 eye liner 4/21/2018 eye liner 1/17/2021 lip gloss 8/5/2020 eye liner 43 $130.60 58 $175.99 8 $ 25.80 72 $217.84 75 $226.64 9/7/2020 lip gloss 24 $ 73.50 12/29/2018 mascara 43 $130.84 12 Ashley 12/18/2018 lip gloss 23 $ 71.03 13 Emilee 10/1/2019 lip gloss 49 $149.59 14 Hallagan 2/1/2019 eye liner 18 $ 56.47 15 Zaret 10/20/2020 foundation -8 $ (21.99) 16 Emilee 17 Colleen 18 Jen 5/12/2018 mascara 45 $137.39 5/30/2020 mascara 66 $199.65 10/1/2019 lip gloss 88 $265.19 19 Jen 20 Zaret 11/27/2018 eye liner 12/27/2019 lip gloss 78 $236.15 57 $173.12 L B C D G H E JK Apply conditional 2-color-scale formatting to the "Dollars" column in such a manner that the cells with lowest (minimum) 2 values are yellow and cells with highest (maximum) values are green. Apply an additional rule which changes the color of the entire row (including the "Dollars" column that contains a return (negative dollar value) to red. B + 5 5 Assume that no transactions will be added or deleted from the list but the data about the transactions may change and the colors should update in response to these changes. DO NOT make any other format changes to the input cells other that what the assignment is asking. 7 8 Make sure to use the correct order of rules when applying the formats 0 1 When setting up conditional formatting, apply colors from the Standard Colors group: 2 Place the mouse pointer over colors to make sure that they are "Red" "Yellow" and "Geen" and not their light or dark versions 3 The above instruction applies only to picking colors (not to the gradient mechanically generated by the scale). 4 5 60 7 00 8 6 0 1 234 8 9 56700σO 12345 Trans Number Name 1 Betsy 2 Hallagan Date Product 5/1/2018 lip gloss 4/10/2018 foundation Units Dollars 45 $137.20 50 $152.01 3/25/2019 lipstick 3 Ashley 4 Hallagan 6/22/2020 lip gloss 55 $167.08 9 $ 28.72 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 7/17/2018 lip gloss 12/27/2019 eye liner 4/21/2018 eye liner 1/17/2021 lip gloss 8/5/2020 eye liner 43 $130.60 58 $175.99 8 $ 25.80 72 $217.84 75 $226.64 9/7/2020 lip gloss 24 $ 73.50 12/29/2018 mascara 43 $130.84 12 Ashley 12/18/2018 lip gloss 23 $ 71.03 13 Emilee 10/1/2019 lip gloss 49 $149.59 14 Hallagan 2/1/2019 eye liner 18 $ 56.47 15 Zaret 10/20/2020 foundation -8 $ (21.99) 16 Emilee 17 Colleen 18 Jen 5/12/2018 mascara 45 $137.39 5/30/2020 mascara 66 $199.65 10/1/2019 lip gloss 88 $265.19 19 Jen 20 Zaret 11/27/2018 eye liner 12/27/2019 lip gloss 78 $236.15 57 $173.12
Expert Answer:
Answer rating: 100% (QA)
The image you sent is a spreadsheet containing a list of transactions It includes columns for Transa... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Please show work in excel formulas, thank you! A1 2 4 5 6 7 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. A B C D...
-
Cabana Cruise Line offers cruise ship service to various tropical locations throughout the globe. The company is considering the addition of a new cruise ship to its fleet in order to expand service...
-
Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal to 15%. Standard deviation of stock X and Y are 19% and 27%,...
-
Calculate e y for the following values of y: (a) y = 1 (b) y = 5 (c) y = -.5 (d) y = -2.5 (e) y = 3.1 (f) y = - I (g) y = .05 (h) y = .32 (i) y = 6.1 (j) y = -5.4
-
A national grocers magazine reports the typical shopper spends 8 minutes in line waiting to check out. A sample of 24 shoppers at the local Farmer Jacks showed a mean of 7.5 minutes with a standard...
-
A piston, mp = 10 lbm, is fitted in a cylinder, A = 2.5 in.2, that contains a gas. The setup is in a centrifuge that creates an acceleration of 75 ft/s2. Assuming standard atmospheric pressure...
-
Identify the four components of an ecosystem. After you do this try to visualize the interactions of these four components of an ecosystem as illustrated by Figure 2. 2 in the textbook. Does this...
-
Sally has an online poster business. Suppose Sally expects to sell 1,500 posters. Her average sales price per poster is $ 45 and her average cost per poster is $ 25. Her fixed expenses total $...
-
What do you mean by Hardware Software Interface? Give a concrete example. Define the two principle integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
-
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years...
-
Create a three to five minute persuasive decision briefing based on the following situation and scenario. Situation : You have asked your boss for some time with one of the senior executives...
-
What is the Huffman coding algorithm used for? Specifying the basic principles of the algorithm, Explain in detail on a small example.
-
Find the slope of the tangent line at x = 4 for the function 1 f(x) = 2x + = x 4
-
3. A tire starts from rest and rolls without slipping downhill at a constant acceleration of 13.6 m/s. The diameter of the tire is 170 cm. (a) Find the angular acceleration of the tire. (b) How long...
-
What is the difference between the DNS local name server and the DNS authoritative name server?
-
What is output of "sh ip bgp sum" command? Explain your answer with an output sample from a network running BGP and analyse the output elements.
-
During its first year of operations, the Martin Company paid $4,000 for direct materials and $8,500 for production worker wages. Lease and utility payments for the production facility totaled $7,500,...
-
Derive Eq. (18.33) from Eq. (18.32).
-
Robert Ramos (age 36) is a single taxpayer, living at 8765 Bay Dr., Monterey, CA 93940. His Social Security number is 976-23-5132. Robert's earnings and income tax withholding as the manager of a...
-
How are qualified dividends taxed in 2012? Please give the two rates of tax which apply to qualified dividends, and specify when each of these rates applies._________________________...
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
In recent years, Keflavik Paper Company has been having problems with its project management process. Several commercial projects, for example, have come in late and well over budget, and product...
-
Your firm has the opportunity to invest $75,000 in a new project opportunity but due to cash flow concerns, your boss wants to know when you can pay back the original investment. Using the discounted...
-
Pracht, a popular cosmetics company in Germany, has been performing favorably and growing at a constant rate, with profits exceeding $900,000 in the last financial year. The company now wants to...
Study smarter with the SolutionInn App