Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Training Required? column (L), you will also need to use the If function* to indicate who requires training based on their Total Sales.

image text in transcribed

  1. In the Training Required? column (L), you will also need to use the If function* to indicate who requires training based on their Total Sales. Employees with sales less than $85 do require training (Yes), whereas employees with sales more than $85 do not require training (No).

Excel File Edit View Insert Format Tools Data Window Help Sun Nov 22 8:34 PM AutoSave Dominguez_Alex_A12_ a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Open Sans A v 10 s. Wras Text . General 2 Insert v Delete Format 4 Paste B Av = == Merge & Centar v % 9 Conditional Format Formatting as Table Cell Styles Z Sort & Filter Find & Select Ideas Sensitivity N32 1 J K L M N O P a Training Required? 534.85 A C D E F G 5 Base Salary $25 6 Commission 10% 7 8 Sales $0 $50 $75 $100 $125 $ $150 Commission & 9 Bonus $1.00 $5.00 $6.50 $8.00 $10.00 $12.50 10 11 12 Quarterly Sales (in thousands) Total Commision& 13 Employee First Second Third Fourth Sales Salary Bonus 14 Gabrielle 26.93 14.23 4.12 8.22 53.50 47.19 5 15 Mitchell 22.18 18.34 32.54 7.50 80.56 53.74 6.5 16 Kyle 42.03 11.23 30.50 29.81 113.57 38.52 8 17 Courtney 7.14 11.50 12.87 18.04 49.55 47.54 1 18 Juliana 15.24 28.41 15.90 20.12 79.67 42.22 6.5 19 Paul 36.06 32.12 22.10 29.41 119.69 52.16 8 20 Bella 38.29 26.52 21.12 20.65 106.58 37.29 8 21 Liyuan 14.87 32.49 53.87 33.33 134.56 53.11 10 22 Caleb 15.98 9.50 12.47 18.50 56.45 37.46 5 23 Jenny 33.12 26.67 38.52 23.51 121.82 48.22 8 24 Amy 45.02 57.34 40.21 23.56 166.13 53.25 12.5 25 Conor 13.00 33.59 48.20 10.40 105.19 60.11 8 26 Aedric 40.24 5.99 9.85 22.67 78.75 29.99 6.5 27 PLS 21 Average Total Sales $97.39 28 29 30 31 32 Report + Ready Total Date Years Salary Hired W/Firm 693.8 28-Jan-17 3.82 641.61 27-May-97 23.51 581.37 2-Jul-05 15.41 8-May-01 19.56 486.31 14-Aug-19 1.28 437.59 18-Aug-02 18.28 377.43 23-May-09 11.51 332.14 24-Dec-12 7.92 269.03 29-Jun-07 13.41 226.57 29-Oct-12 8.07 170.35 19-Mar-11 9.69 104.6 7-Nov-88 32.07 36.49 20-Apr-94 26.61 + DO + 158% g 22 tv N A 9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Financial Management For Residential Construction

Authors: Emma Shinn

6th Edition

0867187816, 9780867187816

More Books

Students also viewed these Accounting questions

Question

=+1. Do you have insurance?

Answered: 1 week ago

Question

=+ 2. Do you have a license and do you have insurance?

Answered: 1 week ago