In cell W15: Use the appropriate nested functions: If the employee's Year of Hire is 1974...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In cell W15: Use the appropriate nested functions: If the employee's Year of Hire is 1974 or 1977 or 1987, and the Region is RG2 or RG4, and the Gender is Male, multiply the Annual Units Sold by the price in cell N2, otherwise enter a 0 in the cell. (Use absolute cell referencing where necessary). Copy the function down to the other cells in the column. In W10 use the appropriate function to calculate the total for all the employees. Format comma style 0 decimal. 1 3 4 5 6 7 8 9 10 11 123 B C D E F G H J K L M N Management Annual Units Bonus Rating Bonus Bonus Award? Comment Sold Rate 1 Review Needed 100 0 270 No Award 2 Monitor 200 16,500 950 Certificate 0.75% 1.50% $ 3,950 $ 18.00 $ 4,650 3 Fair 500 18,000 1,400 Bronze 3.25% $ 5,100 4 Good 750 5 Excellent 1,000 19,500 1,800 22,000 2,500 Gold Platinum 4.50% 6.00% $ 3,500 Q Department Supervisor 1202 Laing 1211 Zheng 1225 Ahmed 1237 Enkomo 1249 Da Silva 1255 Borrows Answers Units Sold Units Sold Units Sold Units Sold Employee ID Last Name First Name Region Department Job Title Rating Year of Hire Age Salary Gender 15600022222222222 14 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Annual Units Sold 10014766 Miller Geof RG3 1225 Junior Sales Rep 2 1998 61 $ 32,118 M 3,229 3,499 3,884 4,973 15,585 11134120 Lee Mark RG2 1237 Manager 4 1989 59 $ 136,465 M 5,683 5,693 5,113 4,506 20,995 17 10062555 Morgan Louise RG3 1237 Advisor 4 1990 65 $ 86,624 F 4,011 4,109 4,491 5,641 18,252 18 10752656 Ralls Kim RG1 1211 Sales Rep 5 1997 52 $ 50,657 F 5,460 5,495 4,854 3,965 19,774 19 10008446 Matey Michael RG1 1211 Junior Sales Rep 1 1991 53 $ 34,572 M 3,601 3,643 3,450 5,397 16,091 11064518 Young Jonathan RG1 1249 Manager 5 1988 58 $ 97,983 M 5,140 5,194 4,469 4,888 19,691 12371307 Alboucq Steve RG3 1211 Junior Sales Rep 1 1992 50 $ 34,706 M 3,940 4,213 4,557 5,781 18,491 11681945 Tratt Adam RG3 1202 Manager 3 1987 66 $ 126,164 M 3,852 3,864 6,052 6,534 20,302 23 10966149 Matthews Joseph RG3 1225 Junior Sales Rep 3 1990 46 $ 37,294 M 5,786 5,984 5,865 5,315 22,950 24 10763212 Dunn Micheal RG2 1225 Junior Sales Rep 1 1999 62 $ 35,401 M 5,851 6,059 4,261 6,554 22,725 11922536 Groncki Douglas RG4 1249 Junior Sales Rep 1 1986 55 $ 36,323 M 5,370 5,535 4,785 4,180 19,870 10952776 Hohman Bob RG1 1202 Junior Sales Rep 3 1993 66 $ 33,816 M 4,124 4,145 5,855 6,564 20,688 27 11235308 Vernhes Laurent RG4 1255 Sales Rep 5 1985 53 $ 44,760 M 3,668 3,682 5,551 5,641 18,542 28 11646365 Bradley David M RG2 1255 Sales Rep 3 1984 63 $ 74,578 M 4,546 4,582 5,704 5,897 20,729 29 12103860 Tiano Mike RG3 1237 Sales Rep 4 1986 59 $ 54,040 M 5,311 5,311 5,794 5,924 22,340 30 10891724 Henshaw Jeff RG4 1237 Junior Sales Rep 2 1999 65 $ 37,745 M 4,711 4,895 6,060 5,529 21,195 31 12075206 Poland Carole RG4 1237 Junior Sales Rep 4 1996 43 $ 34,211 F 4,877 4,933 5,848 4,943 20,601 32 11019095 Pardi William RG3 1255 Sales Rep 3 1981 66 $ 44,256 M 4,427 4,427 4,397 6,459 19,710 In cell W15: Use the appropriate nested functions: If the employee's Year of Hire is 1974 or 1977 or 1987, and the Region is RG2 or RG4, and the Gender is Male, multiply the Annual Units Sold by the price in cell N2, otherwise enter a 0 in the cell. (Use absolute cell referencing where necessary). Copy the function down to the other cells in the column. In W10 use the appropriate function to calculate the total for all the employees. Format comma style 0 decimal. 1 3 4 5 6 7 8 9 10 11 123 B C D E F G H J K L M N Management Annual Units Bonus Rating Bonus Bonus Award? Comment Sold Rate 1 Review Needed 100 0 270 No Award 2 Monitor 200 16,500 950 Certificate 0.75% 1.50% $ 3,950 $ 18.00 $ 4,650 3 Fair 500 18,000 1,400 Bronze 3.25% $ 5,100 4 Good 750 5 Excellent 1,000 19,500 1,800 22,000 2,500 Gold Platinum 4.50% 6.00% $ 3,500 Q Department Supervisor 1202 Laing 1211 Zheng 1225 Ahmed 1237 Enkomo 1249 Da Silva 1255 Borrows Answers Units Sold Units Sold Units Sold Units Sold Employee ID Last Name First Name Region Department Job Title Rating Year of Hire Age Salary Gender 15600022222222222 14 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Annual Units Sold 10014766 Miller Geof RG3 1225 Junior Sales Rep 2 1998 61 $ 32,118 M 3,229 3,499 3,884 4,973 15,585 11134120 Lee Mark RG2 1237 Manager 4 1989 59 $ 136,465 M 5,683 5,693 5,113 4,506 20,995 17 10062555 Morgan Louise RG3 1237 Advisor 4 1990 65 $ 86,624 F 4,011 4,109 4,491 5,641 18,252 18 10752656 Ralls Kim RG1 1211 Sales Rep 5 1997 52 $ 50,657 F 5,460 5,495 4,854 3,965 19,774 19 10008446 Matey Michael RG1 1211 Junior Sales Rep 1 1991 53 $ 34,572 M 3,601 3,643 3,450 5,397 16,091 11064518 Young Jonathan RG1 1249 Manager 5 1988 58 $ 97,983 M 5,140 5,194 4,469 4,888 19,691 12371307 Alboucq Steve RG3 1211 Junior Sales Rep 1 1992 50 $ 34,706 M 3,940 4,213 4,557 5,781 18,491 11681945 Tratt Adam RG3 1202 Manager 3 1987 66 $ 126,164 M 3,852 3,864 6,052 6,534 20,302 23 10966149 Matthews Joseph RG3 1225 Junior Sales Rep 3 1990 46 $ 37,294 M 5,786 5,984 5,865 5,315 22,950 24 10763212 Dunn Micheal RG2 1225 Junior Sales Rep 1 1999 62 $ 35,401 M 5,851 6,059 4,261 6,554 22,725 11922536 Groncki Douglas RG4 1249 Junior Sales Rep 1 1986 55 $ 36,323 M 5,370 5,535 4,785 4,180 19,870 10952776 Hohman Bob RG1 1202 Junior Sales Rep 3 1993 66 $ 33,816 M 4,124 4,145 5,855 6,564 20,688 27 11235308 Vernhes Laurent RG4 1255 Sales Rep 5 1985 53 $ 44,760 M 3,668 3,682 5,551 5,641 18,542 28 11646365 Bradley David M RG2 1255 Sales Rep 3 1984 63 $ 74,578 M 4,546 4,582 5,704 5,897 20,729 29 12103860 Tiano Mike RG3 1237 Sales Rep 4 1986 59 $ 54,040 M 5,311 5,311 5,794 5,924 22,340 30 10891724 Henshaw Jeff RG4 1237 Junior Sales Rep 2 1999 65 $ 37,745 M 4,711 4,895 6,060 5,529 21,195 31 12075206 Poland Carole RG4 1237 Junior Sales Rep 4 1996 43 $ 34,211 F 4,877 4,933 5,848 4,943 20,601 32 11019095 Pardi William RG3 1255 Sales Rep 3 1981 66 $ 44,256 M 4,427 4,427 4,397 6,459 19,710
Expert Answer:
Related Book For
Complete Business Statistics
ISBN: 9780077239695
7th Edition
Authors: Amir Aczel, Jayavel Sounderpandian
Posted Date:
Students also viewed these general management questions
-
Excel file link https://docs.google.com/spreadsheets/d/1zUuJBGgAhXcpHMb9_lmq1VPD-XCx6UJK/edit?usp=drive_link&ouid=106020471773606203483&rtpof=true&sd=true 1,In cell N14 , enter a function to...
-
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...
-
First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Instructions 1. Assuming...
-
Jayhawk Company reports current E&P of $300,000 and accumulated E&P of negative $200,000. Jayhawk distributed $400,000 to its sole shareholder, Christine Rock, on the last day of the year....
-
Imagine you are seeking information on a new car that you are thinking of buying. Determine the level of trust that you would place in information provided by the following sources: a salesman at the...
-
For the chemical reaction \[ \mathrm{N}_{2} \mathrm{O} ightarrow \mathrm{N}_{2}+\frac{1}{2} \mathrm{O}_{2} \] \(\Delta H=-20000\) cal and \(\Delta S=18\) e.u. Will the reaction be spontaneous at...
-
Woolrich Companys market research division has projected a substantial increase in demand over the next several years for one of the companys products. To meet this demand, the company will need to...
-
How do individual differences in personality traits, such as the Big Five factors, affect team cohesion, communication patterns, and overall organizational effectiveness ?
-
A wind turbine is required to provide an average electrical power output of 10 kW in a rural location, where the annual average wind speed at the standard height of 10m is 5.5 m/s. Estimate the...
-
How did you discover your Individual identity from your collective identity 1: List and 5 main elements an organization needs in order to create a company culture that promotes Diversity, Equity and...
-
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales $ 25,000 Variable...
-
A manufacturer reports the information below for three recent years. Variable costing income Beginning finished goods inventory (units) Ending finished goods inventory (units) Year 1 $ 113,000 0...
-
Crane Manufacturing s sales decreased significantly in 2 0 2 1 due to increased online purchasing. The company s income statement showed the following results from selling 4 1 0 , 0 0 0 units of...
-
E8-16A. Identify asset impairment (Learning Objective 8) 10-15 min. Mistry Ltd. has four assets. You are an accounting assistant who is in charge of identifying the recoverable amount and determining...
-
Below are examples of strategies for accommodating specific modal strengths in physical education, as offered by Reed, Banks, and Carlisle (2004). Determine which modal preference (visual,...
-
6. (Potential Energy and Conservation of Energy) What should be the spring constant k of a spring designed to bring a 1200-kg car to rest from a speed of 95 km/h so that the occupants undergo a...
-
The Consumer Price Index (CPI) is an important indicator of the general level of prices of essential commodities. It is widely used in making cost of living adjustments to salaries, for example. 1....
-
Identify each of the variables with one factor only. Also find the communality of each variable. Factor1 Market Penetration Issues 0.331 Factor 2 Project Quality Issues 0.626 0.242 0.101 0.126...
-
Use the probability distribution to find the expected number of shipment orders per day. What is the probability that on a given day there will be more orders than the average? X P(x) 0 ..... 0.1 1...
-
The \(x\) component of a car's velocity increases from 0 to \(+5.0 \mathrm{~m} / \mathrm{s}\) in \(1.0 \mathrm{~s}\), and then from \(+5.0 \mathrm{~m} / \mathrm{s}\) to \(+10 \mathrm{~m} /...
-
Describe how to determine the \(x\) component of the position of an object at a specific instant, given (a) a graph of position \(x\) as a function of time \(t\) and (b) an equation for \(x(t)\).
-
In an \(x(t)\) curve, what is the significance of a steep slope as opposed to a gentle slope? What is the significance of a curve that slopes downward as you move from left to right along the time...
Study smarter with the SolutionInn App