For our drug cost example (see the file named Offsetcost.xlsx from Chapter 22, The OFFSET function,), format
Question:
For our drug cost example (see the file named Offsetcost.xlsx from Chapter 22, “The OFFSET function,”), format the worksheet so that all Phase 1 costs are displayed in red, all Phase 2 costs are displayed in green, and all Phase 3 costs are displayed in purple.
Transcribed Image Text:
123456700 o 8 9 Code 10 11 12 13 14 15 16 17 B 18 19 20 21 22 1 23456700 a 8 9 10 11 12 13 C Dur Phase 1 Dur Phase 2 Dur Phase 3 Phase 1 Cost Phase 2 Cost Phase 3 Cost Month Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 D 222 110 142 234 Drug 1 52 58 80 62 130 104 121 107 80 51 74 76 97 E 38 11 313 789 876 Drug 2 135 120 58 56 126 102 59 123 88 111 124 107 97 F 954 795 465 401 Drug 3 131 77 66 78 98 64 115 56 110 72 82 99 129 G 12 4 11 1167 397 1135 Drug 4 121 60 52 61 118 117 112 102 85 118 143 78 77 H 6 12 15 615 1096 1588 Drug 5 69 68 113 146 123788887 94 93 89 66 66
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (5 reviews)
The procedures below can be used to style the worksheet so that Phase 1 expenses are shown in red ...View the full answer
Answered By
Aketch Cindy Sunday
I am a certified tutor with over two years of experience tutoring . I have a passion for helping students learn and grow, and I firmly believe that every student has the potential to be successful. I have a wide range of experience working with students of all ages and abilities, and I am confident that I can help students succeed in school.
I have experience working with students who have a wide range of abilities. I have also worked with gifted and talented students, and I am familiar with a variety of enrichment and acceleration strategies.
I am a patient and supportive tutor who is dedicated to helping my students reach their full potential. Thank you for your time and consideration.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
Kyrsten Haas expects an S corporation investment to generate a profit of $200,000. Her share of the S corporation is 15%. What is Kyrstens income tax if no cash is distributed? Kyrsten's marginal tax...
-
How do the sources of risk of misstatement listed help the auditor plan the audit?
-
Cone Corporation is in the process of preparing its December 31, 2018, balance sheet. There are some questions as to the proper classification of the following items: a. $50,000 in cash restricted in...
-
Determine the number of ideal stages required in Example 7.4 if the solvent rate used is twice the minimum. Data From Example 7.4:- A solution of acetic acid (C) in water (A) is to be extracted using...
-
Grunewald Industries sells on terms of 2/10, net 40. Gross sales last year were $4,562,500, and accounts receivable averaged $437,500. Half of Grunewalds customers paid on the 10th day and took...
-
A certain low-loss non-magnetic dielectric material has a relative permittivity (er) of 2.5 and a loss tangent of 0.004. What is the phase constant b of a plane wave of frequency 11.3 GHz?
-
a. Draw the hierarchy chart and design the logic for a program needed by the manager of the Stengel County softball team, who wants to compute slugging percentages for his players. A slugging...
-
The file Names.xlsx contains a list of names. Highlight all the duplicates in green and all the names containing Ja in red. Name Manager New.... Name jam jam sales Edit... Value {"4":"5","6"}...
-
Using the data in the file named Sandp.xlsx, use conditional formatting in the following situations: Format in bold each month in which the value of the S&P index increased, and format with an...
-
The maximum magnification of a simple magnifier occurs with the image at the 25-cm near point. Show that the angular magnification is m = 1 + (25 cm/f), where f is the focal length.
-
Identify a successful entrepreneur that you admire and respect. (It can be someone that is nationally prominent or someone you know personally, such as a family member or a friend.) Briefly describe...
-
Alvarado Apps, Inc. owned real and tangible personal property valued at $3,000,000 at the beginning of the year and $3,400,000 at the end of the year. It also leased real property for $100,000. In...
-
Ethylene (C2H4) at 100C and 1 bar passes through a heater and emerges at 200C. Calculate the change in exthalpy per mole of ethylene that passes through. You may assume ideal gas behavior. The...
-
Burgess Fabricators, Inc. did business in and is subject to the tax of State 1 and State 2, where it had its commercial domicile. It had the following nonbusiness income for the year: $15,000 in net...
-
Make a list of 10 prominent entrepreneurs who are women, minorities, or seniors (55 years or older when their firms were started). Single out one of these entrepreneurs and provide a brief overview...
-
Cripple Creek Company has one trusted employee, who, as the owner said, handles all of the bookkeeping and paperwork for the company. This employee is responsible for counting, verifying, and...
-
CRUZ, INC. Comparative Balance Sheets December 31, 2015 CRUZ, INC. Income Statement For Year Ended December 31, 2015 Required Use the indirect method to prepare the cash provided or used from...
-
Read The Impact of Capacity-Building Programs on Nonprofits:A Random Assignment Evaluation. What five critical areas did the federal governments Compassion Capital Fund (CCF) Demonstration Program...
-
Read The Impact of Capacity-Building Programs on Nonprofits: A Random Assignment Evaluation. What were the results of the Impact Evaluation performed by the authors to assess capacity?
-
In deciding whether to recognize the tax-exempt status of a new nonprofit, should the Internal Revenue Service consider whether or not it will duplicate the services of other, existing organizations...
-
You buy a package of 500 sheets of bond paper, in size 18 x 24 inches. The label says it is 50M 18 x 24. What is the grammage? Select the closest answer.
-
Produce a persuasive report for a company of your choice, with arguments for why they should produce a sustainability report. You will be expected to Prepare a 2500 words persuasive report addressed...
-
Discussion Board: Think Like A Nurse . ANSWER Discussion Prompts WITH APACITATION As you begin your nursing profession journey, is there a patient problem or healthcare concern you would like to see...
Study smarter with the SolutionInn App