ICT oxford school Azuero

  Sort a Table To sort by Last Name first and Sales second, execute the following steps. 1. Click the arrow next to Sales and click Sort Smallest to Largest. 2. Click the arrow next to Last Name and click Sort A to Z. Result. Filter a Table To filter a table, execute the following steps. 1. Click the arrow next to Country and only check USA. Result.

  Charts A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy. Create a Chart To create a line chart, execute the following steps. 1. Select the range A1:D7. 2. On the Insert tab, in the Charts group, click the Line symbol. 3. Click Line with Markers. Result: Note: enter a title by clicking on Chart Title. For example, Wildlife Population. Change Chart Type You can easily change to a different type of chart at any time. 1. Select the chart. 2. On the Design tab, in the Type group, click Change Chart Type. 3. On the left side, click Column. 4. Click OK. Result: ...

  Statistical Functions   This chapter gives an overview of some very useful statistical functions in Excel . Average To calculate the average of a group of numbers, use the AVERAGE function. Averageif To average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros. Median To find the median (or middle number), use the MEDIAN function. Check: Mode To find the most frequently occurring number, use the MODE function. Standard Deviation To calculate the standard deviation, use the STEDV function. Note: standard deviation is a number that tells you how far numbers are from their mean.  Min To find the minimum value, use the MIN function. Max To find the maximum value, use the MAX function. Large To find the third largest number, use the following LARGE function. Check: Small To find the second smallest number, use the following SMALL function. Check:...