12 Apply Comma Style to the monetary values for the 4.000 range E6: K16.
13 Underline the last employee’ s monetary values, and
6.000 then use the Format Cells dialog box to apply Double Accounting Underline for the totals.
14 Insert appropriate functions to calculate the average,
10.000 highest, and lowest values in the Summary Statistics area( range I21: K23).
15 You want to determine the number( frequency) of
3.000 employees who worked less than 20 hours, between 20 and 29 hours, between 30 and 40 hours, and over 40 hours. Cells J28: J31 list the ranges. You need to translate this range into correct values for the Bin column in cells I28: I30 and then enter the FREQUENCY function in the range K28: K31. The functions should identify one employee who worked between 0 and 19 hours and six employees who worked more than 40 hours. Use Help to learn about the FREQUENCY function, download the sample practice data to learn