Basic it tools project of Delhi university

basic it tools project

1. Basic IT Tools Presented by Garv Yadav 23/50165 Harshavardhan 23/50164 Garvit 23/501 B.com (Hons)

2. Introduction to Spreadsheets Implementing file level security and protecting data within the worksheet; Understanding absolute, relative and mixed referencing in formulas, referencing cells in other worksheets and workbooks, correcting common formula errors, working with inbuilt function categories like mathematical, statistical, text, lookup, information, logical, database, date and time and basic financial function s.

3. Protect a worksheet To protect a worksheet, you can: Select Review > Manage Protection Select Protect sheet To require a password to edit a range, select Range password To control the ability to edit protections for the entire sheet, select Sheet protection password Implementing file level security and protecting data within the worksheet

4. Understanding absolute, relative and mixed referencing in formulas

5. Absolute Referencing An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row Y can use the F4 function key to switch between relative, absolute, and mixed references

6. Mixed Referencing $” sign is used for Absolute Referencing Which we want is fixed

7. referencing cells in other worksheets and workbooks, Click the cell where you want to enter the formula Type an equal sign (=) Type the name of the worksheet to be referenced, followed by an exclamation point (!) Select the cell or range of cells to be referenced Click on view Switch windows for other saved workbooks reference

8. Here are some ways to reference cells in other workbooks in Excel: Create a workbook link In the cell where you want the reference, type an equal sign (=), then switch to the source workbook and click the worksheet with the cells you want to link. Press F3, select the name to link to, and press Enter. Create a 3-D referenc e In the cell where you want the function, type an equal sign (=), then the name of the function, and an opening parenthesis. Click the tab for the first worksheet, then hold down Shift and click the tab for the last worksheet. Select the cells to reference, complete the formula, and press Enter. Use copy and paste link In the source file, highlight the cells to reference, right-click, and select "Copy". In the destination file, click the cell to add the reference to, right-click, and click the "Paste link" icon.

9. correcting common formula errors

10. Correct common formula errors one by one Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog box is not displayed, then select Formulas > Formula Auditing > Error Checking