The following is a sample of a worksheet in Excel.

To complete this exercise, download the Excel file from MyLab Accounting.

Requirements
1. What number is in the last row and last column of the worksheet?
2. What is the content in Cell G1234?
3. What is the content in Cell M32240?
4. What number is in the last row of Column H?
5. What number is in Column A of Row 36210?
6. Select Cells 29–40 in Column E.
a. What is the Average?
b. What is the Count?
c. What is the Sum?

7. What is the content of the cell in the last row in the first column?
8. How would you select the entire data set in the worksheet?

Transcribed Image Text:

12345GTBS U12 6 7 8 Customer State or number Province Salesperson MS Frank AB Paul ON Sara ND Dave Paul Jennifer 77257 89280 31820 13757 9 61778 11 46218 81007 57722 10 33260 44782 16064 CO BC AL John MD Fred MO Mario ON John WI Nicole Insurance type Auto Auto Auto Auto $ 526.17 507.37 $ 763.65 Auto $ 1,028.33 Disability $ 868.50 $ 476.51 Disability $ 461.11 Auto $ 949.05 Disability $ 357.32 Auto $ 1,304.45 Auto $ 644.59 Total $ Policy number Policy 63194614 MS-Auto 38374054 AB-Auto 87957404 ON-Auto 12944651 ND-Auto 90718345 CO-Disability 68353050 BC-Auto 15480882 AL-Disability 60626926 MD-Auto 69320310 MO-Disability 54005990 ON-Auto 21244173 Wl-Auto H Division 7 8 1 2 8 3 2 Nar 9 7 8 7