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

330 Reference Functions in SFAM 331 We have depended on using reference functions to implementing SFAM and developing Data Analysis data. 332 Below is a simplified example ofits use in SFAM. 333 The table presents data on three accounts over four years of a fictitious company. 334 Cost of 335 Revenues Revenues Gross Profit 336 2018 100 60 40 337 2019 105 61 44 338 2020 110 62 48 339 2021 116 64 52 340 341 Enter VLOOKUP functions in the green boxes below that pulls in the appropriate values from the table above. 342 343 2018 2019 2020 2021 344 Revenues 345 346 Enter INDEX and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 347 348 2018 2019 2020 2021 349 Cost of Revenues 350 351 Enter OFFSET and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 352 353 2018 2019 2020 2021 354 Gross Profit FR
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
