What is match index and sum function

Reference no: EM131438522

Question: The following exercises use the Purchase Orders database. Use MATCH and/or INDEX functions to find the following:

a. The row numbers corresponding to the first and last instance of item number 1369 in column C (be sure column C is sorted by order number).

b. The order cost associated with the first instance of item 1369 that you identified in part (a).

c. The total cost of all orders for item 1369. Use the answers to parts (a) and (b) along with the SUM function to do this. In other words, you should use the appropriate INDEX and MATCH functions within the SUM function to find the answer. Validate your results by applying the SUM function directly to the data in column G.

Reference no: EM131438522

Questions Cloud

As a part of environmental scanning hr planners : As a part of Environmental scanning HR planners should:

Determining the web reader analysis : Choose two websites that are designed for very different types of readers. Write a discussion posting in which you compare and contrast the websites, showing how they approach their readers differently. How do they use content, organization, styl..

How should the company management handle given situation : Discuss if there should be any type of corrective action. How should the company management handle this situation? Feel free to share any situations that sound similar in the real world.

Board to investigate forming new division to design : Roger is a director of a major car manufacturer. This is one of the few remaining car companies yet to introduce a sport utility vehicle. Roger convinces the board to investigate forming a new division to design, build and market a sport utility vehi..

What is match index and sum function : The total cost of all orders for item 1369. Use the answers to parts (a) and (b) along with the SUM function to do this. In other words, you should use the appropriate INDEX and MATCH functions within the SUM function to find the answer.

Write up the given transactions in the books of s pink : Write up the following transactions in the books of S Pink: 2003 March 1 Started business with cash £1,000. " 2 Bought goods on credit from A Cliks £296. " 3 Paid rent ..

How to best address seasonal fluctuations in demand : Demand for many products is seasonal and can be impacted by weather, trends, financial markets, all while typically having an elastic demand. How can companies plan for this and what tactics do companies use to smooth the highs and lows of the demand..

Preserving history more accurate or less accurate : Do you think the advancements in technology will make preserving history more accurate or less accurate than the letters of the past? Why or why not?

Reconciles the forecast of labor supply and demand : Competency modeling has proven to be most useful for providing. Which of the following is NOT a characteristic of critical incident? Which of the following reconciles the forecast of labor supply and demand?

User Account

All Pages