mos 2010 study guide for microsoft phần 5

Chọn ô mà bạn muốn đặt trung bình. 2. Trên tab Formulas, trong nhóm Thư viện chức năng, nhấp vào chức năng khác nút, điểm để thống kê, và sau đó trong danh sách, nhấn AVERAGE. | 5 Applying Formulas and Functions 239 1. Select the cell in which you want to place the average. 2. On the Formulas tab in the Function Library group click the More Functions button point to Statistical and then in the list click AVERAGE. 3. In the Function Arguments box enter the cell range that you want to average and then click OK. To find the lowest value in a data range 1. Select the cell immediately below or to the right of the values you want to evaluate. 2. On the Formulas tab in the Function Library group click the AutoSum arrow and then in the list click Min. 3. Verify that the cell range displayed in the formula is correct and then press Enter. Or 1. Select the cell in which you want to place the minimum value. 2. On the Formulas tab in the Function Library group click the More Functions button point to Statistical and then in the list click MIN. 3. In the Function Arguments box enter the cell range you want to evaluate and then click OK. To find the highest value in a data range 1. Select the cell immediately below or to the right of the values you want to evaluate. 2. On the Formulas tab in the Function Library group click the AutoSum arrow and then in the list click Max. 3. Verify that the cell range displayed in the formula is correct and then press Enter. Or 1. Select the cell in which you want to place the maximum value. 2. On the Formulas tab in the Function Library group click the More Functions button point to Statistical and then in the list click MAX. 3. In the Function Arguments box enter the cell range you want to evaluate and then click OK. 240 Exam 77-882 Microsoft Excel 2010 Practice Tasks The practice files for these tasks are located in the Excel Objective5 practice file folder. If you want to save the results of the tasks save them in the same folder with My appended to the file name so that you don t overwrite the original practice file. On the Summary worksheet of the SummaryFormula workbook do the following o In cell B18 create a .