Answered step by step
Verified Expert Solution
Question
1 Approved Answer
EXCEL FILE: sales.xlsx Below is a data table with sales reps names and their sales results on a monthly basis. [Spreadsheet Modeling] Employee Jane Gabe
EXCEL FILE: sales.xlsx Below is a data table with sales reps names and their sales results on a monthly basis. [Spreadsheet Modeling] Employee Jane Gabe Ryan Chong Alex Clara Julia Samantha Keri July Sales $ 11,000.00 $ 13,400.00 $ 35,000.00 $ 13,450.00 $ 40,000.00 $ 34,000.00 $ 10,000.00 $ 40,000.00 $ 13,000.00 August Sales September Sales $ 40,000.00 $ 10,000.00 $ 34,000.00 $ 13,400.00 $ 10,000.00 $ 33,000.00 $ 40,000.00 $ 10,000.00 $ 13,000.00 $ 40,000.00 $ 10,000.00 $ 13,000.00 $ 13,400.00 $ 40,000.00 $ 35,000.00 $ 34,000.00 $ 13,450.00 $ 13,450.00 Using the IF or SUMIF functions in excel, calculate what the total dollar amount of sales was in August from sales reps who made more than $20,000 dollars in sales that month. O $149,000 O $136,000 O $135,000 O $150,000
Step 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