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

Using the Excel file online in MyLab Accounting, apply the Formatting: Top 10% option in the Quick Analysis button to the data set. Answer the following questions:

a. Describe the process you would use to apply the specified formatting.

b. Which cells would be shaded after applying the specified formatting?  

Transcribed Image Text:

1 Operating cash flow ratio 2 Jassion Company 3 Kent Limited 4 Landers Corp. 5 Mirebeth Inc. 6 Naderville Co. 7 Orlando-North Company 8 Papperton Inc. C D E F G Dec2015 Dec2016 Dec2017 Dec2018 Dec2019 Dec2020 24.1% 30.1% 17.7% 43.3% 25.8% 20.7% 55.8% 5.0% -0.5% -0.3% 8.7% 2.0% 11.3% 27.2% 38.4% 22.0% 0.3% 45.6% 39.7% 57.5% 14.1% 21.5% 20.7% 45.7% 41.1% 53.7% 50.5% 57.9% 50.7% 42.4% 81.6% 44.6% 39.5% -1.7% -2.2% 0.1% 5.6% 18.3% 32.1% 30.2% 52.0% 14.2%