Description
Please review that attachment and answer the 6 questions that's on MS Word
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
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:
A
B
1
North
50247
2
South
47125
3
East
32478
4
West
75763
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.
A
B
1
North
5024...