To prepare for the quiz, Ramirez collects the following data and presents them in an Excel spreadsheet. The number of shares outstanding had always been 200 shares from 2015 to 2019. Ramirez wants to calculate the companys current EPS from 2015 to 2019 and display the data in cell B9, C9, D9, E9, and F9, respectively. She also wants to use the appropriate Excel function to lock the value of the number of shares outstanding shown in cell B7 so that she could drag the excel function in cell B9 and drop it to cell C9, D9, E9, and F9. Therefore, Ramirez suggests the function she should use to calculate 2015s current EPS in cell B9 should be =B3/B$7.

- Is Ramirezs suggestion on the excel function used to calculate 2015s current EPS justifiable? Why? give the correct function and explain why