Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 15

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

Medical Audits In Developing Countries The Challenges And Solutions

Authors: Hussein Lesio Kidanto

1st Edition

9783639300338, 978-3639300338

More Books

Students also viewed these Accounting questions