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

Consider rolling a fair 6-faced die twice let a be the

Consider rolling a fair 6-faced die twice. Let A be the event that the sum of the two rolls is atmost 6, and B be the event that the first one is an even number. (a) What is the probability that the sum of the two rolls ...

A video posted to the wall street journals web site in

A video posted to the Wall Street Journal's Web site in mid-2010 was titled "Equities May Have Rallied Too Much, Buy Puts." a. What are equities? b. What does it mean that "equities may have rallied too much"? c. If equi ...

How would the following events affect the demand for

How would the following events affect the demand for loanable funds in the United States? a. Many U.S. cities increase business taxes to help close their budget deficits. b. Widespread use of handheld computers helps red ...

1 why do researchers use deception2 why do some people

1. Why do researchers use deception? 2. Why do some people object to the use of deception in research? 3. What four goals should a debriefing accomplish?

Over time many large companies in the us have increased

Over time many large companies in the US have increased exponentially the amount of long-term debt taken out to finance operations. What are some other alternatives to long-term financing needs in an organization and is ...

In july 2010 congress was considering having the federal

In July 2010, Congress was considering having the federal government set up a "lending fund" for small banks. The U.S. Treasury would lend the funds to banks. The more of the funds the banks loaned to small businesses, t ...

1 design an observational study of your own including the

1. Design an observational study of your own, including the creation of a set of behavioral categories that would be used to code for one or more variables of interest to you. Indicate the decisions that you have made re ...

1 affordable payments what should you consider when

1. Affordable Payments. What should you consider when determining an affordable down payment and monthly mortgage payments? 2. Selection Criteria . List the criteria you should use when selecting a home. 3. Selection Cri ...

Suppose you are comparing two companies that are in the

Suppose you are comparing two companies that are in the same line of business. Company C has an operating cycle of 40 days, and Company D has an operating cycle of 60 days. Company C has a current ratio of 3, and Company ...

Dr jones conducts an experiment investigating the effects

Dr. Jones conducts an experiment investigating the effects of distraction on memory. A list of 40 two-syllable words is prepared. Dr. Jones obtains a sample of 50 students, all between the ages of 18 and 22, and presents ...

  • 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