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: ...

  Use   data validation   in Excel to make sure that users enter certain values into a cell. Data Validation Example In this example, we restrict users to enter a whole number between 0 and 10. You are a Doctor and you need to ask to your patient: Create Data Validation Rule To create the  data validation rule , execute the following steps. 1. Select cell C2. 2. On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab: 3. In the Allow list, click Whole number. 4. In the Data list, click between. 5. Enter the Minimum and Maximum values. Input Message Input messages appear when the user selects the cell and tell the user what to enter. On the Input Message tab: 1. Check 'Show input message when cell is selected'. 2. Enter a title. 3. Enter an input message. Error Alert If users ignore the input message and enter a number that is not valid, you can show them an error alert. On the Error Alert tab: 1. Check 'Show error alert after invalid data...

  If The IF function is one of the most used functions in Excel . This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below. Explanation: if the price is greater than 500, the IF function returns High, else it returns Low. 1b. The following IF function produces the exact same result. Note: you can use the following comparison operators : = (equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to) and <> (not equal to). 2. Always enclose text in double quotation marks. And/Or Criteria Use the IF function in combinatio...

If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail.  And The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. 1. For example, take a look at the AND function in cell D2 below. Explanation: the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, else it returns FALSE. Or The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false. 1. For example, take a look at the OR function in cell D2 below. Explanation: the OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE.  Not The NOT function changes TRUE to FALSE, and FA...

 Count and Sum Functions The most used functions in Excel are the functions that count and sum . You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells based on one criteria (for example, greater than 9), use the following COUNTIF function. Note: visit our page about the COUNTIF function for many more examples. Countifs To count cells based on multiple criteria (for example, green and greater than 9), use the following COUNTIFS function. Sum To sum a range of cells, use the SUM function. Note: visit our page about the SUM function for many more examples. Sumif To sum cells based on one criteria (for example, greater than 9), use the following SUMIF function (two arguments). To sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments, last argument is the range to sum). Note: visit our pag...