Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Business Statistics A First Course

Authors: David M. Levine, Kathryn A. Szabat, David F. Stephan

7th Edition

9780321979018

Students also viewed these Accounting questions