Question: Excel Project. REQUIRED a. Create a spreadsheet that contains the following data: b. On the same worksheet, but to the right of the data above,

Excel Project.

REQUIRED

a. Create a spreadsheet that contains the following data:

SALESPERSON Smith Barnes Martinez Jackson Hsu Smith Barnes Hsu Barnes Martinez Jackson Smith Barnes Martinez

b. On the same worksheet, but to the right of the data above, create the following table to show calls made by each salesperson this quarter. Use the sumproduct function to create a formula that automatically calculates the total calls handled.

CALLS MADE BY SALESPERSON THIS QUARTER JULY Barnes Hsu Jackson Martinez Smith AUGUST SEPTEMBER

(Hint: Read the article “Supercharge Your Excel Sum Operations: Add data by up to 30 criteria,’ by J.D. Kern in the July 2009 issue of the Journal of Accountancy for an explanation of the sumproduct function and the use of double dashes. The Journal of Accountancy is available either in print or online at www.aicpa.org.)*

SALESPERSON Smith Barnes Martinez Jackson Hsu Smith Barnes Hsu Barnes Martinez Jackson Smith Barnes Martinez Jackson Hsu Jackson Hsu Smith Barnes Martinez Jackson Hsu DATE 07/03/2014 07/05/2014 07/13/2014 07/20/2014 07/28/2014 08/01/2014 08/02/2014 08/10/2014 08/10/2014 08/14/2014 08/20/2014 08/22/2104 08/23/2014 09/01/2014 09/02/2014 09/05/2014 09/11/2014 09/11/2014 09/15/2014 09/20/2104 09/30/2014 09/30/2014 09/30/2014 CALLS MADE 100 110 95 115 120 125 115 110 100 135 115 90 85 100 90 95 140 150 110 120 120 90 60

Step by Step Solution

★★★★★

3.61 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Information Systems Questions!

Create a spreadsheet that contains the following data: b. On the same worksheet, but to the right of the data above, create the following table to show calls made by each salesperson this quarter....

BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...

Superior Stay Resorts provides luxurious hotel accommodations to its high-end customer base. Superior measures business volume by the total number of occupied guest room nights during the year. For...

12.13 Excel Project. REQUIRED a. Create a spreadsheet that contains the following data: DATE 07/03 07/05 07/13 07/20 07/28 08/01 CALLS MADE 100 110 SALESPERSON 115 120 125 115 110 100 135 115 90...

12.13 Excel Project REQUIRED a. Create a spreadsheet that contains the following data: CALLS MADE 100 110 95 115 120 125 SALESPERSON Smith Bames Martinez Jackson Hsu Smith Bames Hsu Bames Martinez...

REQUIRED a. Create a spreadsheet that contains the following data: SALESPERSON DATE CALLS MADE Smith 07/03 100 Barnes 07/05 110 Martinez 07/13 95 Jackson 07/20 115 Hsu 07/28 120 Smith 08/01 125...

Excel Project. REQUIRED a. Create a spreadsheet that contains the following data: SALESPERSON DATE CALLS MADE Smith 07/03 100 Barnes 07/05 110 Martinez 07/13 95 Jackson 07/20 115 Hsu 07/28 120 Smith...

Please tell me the excel formulas for the picture below in response to the problem 13.6 12.4 Excel Project. REQUIRED a. Create a 12-month cash flow budget in Excel using the following assumptions:...

Integrative Exercise Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts Special-Order Offer Relevant Analysis Superior Stay Resorts...

king inventory availability 12.4 Excel Project. REQUIRED a. Create a 12-month cash flow budget in Excel using the following assumptions: Initial sales of $5 million, with forecasted monthly growth of...

In what ways does the timeliness of the publication of financial information differ across countries?

Consider a scenario where you have to deal with a massive dataset that doesn't fit into memory, but needs to be sorted. How would you design an algorithm that efficiently sorts this data while...

In pairs or a small group, discuss what Marcus and Arun say. Do you agree with Arun? Explain your answer. When I factorise 6x+ 18 I get 3(2x+6) I don't, I get 6(x+3) so one of us must be wrong!

Refer to Reeboks financial statements in Appendix E. Review the balance sheet to determine how and where current liabilities were reported. Required a. Read Note 6. Identify and discuss any unusual...

Compare and contrast the COBIT, COSO, and ERM control frameworks.

Describe the major elements in the internal environment of a company.

Describe the control objectives companies need to set and how to identify events that affect organizational uncertainty.

If Steak, Inc. holds 40% of the outstanding stock of House, Inc., the type of interest Steak, Inc. is said to have in House, Inc. is: a) Influencing b) Passive c) Controlling d) Positional

The beta of Elsenore, Inc., stock is 1.6, whereas the risk. freel rate of return is 8 percent. If the expected return on the market is 15 percent, then what should investors expect as a return on...

Required Return If the risk-free rate is 10.3 percent and the market risk premium is 4.6 percent, what is the required return for the market? 14.9% 4.6% 5.7% 10.3%