Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1. Open the excel file and click on the data worksheet. Use the SUMIF function to find out the total amount of sales in dollars (A/R Change) for each of the four types (Blue, Red, etc) This should match these totals.
August Sales in Dollars by Type
Blue $33,090.89
Green $36,701.39
Red $37,061.09
White $43,480.92
Total $150,334.29

2. Use the SUMIFS function to determine the amount of sales for each type of inventory (Blue, Red, Etc.) for a specific function. Please note that the length of your different ranges must be identical. Ranges have to go to row 6520 or longer.date during August 2010.

3. Use the Drop Down List feature and the SUMIFS function to determine the amount of dollar sales for each type of inventory (Blue, Red, etc.) for any customer for the month. ( Don't use pivot table for customer list use a range reference)

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927920

Have any Question? 


Related Questions in Basic Finance

Healthy foods just paid its annual dividend of 162 a share

Healthy Foods just paid its annual dividend of $1.62 a share. The firm recently announced that all future dividends will be increased by 2.1 percent annually. What is one share of this stock worth to you if you require a ...

1 discuss how any company can become an mnc what are some

1. Discuss how any company can become an MNC. What are some of the options available to companies that allow them to use international markets and locations competitively? 2. Discuss some reasons why reductions in world ...

1 what is an interaction2 how many interactions can be

1. What is an interaction? 2. How many interactions can be tested in a 2 x 2 design? In a 3 x 3 design? In a 2 x 2 x 3 design? 3. Why do researchers use expericorr designs?

1 explain the rationale behind time series designs2

1. Explain the rationale behind time series designs. 2. Describe the simple interrupted time series design. 3. Why is contemporary history a threat to internal validity in a simple interrupted time series design?

An asset management firm has a 300 million portfolio

An asset management firm has a $300 million portfolio consisting of all stock. It would like to divest 10 percent of its stock and invest in bonds. It considers the possibility of synthetically selling some stock using e ...

1 what is the difference between descriptive and

1. What is the difference between descriptive and inferential statistics? 2. Describe the most common descriptive statistics. 3. What are standard scores, and how are they calculated? 4. What is meant by an unbiased esti ...

Check and revise sentences for parallel structuredetermine

Check and revise sentences for parallel structure Determine whether the following sentences use parallel structure. Revise sentences as needed to make the structure parallel. a. The executive at Ernst & Young writes repo ...

Question 1 outline the differences between common stock and

Question 1: Outline the differences between common stock and preferred stock? Question 2: What are the differences between capital projects that are independent, mutually exclusive, and contingent? Question 3: Cortez Art ...

Walmart or carrefour who will be master of planet retailsam

WALMART OR CARREFOUR WHO WILL BE MASTER OF PLANET RETAIL? Sam Walton began Walmart, the world's largest retailer, in 1962. Headquartered in Bentonville, Arkansas, Walmart was built on the policies of "everyday low prices ...

Briefly describe each of the following developments in

Briefly describe each of the following developments in accounts payable and disbursements. a. Integrated accounts payable b. Purchasing/procurement cards c. Imaging services d. Fraud prevention in disbursements.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro