To follow is an example of a worksheet containing the operating cash flow ratios for five companies over a six-year period. 

Using the Excel file online in MyLab Accounting, apply the Formatting: Icon set option in the Quick Analysis button to the data set. 

Answer the following questions:

a. Which cells contain a green up arrow icon?

b. Which cells contain a red down arrow icon?

Transcribed Image Text:

1 Operating cash flow ratio 2 Allison Corp. 3 Beatrice Inc. 4 Callogy Company 5 Disnear Corp. 6 Elliston Limited C D E F G Dec2015 Dec2016 Dec2017 Dec2018 Dec2019 Dec2020 14.0% 34.2% 25.9% 31.9% 18.7% 23.3% 24.5% 47.8% 69.6% 2.6% 35.4% 21.8% 33.7% 8.8% 27.0% 18.9% 54.2% 19.6% 29.4% -2.5% 6.7% -1.9% 15.5% 16.3% 17.8% 33.4% 24.0% 1.2% 13.1% 41.3%