Explanation Given Information: The table provided below shows the amount of sales per week for a month, of different salesmen. Employee Name Week 1 Week 2 Week 3 Week 4 Units sold Brown, Tyler 15 12 23 27 Lopez, Cierra 23 18 14 12 Prete, Aaron 18 19 27 9 Salayon, steven 21 15 16 17 Vidrine, Stephen 31 12 9 15 Waddell, Dawn 17 18 12 21 Young, Travon 15 19 14 13 Step 1: Open MS excel and write the information provided in the table. Step 2: To calculate the units sold for each employee select each row one by one and select column from week1 to units sold. Step 3: Press formulas in the top of excel and then press AutoSum from the options. The units sold by an employee will be calculated. Step 4: Repeat the step 1 to 3 for each employee. Step 5: To calculate the overall sales select the units sold column and repeat step 4. The final table is shown below, Step 6: To determine the names whose units sold greater than 70, apply if statement as, IF(F2>70, A2) and then drag it to all the columns...

11th Edition

ISBN: 9780134496436

Author: Cheryl Cleaves, Margie Hobbs, Jeffrey Noble

Publisher: PEARSON

See similar textbooks

Videos

Question

Chapter 1, Problem 2CP

To determine

Whether sterns automotive has reached its overall sales quota of 500 units per month. Also determine the salespersons who reached the monthly sales goal of 70 units. Use the excel template and the provided table to solve.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 1, Problem 1CP

Chapter 1, Problem 1CS1

Students have asked these similar questions

PLEASE ANSWER ALL PARTS!!

The table below was compiled for a middle school from the 2003 English/Language Arts PACT exam. Grade 6 7 8 Below Basic 60 62 76 Basic 87 134 140 Proficient 87 102 100 Advanced 42 24 21 Partition the likelihood ratio test statistic into 6 independent 1 df components. What conclusions can you draw from these components?

ſe² 1 1- √ √² f³dx dy dz 1 xyz 2-f₁₁ √ √²(x + y + z)dy dx dz π 3 3- √ √ √³₂y sinz dx dy dz

Chapter 1 Solutions

Business Math (11th Edition)

Ch. 1.1 - Prob. 1-1SC Ch. 1.1 - Prob. 1-2SC Ch. 1.1 - Prob. 1-3SC Ch. 1.1 - Prob. 1-4SC Ch. 1.1 - Prob. 2-1SC Ch. 1.1 - Prob. 2-2SC Ch. 1.1 - Prob. 2-3SC Ch. 1.1 - Prob. 2-4SC Ch. 1.1 - Prob. 3-1SC Ch. 1.1 - Prob. 3-2SC

