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 is the purpose of risk management industry standards

What is the purpose of risk management industry standards? What responsibilities does senior management assume in a risk management system? What is the most important component of an effective risk management system? Bri ...

1 an interest rate swap has two primary risks associated

1. An interest rate swap has two primary risks associated with it. Identify and explain each risk. 2. Define and explain a constant maturity swap. 3. Explain how an interest rate swap is a special case of a currency swap ...

The shareholders of motive power corp need to elect four

The shareholders of Motive Power Corp. need to elect four new directors to the board. There are 14,900,000 shares of common stock outstanding, and the current share price is $11.10. If the company uses cumulative voting ...

Assume the followingerm 7rf 2expected risk premium on

Assume the following: E(rM) = 7% rF = 2% Expected risk premium on Boeing stock = 7% a. What is the expected return on Boeing stock? Show your work. b. What is the value of β for Boeing stock? Show your work.

Define the endurance limit of a bolt which is greater the

Define the endurance limit of a bolt ? Which is greater, the static yield strength or the endurance limit of the bolt? When will an increase in preload increase fatigue life? When will an increase in preload decrease fat ...

1 how many conditions are there in the simplest possible

1. How many conditions are there in the simplest possible experiment? 2. Describe how participants are assigned to conditions in randomized groups, matched-subjects, and repeated measures experimental designs. 3. What ar ...

Contrast lookback options and barrier options and explain

Contrast lookback options and barrier options and explain the difference between in- and out-options? Explain how weather derivatives could be used by an electric utility to manage the risk associated with power consumpt ...

The last decade has witnessed an unprecedented number of

The last decade has witnessed an unprecedented number of mega-mergers in the banking industry: Bank of America's acquisitions of Fleet Bank, MBNA, and U.S. Trust; Bank of New York's acquisition of Mellon Financial; and W ...

Problem 1eric leased a new car the deal calls for 36

PROBLEM 1 Eric leased a new car. The deal calls for 36 beginning-of-month payments of $450, starting today. In addition, Eric has to include $1,000 with the final payment. The contract has an APR of 12% with monthly comp ...

1 discuss some of the major issues to consider when

1. Discuss some of the major issues to consider when choosing between an active or passive exporting strategy. 2. You work for a small company that has an innovative low-cost production method for high-capacity jump driv ...

  • 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