Question: Question Cells- Task/problem Example Excel Functions/features to you should use 18:113e Calculate consultant bonus: Bob Inaros generates sales in IF, SUM, VLOOKUP, Queensland for $5.000,

Question Cells- Task/problem Example Excel Functions/features to you should use 18:113e Calculate consultant bonus: Bob Inaros generates sales in IF, SUM, VLOOKUP, Queensland for $5.000, AND If a consultant generates sales Victoria for $100,000 and greater than or equal to: $10,000 NSW for $60,000. Therefore, for Queensland, and $20,000 for he receives no bonus. Victoria, and $50,000 for NSW Define the named range then the bonus for the total Frank Chan generates sales of E19:F23 ase amount should be calculated $25,000 in Queensland, "Bonus rates and use based on the total amount (e.g.. $75,000 in Victoria, and this in your VLOOKUP Queensland + NSW + Victoria) $65,000 NSW. His total and the rate from the therefore is $165,000 and he is "Bonus rates table". entitled to 20% commission which equals $33,000 i.e. the number $33,000 should be displayed in cell 19. Email address .. D G 6 7 Title First Name Last Name Date Started Consultant location Queensland sales Victoria sales NSW Sales Bonus (S) 8 M Bob Inaros 7/09/14 Melbourne 5 000 005 100 000 00S 60 000 00 9 M Frank Chan 11/01 Sydney $ 25000005 75000005 65.000.00 10 Mas Xiao Wang 11/11/19 Brisbane $ 15,000.00 $ 35.000.00S 150.000,00 11 M Macro Toure 14/05/20. Brisme $ 85.000.00 15.00000S 1000000 12 Mrs Jane Mac 1/04/20 Sydney $ 45000.00 $ 30 000 00 65000.00 13 M Jon Lannister 1/07/17 Melbourne 90,000.00 55.000.00 120.000.00 14 15 16 17 Bonus rates table Consultant details table 10 Sales threshold Bonus Consultant ID Email domain 19 S 10.000.00 EN BROS bbgroup.com 20 $ 100 000.00 108 FHAN tyhos.com 21 12000000 151 XANG pesolutions.com 150 000.00 201 MURE sprint.com $ 20000000 25 IMAO bgroup.com JTER tychos.com Question Cells- Task/problem Example Excel Functions/features to you should use 18:113e Calculate consultant bonus: Bob Inaros generates sales in IF, SUM, VLOOKUP, Queensland for $5.000, AND If a consultant generates sales Victoria for $100,000 and greater than or equal to: $10,000 NSW for $60,000. Therefore, for Queensland, and $20,000 for he receives no bonus. Victoria, and $50,000 for NSW Define the named range then the bonus for the total Frank Chan generates sales of E19:F23 ase amount should be calculated $25,000 in Queensland, "Bonus rates and use based on the total amount (e.g.. $75,000 in Victoria, and this in your VLOOKUP Queensland + NSW + Victoria) $65,000 NSW. His total and the rate from the therefore is $165,000 and he is "Bonus rates table". entitled to 20% commission which equals $33,000 i.e. the number $33,000 should be displayed in cell 19. Email address .. D G 6 7 Title First Name Last Name Date Started Consultant location Queensland sales Victoria sales NSW Sales Bonus (S) 8 M Bob Inaros 7/09/14 Melbourne 5 000 005 100 000 00S 60 000 00 9 M Frank Chan 11/01 Sydney $ 25000005 75000005 65.000.00 10 Mas Xiao Wang 11/11/19 Brisbane $ 15,000.00 $ 35.000.00S 150.000,00 11 M Macro Toure 14/05/20. Brisme $ 85.000.00 15.00000S 1000000 12 Mrs Jane Mac 1/04/20 Sydney $ 45000.00 $ 30 000 00 65000.00 13 M Jon Lannister 1/07/17 Melbourne 90,000.00 55.000.00 120.000.00 14 15 16 17 Bonus rates table Consultant details table 10 Sales threshold Bonus Consultant ID Email domain 19 S 10.000.00 EN BROS bbgroup.com 20 $ 100 000.00 108 FHAN tyhos.com 21 12000000 151 XANG pesolutions.com 150 000.00 201 MURE sprint.com $ 20000000 25 IMAO bgroup.com JTER tychos.com

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Worksheet 1, Task 1: 2 questions (2 marks per question) Question Cells Task/problem Example Excel Functions/features to you should use 18:1130 Calculate consultant bonus: Bob Inaros generates sales...

Worksheet 1, Task 1: 2 questions (2 marks per question) Question Cells Task/problem Example Excel Functions/features to you should use 18:113e Calculate consultant bonus: Bob Inaros generates sales...

Worksheet 2, Task 2: 1 question (2 marks) Question Cells- Task/problem Example Excel Functions/features to you should use IF, LEN, CONCAT (or CONCATENATE) H4:H9- Create a new Staff ID:- Jose's "Staff...

I keep getting the wrong answer for this question and I do not understand why For the T/F section in the table I use: =OR(YEAR(C4) For the Living Allowance I use:...

What does the correct answer look like using all of the information provided? Question Cells Task/problem Example Excel Functions/features to you should use IF, OR, YEAR, VLOOKUP 1 G4:G9 Calculate...

Cells Task/problem Example Excel Functions/features to you should use QI D4F11 Determine expense budget: Frank's Job role is You must use "Executive officer VLOOKUP and The Staff table includes an...

Please complete the questions as outlined above, complete the yellow and orange section, I need the function not only the answer, eg: what I need is the function like...

Q1 (5 marks) Cells Task/problem Example Excel Functions/features to you should use K3:K27 Approval category: Jackie, has a credit Use functions we score of 973, is have covered in the This is a...

A B c D E F G H 1 2 3 4 Student Name Studenti Tutorial number leg. MT4"): Tutor name (e. stan karanasios Note: the tutorial number can be found on Blackboard class Timetable &linkstat): 5 6 7 Name...

An investment of 40000 JD and estimated salvage value after 8 years of 17000 JD. The annual revenue is 14000 JD per year and the annual cost is 21000 JD per year. Using a MARR value of 10%. According...

A vertical cylinder (Fig. P4.106) has a 61.18-kg piston locked with a pin trapping 10 L of R-22 at 10C, 90% quality inside. Atmospheric pressure is 100 kPa, and the cylinder cross-sectional area is...

Question 2 4 0 . 3 pts When a check is written and given to a person with an account at a different bank, the banks do not transfer currency. Rather, the banks use which of the following? Electronic...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...