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