Answered step by step
Verified Expert Solution
Link Copied!

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

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 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

The Routledge Companion To Accounting And Risk

Authors: Margaret Woods

1st Edition

1138860123, 9781138860124

More Books

Students also viewed these Accounting questions

Question

3. Is there action in verbs rather than in nouns or infinitives?

Answered: 1 week ago

Question

Define promotion.

Answered: 1 week ago

Question

Write a note on transfer policy.

Answered: 1 week ago

Question

Discuss about training and development in India?

Answered: 1 week ago

Question

Explain the various techniques of training and development.

Answered: 1 week ago