Using Figure G.2, analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to ensure
Question:
Using Figure G.2, analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to ensure that all the suppliers have different supplier numbers in column B. Which Conditional Formatting ‘Rule Type’ should she select?
Figure G.2
Transcribed Image Text:
A B 1 Thompson Industries Monthly Supplier Report - April 2 3 4 5 Supplier Name 6 Maverick Supplies 7 Cowboy Pete's Lumber 8 ABC Metals 9 Perkins Plastics 10 Everything Brass 11 Jones Aluminum & Copper 12 Rick's Wrought Iron 13 Penelope's Paper Products 14 Anthony's Adhesives 15 Columbus Manufacturing 16 Smart Electronics, Inc. 17 Watson Woodworking 18 Fred's Foam Molding 19 Impenetrable Insulation, Inc. 20 Suzy's Shipping Supplies Supplier Supplier Category Number 6071 6894 5054 5528 4413 5858 9733 4718 9944 1343 4785 2730 2949 1443 8039 Total (P,S) Purchases P P S P P P S P S P D S P P $39,117 $25,554 $13,051 $27,886 $29,300 $16,862 $29,078 $25,716 $22,750 $20,103 $30,062 $32,589 $47,886 $24,971 $23,851 E Change from Previous Month $5,000 $400 $13,051 $32,564 ($4,658) $16,862 ($3,121) $8,795 $1,268 $469 $30,062 $471 $47,886 ($6,895) $1,269 F Quality On-time Rating (1-5) Percentage 100% 90% 0% 100% 1000% 50% 60% 100% 90% 100% 5 5 3 4 5 4 1 3 4 4 5 5 5 4 5 33% 25% 100% 15% 50% H No. of Percentage Rejected Returns Shipments 0% 0 0% 75% 3% 0% 5% 80% 12% 0% 50% 1% 0.50% 4% 0% 0 2 0 0 1 6 0 0 0 0 0 0 0 0 New Supplier (Y, N) N N Y N N Y N N N N Y N Y N N
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 75% (8 reviews)
Vicky Luo should select the Duplicate Values rule type in Conditional Formatting to ensure th...View the full answer
Answered By
Chandrasekhar Karri
I have tutored students in accounting at the high school and college levels. I have developed strong teaching methods, which allow me to effectively explain complex accounting concepts to students. Additionally, I am committed to helping students reach their academic goals and providing them with the necessary tools to succeed.
0.00
0 Reviews
10+ Question Solved
Related Book For
Operations Management Sustainability And Supply Chain Management
ISBN: 9780137476442
14th Edition
Authors: Jay Heizer, Barry Render, Chuck Munson
Question Posted:
Students also viewed these Business questions
-
Using Figure G.2, enter $6,000 into cell E8. In that spreadsheet, any new supplier (with a Y in column J) should have its total purchases in column D equal to its change from the previous month in...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Audrey has recently purchased a home with a $325,000 mortgage. She opted for monthly payments, a term of 5 years at a rate of 3.2%, and an amortization period of 25 years. Had Audrey chosen, instead,...
-
A food-products company has recently introduced a new line of fruit pies in six U.S. cities: Atlanta, Baltimore, Chicago, Denver, St. Louis, and Fort Lauderdale. Based on the pies apparent success,...
-
Prove the first part of Theorem 3.7. That is let \(\left\{X_{n}ight\}_{n=1}^{\infty}\) be a sequence of random variables, \(c\) be a real constant, and \(g\) be a Borel function on \(\mathbb{R}\)...
-
Bonds with the same coupon but shorter terms to maturity have __________ price volatility when interest rates change.
-
Suppose an economy open to international capital movements has a crawling peg exchange rate under which its currency is pegged at each moment but is continuously devalued at a rate of 10 percent per...
-
If your average monthly remittance in the 2nd preceding year was $24,500 your remittance for amounts deducted on the January 14th pay is due on: a. January 14 b. April 15 c. January 25 d. February 15...
-
Consider Example G1. Think of three additional items for which the manager might want to check to ensure that the data are clean. Example G1 A B 1 Thompson Industries Monthly Supplier Report - April...
-
For the RejShip column (I) in Figure G.5: a) Determine the upper and lower limits for a 3-standarddeviation accuracy check. b) Which, if any, values fall outside the limits computed in part (a)? A B...
-
Solve the differential equation with the given initial condition. dy = x dx -1/2, y(1) = 1
-
1. State the difference between lists and tuples in Python programming. 2. Explain why Python is an Interpreted Language
-
1. How does Python handle memory? 2. Python's ternary operators: how do they work? 3. How is Python's multithreading implemented
-
In a relational database, explain the difference between Inner join & Outer join. Provide an example query for each and describe the result set produced by each query.
-
Management accountants need a wide variety of skills for their roles in organizations. These skills can be classified as either technical or nontechnical. Requirement For each of the following...
-
The financial statements of Eastern Platinum Limited (Eastplats) are presented in Appendix A at the end of this textbook. Instructions (a) Does East plats report any investments on its statement of...
-
The Doan Modianos Manufacturing Company is putting out seven new electronic components. Each of Modianos eight plants has the capacity to add one more product to its current line of electronic parts....
-
A sales manager for a large construction equipment company has offices in four Saudi Arabia cities. As part of the monthly assignment, the manager wants a salesman from each office to fly and meet...
-
The exclusive Swink Golf Driving Range has had a standard price of $15 per hour. The facility has 36 golfing stations, with average usage of 50%, 10 hours a day, 7 days a week. Morgan Swink, the...
-
firm purchased a new piece of equipment with an estimated useful life of eight years. The cost of the equipment was $65,000. The salvage value was estimated to be $10,000 at the end of year 8. Using...
-
On an average day, a company writes checks totaling $1,500. These checks take 7 days to clear. The company receives checks totaling $1,800. These checks take 4 days to clear. The cost of debt is 9%....
-
Olds Company declares Chapter 7 bankruptcy. The following are the book values of the asset and liability accounts at that time. A bankruptcy expert estimates that administrative expense will total $...
Study smarter with the SolutionInn App