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

Estate plan scenariokathi and darrin backgroundkathi and

ESTATE PLAN SCENARIO Kathi and Darrin Background Kathi and Darrin have been married for 50 years and are both in good health. Kathi and Darrin live in a community property state. They have the following children and gran ...

1 in what sense could one argue that if managers make

1. In what sense could one argue that if managers make decisions using breakeven analysis, they are not maximizing shareholder wealth? How can breakeven analysis be modified to solve this problem? 2. Explain the differen ...

The following is an excerpt taken from a november 30 2007

The following is an excerpt taken from a November 30, 2007, speech entitled "Innovation, Information, and Regulation in Financial Markets" by Federal Reserve Governor Randall S. Kroszner (www. federalreserve.gov/newseven ...

Explain why an options time value is greatest when the

Explain why an option's time value is greatest when the stock price is near the exercise price and why it nearly disappears when the option is deep-in- or out-of-the-money? Critique the following statement, made by an op ...

Finance assignmentcreate a 1050-word report and include the

Finance Assignment Create a 1,050-word report, and include the following: • Explain the relationship between risk and return • Identify an example of risk and return. • Explain which is more risky bonds or common stocks. ...

1 what is the novelty effect and how does it affect a

1. What is the novelty effect, and how does it affect a study's external validity? 2. Describe one way in which the experimenter may threaten the external validity of the results of a study. 3. How does sensitization thr ...

A random sample of 138 observations produced a sample mean

A random sample of 138 observations produced a sample mean of 30. Find the critical and observed values of z for the following test of hypothesis using α=0.1. The population standard deviation is known to be 9 and the po ...

1 what is the equation of exchange is the equation of

1. What is the equation of exchange? Is the equation of exchange a theory? Briefly explain. 2. What is the quantity theory of money? What does the quantity theory indicate is the cause of inflation? 3. What is purchasing ...

Imagine you obtained a point biserial correlation of 35

Imagine you obtained a point biserial correlation of .35 between gender and punctuality, showing that men arrived later to class than did women. You think that this correlation might be due to the fact that more women th ...

1 define reaction time task completion time and

1. Define reaction time, task completion time, and interbehavior latency. 2. Give three examples (other than those in the chapter) of measures of duration. 3. What is interrater reliability, and what are some ways in whi ...

  • 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