Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with this excel questions. I am using office 360 LL B C D E 1. Name October Sales November Sales December Sales Comission
Please help with this excel questions. I am using office 360
LL B C D E 1. Name October Sales November Sales December Sales Comission 2 Den 15000 16000 12000 3 Scott 16000 20000 15000 4. Colin 11000 9000 15000 5 Dustin 20000 10000 16000 6 Mike 25000 8000 13000 7 James 14000 16000 12000 8 Yvette 15000 18000 16000 9 Karl 11000 12000 18000 10 Frank 21000 15000 12000 11 Required 1: Create a single formula in Column E that will return a 10% commission for December sales if the average monthly fourth quarter sales are more than 15000, and 12 DISCIPLINARY ACTION otherwise. 13 B C D E F G H 1 K 1 Name PowerPoint - Word - Excel Access Outlook Status 2 Peter 70 50 100 50 100 3 Paul 70 80 80 70 50 4 Mary 80 80 90 50 100 5 Thomas 50 60 70 90 90 6 George 70 70 70 80 70 7 Nancy 20 80 80 70 80 8 Sinclair 80 70 90 50 50 9 Bob 70 70 100 80 80 10 Dustin 60 90 50 50 80 11 Derek 60 90 80 90 70 12 Phoebe 100 100 100 60 80 13 Required 1. In column G, create a formula that returns "Expert" if the student scores 70 or greater on PowerPoint, Word, and Excel, and 70 or greater on either Access or Outlook. Have the formula return "Non-Expert" otherwise. 14 15Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started