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

What primary factors determine the number of load cycles

What primary factors determine the number of load cycles required to break a bolt subject to fatigue loading? Describe the appearance of the break surface of a bolt which has failed in fatigue ? Where on a bolt are you m ...

The mass m of drops formed by liquid discharging by gravity

The mass M of drops formed by liquid discharging by gravity from a vertical tube is a function of the tube diameter D, liquid density, surface tension, and the acceleration of gravity. Determine the independent dimension ...

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

Analyze a sales letter or email you receivebe on the

Analyze a sales letter or email you receive. Be on the lookout for sales letters you receive at home or through email. Bring one to class so you can discuss the example with other students. In small groups, discuss how t ...

Many grocery stores and large retailers such as wal-mart

Many grocery stores and large retailers such as Wal-Mart and K-Mart have installed self checkout systems so shoppers can scan their own items and cash out themselves. How do customers like this service and how often do t ...

In addition to the key words you should also be able to

In addition to the key words, you should also be able to define each of the following terms: ethics Nuremberg Code National Research Act Belmont Report APA Ethics Code clinical equipoise consent form confederate placebo ...

1 why would a companys costs of manufacturing and

1. Why would a companys costs of manufacturing and procurement tend to increase as the firm changes from an MTP to an MTO strategy? Why would inventory costs tend to decrease? 2. How does a firms marketing strategy impac ...

In a survey of 2695 adults 1479 say they have started

In a survey of 2695 adults, 1479 say they have started paying bills online in the last year. Construct a 99% confidence interval for the population proportion. Interpret the results. A 99% confidence interval for the pop ...

Make up an example of deduction or deductive reasoningin

Make up an example of deduction or deductive reasoning. In deductive reasoning, if the premises or initial observations are true, does this guarantee that the conclusion is true? Explain why or why not.

Investigators studying the mass transfer from single

Investigators studying the mass transfer from single spheres recommended the generalized equation As discussed in section 30.1, the value of 2 can be derived theoretically by considering the molecular diffusion from a sp ...

  • 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