Question: Reference Functions in SFAM We have depended on using reference functions to implementing SFAM and developing Data Analysis data. Below is a simplified example of

 Reference Functions in SFAM We have depended on using reference functions

Reference Functions in SFAM We have depended on using reference functions to implementing SFAM and developing Data Analysis data. Below is a simplified example of its use in SFAM. The table presents data on three accounts over four years of a fictitious company. 2016 2017 2018 Revenues 100 105 110 116 Cost of Revenues 60 61 62 64 Gross Profit 40 44 48 52 2019 Enter VLOOKUP functions in the green boxes below that pulls in the appropriate values from the table above. 2016 2017 2018 2019 Revenues Enter INDEX and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 2016 2017 2018 2019 Cost of Revenues Enter OFFSET and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 2016 2017 2018 2019 Gross Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!