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

Strident corporation is attempting to determine whether to

Strident Corporation is attempting to determine whether to lease or purchase a new telephone system. The firm is in the 40 percent tax bracket, and its after-tax cost of debt is currently 4.5 percent. The terms of the le ...

Assume that european call and put options exist on a stock

Assume that European call and put options exist on a stock. That stock, however, is the target of a takeover in which an acquiring firm offers a fixed price for the stock. The takeover is almost certain to occur shortly ...

Define each of the followinga call optionb put optionc

Define each of the following: a. Call option b. Put option c. Strike price d. Expiration date 2. How do the rights and obligations of options buyers and sellers differ from the rights and obligations of futures buyers an ...

1 disadvantage of high liquidity what is a disadvantage of

1. Disadvantage of High Liquidity. What is a disadvantage of maintaining a very high level of liquidity? 2. Economic Impact on Liquidity Needs. Assume that your monthly expenses will not change over the next three years, ...

Options can protect a firm against the downside risk of a

Options can protect a firm against the downside risk of a business transaction while preserving the upside potential from the transaction. In contrast, forward and futures contracts normally protect against the downside ...

If asset as beta is greater than asset bs beta does this

If asset A's beta is greater than asset B's beta, does this mean that asset A has more risk than asset B? Explain? What is the difference between the security market line and the capital market line? How should an invest ...

A company is planning to add extra capacity to a plant

A company is planning to add extra capacity to a plant currently manufacturing 110 000 items per year. After an accurate sales forecast over the next few years, one is quite sure that the most likely value of the annual ...

Barilla is an italian multinational food company which

Barilla is an Italian multinational food company which ‘has significantly believed in B2B e-commerce and, in particular, in EDI (Electronic Data Interchange), especially in terms of Web-EDI, which supports the orderdeliv ...

1 what is the federal agency underwriting function and what

1. What is the federal agency underwriting function and what does it do for the mortgage market, and ultimately for the borrower? 2. Compare and contrast the two categories of bonds and how they differ from mortgage- bac ...

1 develop at least three behavioral measures of each of the

1. Develop at least three behavioral measures of each of the following conceptual variables. Consider measures that are based on frequency, speed, duration, latency, and intensity. Consider the extent to which each of th ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen