2. Move ranges B15:L30 to C15:M30 (All the cells should shift to the right). In the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Move ranges B15:L30 to C15:M30 (All the cells should shift to the right). In the range B17:B29, insert a Sparkline for the range of cells C17:F29. 3. In the range C17:F29, insert Conditional formatting such as Data Bars, Color Scales, or Icon Sets (This will show up as well as the number). You only have to choose one. 4. On the bottom of row 2, insert a thick bottom border for the range A2:M2. After that there should be a blank row (row 3) in between your border and the PLS 21 Title. 5. Apply all borders to the range A15:M29 (Don't include diagonal borders across every cell). Apply a thick box border around the outside of the range C30:G30. 6. Apply dollar signs to the range C17:J29. 7. Next to where it says "Comments" on row 32, place bottom borders on ranges B32:G32 and B33:G33. 1 Format your spreadsheet to have landscape orientation and set it to fit to: page wide by 2 pages tall. (Your data should end up on the first page and your chart on the second). 8. T 2 3 HHORNOVA AutoSave OFF 今日 Home 82 Paste 10 11 Sales 40 1995 12 Bonus 13 14 242522338 15 16 Employee 17 Gabrielle 18 Michell 19 Kyle 20 Courtney 21 Julana 22 Paul 23 Bella 24 Lyuan 25 Caleb 25 Jenny 27 Amy 28 Conor 29 Aedric Commission & 3000 400 40.00 10:00 Base Salary Commission A 20:00 10:00 0.00 Insert Draw Page Layout Edit 16 Shipping UC Devis Address x ✔ fx B Open Sans BTU. Sheds Ave Davis, CA 95816 335 10% First 26.93 22.18 42.00 7,14 C D 36.06 38.29 14.87 15.98 # Report E Gebe vanil Fyk Quarterly Sales (in thousands) Total Second Third Fourth Sales 14.23 4.12 8.22 18.34 32.54 7.50 + V V 10 F 11.23 30.50 29.81 11.50 12.87 18.04 15.24 28.41 15.00 20.12 79.67 32.12 22.10 29.41 26.52 21.12 20.65 32.48 53.87 33.33 9.50 119.69 106.50 134.56 56.45 33.12 121,82 45.02 57.34 40.21 23.56 160.13 13.00 33.59 48.20 10.40 40.24 5.99 9.85 22.67 PLS 21 Average Total Sales 12.47 18.50 26.67 38.52 23.51 30 350 $75 $100 $125 $150 $1.00 $5.00 16.50 $8.00 $10.00 $12.50 Gurtny Ala - 53.50 80.56 113.57 49.55 Formulas Y M U.C. Davis G A A Pad A PLS 21 Associate Sales Employees Report V Salary Bonus 47.19 5 53.74 6.5 38.52 8 47.54 1 42.22 6.5 52.168 37.29 8 53.11 10 37.46 5 48 22 8 53 25 12.5 105.19 60.11 8 78.75 29.90 6.5 $97.39 H Commision Data Review View Employee Quartely Sales Uy EE Total Date Salary Hired 52.19 60.24 46.52 48.54 48.72 60.16 45.29 63.11 42.46 56.22 65.75 68.11 36.49 -SondThat Fauth 直接 Cale Years WiFvm 28-Jan-17 3.82 27-May-07 23.50 2-Jul-05 15.40 6-May-01 19.55 14-Aug-19 1.27 18-Aug-02 18.27 23-May-09 11.51 24-Dec-12 7.91 29-Jun-07 13.41 29-Oct-12 8.07 19-Mar-11 9.68 7-Nov-88 32.06 20-Apr-94 26.61 Any Training Required? yes yes No yes ves No No No yos No No No yes 2 Wrap Text A Tell me Comer Merge & Center M Adric N 2. Move ranges B15:L30 to C15:M30 (All the cells should shift to the right). In the range B17:B29, insert a Sparkline for the range of cells C17:F29. 3. In the range C17:F29, insert Conditional formatting such as Data Bars, Color Scales, or Icon Sets (This will show up as well as the number). You only have to choose one. 4. On the bottom of row 2, insert a thick bottom border for the range A2:M2. After that there should be a blank row (row 3) in between your border and the PLS 21 Title. 5. Apply all borders to the range A15:M29 (Don't include diagonal borders across every cell). Apply a thick box border around the outside of the range C30:G30. 6. Apply dollar signs to the range C17:J29. 7. Next to where it says "Comments" on row 32, place bottom borders on ranges B32:G32 and B33:G33. 1 Format your spreadsheet to have landscape orientation and set it to fit to: page wide by 2 pages tall. (Your data should end up on the first page and your chart on the second). 8. T 2 3 HHORNOVA AutoSave OFF 今日 Home 82 Paste 10 11 Sales 40 1995 12 Bonus 13 14 242522338 15 16 Employee 17 Gabrielle 18 Michell 19 Kyle 20 Courtney 21 Julana 22 Paul 23 Bella 24 Lyuan 25 Caleb 25 Jenny 27 Amy 28 Conor 29 Aedric Commission & 3000 400 40.00 10:00 Base Salary Commission A 20:00 10:00 0.00 Insert Draw Page Layout Edit 16 Shipping UC Devis Address x ✔ fx B Open Sans BTU. Sheds Ave Davis, CA 95816 335 10% First 26.93 22.18 42.00 7,14 C D 36.06 38.29 14.87 15.98 # Report E Gebe vanil Fyk Quarterly Sales (in thousands) Total Second Third Fourth Sales 14.23 4.12 8.22 18.34 32.54 7.50 + V V 10 F 11.23 30.50 29.81 11.50 12.87 18.04 15.24 28.41 15.00 20.12 79.67 32.12 22.10 29.41 26.52 21.12 20.65 32.48 53.87 33.33 9.50 119.69 106.50 134.56 56.45 33.12 121,82 45.02 57.34 40.21 23.56 160.13 13.00 33.59 48.20 10.40 40.24 5.99 9.85 22.67 PLS 21 Average Total Sales 12.47 18.50 26.67 38.52 23.51 30 350 $75 $100 $125 $150 $1.00 $5.00 16.50 $8.00 $10.00 $12.50 Gurtny Ala - 53.50 80.56 113.57 49.55 Formulas Y M U.C. Davis G A A Pad A PLS 21 Associate Sales Employees Report V Salary Bonus 47.19 5 53.74 6.5 38.52 8 47.54 1 42.22 6.5 52.168 37.29 8 53.11 10 37.46 5 48 22 8 53 25 12.5 105.19 60.11 8 78.75 29.90 6.5 $97.39 H Commision Data Review View Employee Quartely Sales Uy EE Total Date Salary Hired 52.19 60.24 46.52 48.54 48.72 60.16 45.29 63.11 42.46 56.22 65.75 68.11 36.49 -SondThat Fauth 直接 Cale Years WiFvm 28-Jan-17 3.82 27-May-07 23.50 2-Jul-05 15.40 6-May-01 19.55 14-Aug-19 1.27 18-Aug-02 18.27 23-May-09 11.51 24-Dec-12 7.91 29-Jun-07 13.41 29-Oct-12 8.07 19-Mar-11 9.68 7-Nov-88 32.06 20-Apr-94 26.61 Any Training Required? yes yes No yes ves No No No yos No No No yes 2 Wrap Text A Tell me Comer Merge & Center M Adric N
Expert Answer:
Answer rating: 100% (QA)
To move the ranges B15L30 to C15M30 and shift all the cells to the right you can follow these steps ... View the full answer
Related Book For
Probability and Random Processes With Applications to Signal Processing and Communications
ISBN: 978-0123869814
2nd edition
Authors: Scott Miller, Donald Childers
Posted Date:
Students also viewed these electrical engineering questions
-
A pot of steel, conductivity 50 W/m K, with a 5 mm thick bottom is filled with 15C liquid water. The pot has a diameter of 20 cm and is now placed on an electric stove that delivers 250 W as...
-
You want to choose between decision alternatives A1 and A2 in the following decision tree, but you are uncertain about the value of the probability p, so you need to perform sensitivity analysis of p...
-
3 / 8t = 5 / 6 t 1 / 4
-
The average of 4 consecutive odd positive integers is 16. The product of the smallest and largest positive odd integer is 1. 210 2. 247 3. 294 4. 320 None of the above 5.
-
Suppose two firms want to borrow money from a bank for a period of one year. Firm A has excellent credit, whereas Firm Bs credit standing is such that it would pay prime + 2 percent. The current...
-
An architect wants to determine the relationship between the heights (in feet) of a building and the number of stories in the building. The data for a sample of 10 buildings in Pittsburgh are shown....
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Cash flow from mmm operations was \($645,590\) for 2008 and \($795,823\) for...
-
During the first month of operations ended May 31, 2014, Ice Cold Fridge Company manufactured 17,500 dormitory refrigerators, of which 16,380 were sold. Operating data for the month are summarized as...
-
stock market and treasury bill. returns for 5 yr period stock market return % t bill return and % 2013 34.60 0.17 2014 14.30 0.17 2015 -4.20 0.17 2017 15.60 0.04 2017 24.70 0.06 what was the risk...
-
Yolanda has the option of investing in two different mutual funds. The return in the random walk fund tends to fluctuate wildly, earning substantial positive returns one year only to realize negative...
-
A rectangular bar with central hole is shown below. The bar is made from AISI 3140 annealed. The bar has a height H=8 cm and thickness of 2 cm. The hole has a radius, r = 2.5 cm. For a load, F = 50...
-
Scribners Corporation produces fine papers in three production departmentsPulping, Drying, and Finishing. In the Pulping Department, raw materials such as wood fiber and rag cotton are mechanically...
-
A car of mass 972 kg is traveling 20.4 m/s when the driver applies the brakes, which lock the wheels. The car skids for 4.27 s in the positive x-direction before coming to rest. HINT (a) What is the...
-
Saturated steam is produced in a steam boiler at a pressure of 1 5 bar and a flow rate of 1 0 tons / h . Water enters the steam boiler as compressed water at 1 0 5 \ deg C . a - ) What is the heat...
-
3. Techron I costs $290,000, has a 3 year life and operating cash flows of -$50,000 per year. If the discount rate is 10%, what is the Equivalent Annual Cost? Capital Investment In-Class Exercise...
-
A boy exerts a horizontal force of 137 N on a crate with a mass of 36.2 kg. HINT (a) If the crate doesn't move, what's the magnitude of the static friction force (in N)? N (b) What is the minimum...
-
Do you feel that a client with a sexual dysfunction disorder would respond to therapy differently than a person with a paraphilic disorder? What are unique issues related to treating each disorder?
-
A copper wire (density = 8.96 g/cm 3 ) has a diameter of 0.25 mm. If a sample of this copper wire has a mass of 22 g, how long is the wire?
-
In a certain communication system, bits are encoded into blocks of length 128 bits. Error correction techniques are used such that the block will be decoded correctly as long as no more than 7 of the...
-
Consider again the random variables of exercise 5.12 that are uniformly distributed over an ellipse. (a) Find the conditional PDFs, fX|Y (x| y) and fY|X (y|x). (b) Find f X|Y > 1(x). (c) Find fY...
-
Suppose a random variable has some PDF given by fX(x). Find a function g(x) such that Y= g(X) is a uniform random variable over the interval (0, 1). Next, suppose that X is a uniform random variable....
-
9. INVESTIGATION Agencies have broad investigatory powers and may use subpoenas and, in some cases, warrantless searches to obtain information. (pp. 92-94)
-
1. ETHICS Suppose you were on a state supreme court and faced with a restaurant- choking case. Should you require restaurant employees to know and employ the Heimlich maneuver to assist a choking...
-
Question: When Hiller Systems, Inc., was performing a safety inspection on board the M/V Cape Diamond, an ocean-going vessel, an accident killed two men. The Occupational Safety and Health...
Study smarter with the SolutionInn App