ICT oxford school Azuero

  Drop-down List   Drop-down lists  in  Excel  are helpful if you want to be sure that users select an item from a list, instead of typing their own values. Create a Drop-down List To create a drop-down list in Excel, execute the following steps. 1. On the second sheet, type the items you want to appear in the drop-down list. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. To achieve this, right click on the sheet tab of Sheet2 and click on Hide. 2. On the first sheet, select cell B1. 3. On the Data tab, in the Data Tools group, click Data Validation. The 'Data Validation' dialog box appears. 4. In the Allow box, click List. 5. Click in the Source box and select the range A1:A3 on Sheet2. 6. Click OK. Result: Note: to copy/paste a drop-down list, select the cell with the drop-down list and press CTRL + c, select another cell and press CTRL + v. 7. You can also type the items directly into the Source box, instead of using a range...

  Budget Limit   This example teaches you how to use data validation to prevent users from exceeding a  budget limit . 1. Select the range B2:B8. Note: cell B10 contains a SUM function that calculates the sum of the range B2:B8. 2. On the Data tab, in the Data Tools group, click Data Validation. 3. In the Allow list, click Custom. 4. In the Formula box, enter the formula shown below and click OK. Explanation: the sum of the range B2:B8 may not exceed the budget limit of $100. Therefore, we apply data validation to the range B2:B8 (not cell B10!) because this is where the values are entered. Because we selected the range B2:B8 before we clicked on Data Validation,  Excel  automatically copies the formula to the other cells. Notice how we created an  absolute reference  ($B$2:$B$8) to fix this reference. 5. To check this, select cell B3 and click Data Validation. As you can see, this cell also contains the correct formula. 6. Enter the value 30 into cell...