A local firm wanted to explore various marketing channels to see how much sales revenue was generated by each marketing campaign over the course of 10 weeks. The data from the study is located in the Microsoft Excel Online file below. Use the spreadsheet to answer the following questions.

In this graded tutorial you will learn how to use Excel's INDEX and MATCH functions. If you are familiar with the VLOOKUP function, INDEX/MATCH is often seen as a better method to accomplish the same goal.

The Excel INDEX function returns a value in a range based on the row and/or column numbers that are specified. Its format is INDEX(array, row_num, [column_num]). Note that column_num is optional. For example, assume you have the simple data below:

Entering the function =INDEX($A$1:$A$4,2) will return the value of "South." This function says 1) look at the range of $A$1:$A$4, 2) go to the second row, and then 3) return the value in that cell.

Entering the function =INDEX($A$1:$B$1,2) will return the value of "50247." This function says 1) look at the range of $A$1:$B$1, 2) go to the second column, and then 3) return the value in that cell.

Entering the function =INDEX($A$1:$B$4,4,2) will return the value of "75763." This function says 1) look at the range of $A$1:$B$4, 2) go to the fourth row, 3) go to the second column, and then 4) return the value in that cell.

Question 1.

Find the data requested in cell E3 by using the INDEX function in cell F3. Enter your answer in hundreds of dollars.

Question 2.

Choose the correct data requested in cell E5 by using the INDEX function in cell F5