Ch. 1.1 - Prob. 3-3SC Ch. 1.1 - Prob. 3-4SC Ch. 1.1 - Prob. 3-5SC Ch. 1.1 - Prob. 3-6SC Ch. 1.1 - Prob. 4-1SC Ch. 1.1 - Prob. 4-2SC Ch. 1.1 - Prob. 4-3SC Ch. 1.1 - Prob. 4-4SC Ch. 1.1 - Prob. 1SE Ch. 1.1 - Prob. 2SE Ch. 1.1 - Prob. 3SE Ch. 1.1 - Prob. 4SE Ch. 1.1 - Prob. 5SE Ch. 1.1 - Prob. 6SE Ch. 1.1 - Prob. 7SE Ch. 1.1 - Prob. 8SE Ch. 1.1 - Prob. 9SE Ch. 1.1 - Prob. 10SE Ch. 1.1 - Prob. 11SE Ch. 1.1 - Prob. 12SE Ch. 1.1 - Prob. 13SE Ch. 1.1 - Prob. 14SE Ch. 1.1 - Prob. 15SE Ch. 1.1 - Prob. 16SE Ch. 1.1 - Prob. 17SE Ch. 1.1 - Prob. 18SE Ch. 1.1 - Prob. 19SE Ch. 1.1 - Prob. 20SE Ch. 1.1 - Prob. 21SE Ch. 1.1 - Prob. 22SE Ch. 1.1 - Prob. 23SE Ch. 1.1 - Prob. 24SE Ch. 1.1 - Prob. 25SE Ch. 1.1 - Prob. 26SE Ch. 1.2 - Prob. 1-1SC Ch. 1.2 - Prob. 1-2SC Ch. 1.2 - Prob. 1-3SC Ch. 1.2 - Prob. 1-4SC Ch. 1.2 - Prob. 1-5SC Ch. 1.2 - Prob. 1-6SC Ch. 1.2 - Prob. 1-7SC Ch. 1.2 - Prob. 1-8SC Ch. 1.2 - Prob. 1-9SC Ch. 1.2 - Prob. 1-10SC Ch. 1.2 - Prob. 1-11SC Ch. 1.2 - Prob. 1-12SC Ch. 1.2 - Prob. 2-1SC Ch. 1.2 - Prob. 2-2SC Ch. 1.2 - Prob. 2-3SC Ch. 1.2 - Prob. 2-4SC Ch. 1.2 - Prob. 2-5SC Ch. 1.2 - Prob. 2-6SC Ch. 1.2 - Prob. 3-1SC Ch. 1.2 - Prob. 3-2SC Ch. 1.2 - Prob. 3-3SC Ch. 1.2 - Prob. 3-4SC Ch. 1.2 - Prob. 3-5SC Ch. 1.2 - Prob. 3-6SC Ch. 1.2 - Prob. 3-7SC Ch. 1.2 - Prob. 3-8SC Ch. 1.2 - Prob. 3-9SC Ch. 1.2 - Prob. 3-10SC Ch. 1.2 - Prob. 4-1SC Ch. 1.2 - Prob. 4-2SC Ch. 1.2 - Prob. 4-3SC Ch. 1.2 - Prob. 4-4SC Ch. 1.2 - Prob. 4-5SC Ch. 1.2 - Prob. 4-6SC Ch. 1.2 - Prob. 4-7SC Ch. 1.2 - Prob. 4-8SC Ch. 1.2 - Prob. 4-9SC Ch. 1.2 - Prob. 4-10SC Ch. 1.2 - Prob. 5-1SC Ch. 1.2 - Prob. 5-2SC Ch. 1.2 - Prob. 5-3SC Ch. 1.2 - Prob. 5-4SC Ch. 1.2 - Prob. 1SE Ch. 1.2 - Prob. 2SE Ch. 1.2 - Prob. 3SE Ch. 1.2 - Prob. 4SE Ch. 1.2 - Prob. 5SE Ch. 1.2 - Prob. 6SE Ch. 1.2 - Prob. 7SE Ch. 1.2 - Prob. 8SE Ch. 1.2 - Prob. 9SE Ch. 1.2 - Prob. 10SE Ch. 1.2 - Prob. 11SE Ch. 1.2 - Prob. 12SE Ch. 1.2 - Prob. 13SE Ch. 1.2 - Prob. 14SE Ch. 1.2 - Prob. 15SE Ch. 1.2 - Prob. 16SE Ch. 1.2 - Prob. 17SE Ch. 1.2 - Prob. 18SE Ch. 1.2 - Prob. 19SE Ch. 1.2 - Prob. 20SE Ch. 1.2 - Prob. 21SE Ch. 1.2 - Prob. 22SE Ch. 1.2 - Prob. 23SE Ch. 1.2 - Prob. 24SE Ch. 1.2 - Prob. 25SE Ch. 1.2 - Prob. 26SE Ch. 1.2 - Prob. 27SE Ch. 1.2 - Prob. 28SE Ch. 1.2 - Prob. 29SE Ch. 1.2 - Prob. 30SE Ch. 1.2 - Prob. 31SE Ch. 1.2 - Prob. 32SE Ch. 1.2 - Prob. 33SE Ch. 1.2 - Prob. 34SE Ch. 1.2 - Prob. 35SE Ch. 1.2 - Prob. 36SE Ch. 1.2 - Prob. 37SE Ch. 1.2 - Prob. 38SE Ch. 1.2 - Prob. 39SE Ch. 1.2 - Prob. 40SE Ch. 1.2 - Prob. 41SE Ch. 1.2 - Prob. 42SE Ch. 1.2 - Prob. 43SE Ch. 1.2 - Prob. 44SE Ch. 1.2 - Prob. 45SE Ch. 1.2 - Prob. 46SE Ch. 1.2 - Prob. 47SE Ch. 1.2 - Prob. 48SE Ch. 1.2 - Prob. 49SE Ch. 1.2 - Prob. 50SE Ch. 1.2 - Prob. 51SE Ch. 1.2 - Prob. 52SE Ch. 1.2 - Prob. 53SE Ch. 1.2 - Prob. 54SE Ch. 1.2 - Prob. 55SE Ch. 1.2 - Prob. 56SE Ch. 1 - Prob. 1ES Ch. 1 - Prob. 2ES Ch. 1 - Prob. 3ES Ch. 1 - Prob. 4ES Ch. 1 - Prob. 5ES Ch. 1 - Prob. 6ES Ch. 1 - Prob. 7ES Ch. 1 - Prob. 8ES Ch. 1 - Prob. 9ES Ch. 1 - Prob. 10ES Ch. 1 - Prob. 11ES Ch. 1 - Prob. 12ES Ch. 1 - Prob. 13ES Ch. 1 - Prob. 14ES Ch. 1 - Prob. 15ES Ch. 1 - Prob. 16ES Ch. 1 - Prob. 17ES Ch. 1 - Prob. 18ES Ch. 1 - Prob. 19ES Ch. 1 - Prob. 20ES Ch. 1 - Prob. 21ES Ch. 1 - Prob. 22ES Ch. 1 - Prob. 23ES Ch. 1 - Prob. 24ES Ch. 1 - Prob. 25ES Ch. 1 - Prob. 26ES Ch. 1 - Prob. 27ES Ch. 1 - Prob. 28ES Ch. 1 - Prob. 29ES Ch. 1 - Prob. 30ES Ch. 1 - Prob. 31ES Ch. 1 - Prob. 32ES Ch. 1 - Prob. 33ES Ch. 1 - Prob. 34ES Ch. 1 - Prob. 35ES Ch. 1 - Prob. 36ES Ch. 1 - Prob. 37ES Ch. 1 - Prob. 38ES Ch. 1 - Prob. 39ES Ch. 1 - Prob. 40ES Ch. 1 - Prob. 41ES Ch. 1 - Prob. 42ES Ch. 1 - Prob. 43ES Ch. 1 - Prob. 44ES Ch. 1 - Prob. 45ES Ch. 1 - Prob. 46ES Ch. 1 - Prob. 47ES Ch. 1 - Prob. 48ES Ch. 1 - Prob. 49ES Ch. 1 - Prob. 50ES Ch. 1 - Prob. 51ES Ch. 1 - Prob. 52ES Ch. 1 - Prob. 53ES Ch. 1 - Prob. 54ES Ch. 1 - Prob. 55ES Ch. 1 - Prob. 56ES Ch. 1 - Prob. 57ES Ch. 1 - Prob. 58ES Ch. 1 - Prob. 59ES Ch. 1 - Prob. 60ES Ch. 1 - Prob. 61ES Ch. 1 - Prob. 62ES Ch. 1 - Prob. 63ES Ch. 1 - Prob. 64ES Ch. 1 - Prob. 65ES Ch. 1 - Prob. 66ES Ch. 1 - Prob. 67ES Ch. 1 - Prob. 68ES Ch. 1 - Prob. 69ES Ch. 1 - Prob. 70ES Ch. 1 - Prob. 71ES Ch. 1 - Prob. 72ES Ch. 1 - Prob. 73ES Ch. 1 - Prob. 74ES Ch. 1 - Prob. 75ES Ch. 1 - Prob. 76ES Ch. 1 - Prob. 77ES Ch. 1 - Prob. 78ES Ch. 1 - Prob. 79ES Ch. 1 - Prob. 80ES Ch. 1 - Prob. 81ES Ch. 1 - Prob. 82ES Ch. 1 - Prob. 83ES Ch. 1 - Prob. 84ES Ch. 1 - Prob. 85ES Ch. 1 - Prob. 86ES Ch. 1 - Prob. 87ES Ch. 1 - Prob. 88ES Ch. 1 - Prob. 89ES Ch. 1 - Prob. 1PT Ch. 1 - Prob. 2PT Ch. 1 - Prob. 3PT Ch. 1 - Prob. 4PT Ch. 1 - Prob. 5PT Ch. 1 - Prob. 6PT Ch. 1 - Prob. 7PT Ch. 1 - Prob. 8PT Ch. 1 - Prob. 9PT Ch. 1 - Prob. 10PT Ch. 1 - Prob. 11PT Ch. 1 - Prob. 12PT Ch. 1 - Prob. 13PT Ch. 1 - Prob. 14PT Ch. 1 - Prob. 15PT Ch. 1 - Prob. 16PT Ch. 1 - Prob. 17PT Ch. 1 - Prob. 18PT Ch. 1 - Prob. 19PT Ch. 1 - Prob. 20PT Ch. 1 - Prob. 21PT Ch. 1 - Prob. 22PT Ch. 1 - Prob. 23PT Ch. 1 - Prob. 24PT Ch. 1 - Prob. 25PT Ch. 1 - Prob. 26PT Ch. 1 - Prob. 27PT Ch. 1 - Prob. 28PT Ch. 1 - Prob. 29PT Ch. 1 - Prob. 30PT Ch. 1 - Prob. 31PT Ch. 1 - Prob. 32PT Ch. 1 - Prob. 1CT Ch. 1 - Prob. 2CT Ch. 1 - Prob. 3CT Ch. 1 - Prob. 4CT Ch. 1 - Prob. 5CT Ch. 1 - Prob. 6CT Ch. 1 - Prob. 7CT Ch. 1 - Prob. 8CT Ch. 1 - Prob. 9CT Ch. 1 - Prob. 10CT Ch. 1 - Prob. 11CT Ch. 1 - Prob. 12CT Ch. 1 - Prob. 1CP Ch. 1 - Prob. 2CP Ch. 1 - Prob. 1CS1 Ch. 1 - Prob. 2CS1 Ch. 1 - Prob. 3CS1 Ch. 1 - Prob. 1CS2 Ch. 1 - Prob. 2CS2 Ch. 1 - Prob. 3CS2 Ch. 1 - Prob. 1CS3 Ch. 1 - Prob. 2CS3 Ch. 1 - Prob. 3CS3 Ch. 1 - Prob. 4CS3 Ch. 1 - Prob. 5CS3

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.

Whether sterns automotive has reached its overall sales quota of 500 units per month. Also determine the salespersons who reached the monthly sales goal of 70 units. Use the excel template and the provided table to solve.

Solution Summary: The author explains how to determine whether sterns automotive has reached its overall sales quota of 500 units per month and the salespersons who have reached the monthly sales goal of 70 units.

Videos

Whether sterns automotive has reached its overall sales quota of 500 units per month. Also determine the salespersons who reached the monthly sales goal of 70 units. Use the excel template and the provided table to solve.

Want to see the full answer?

Chapter 1 Solutions