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 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
Get step-by-step solutions from verified subject matter experts
