Excel:
- Excel worksheet is a collection of cells where we keep and manipulate the data.
- In Excel we have sheets, by default when we open Excel it will open sheet-1 for user.
- An Excel sheet will have the rows and columns with row numbers and column names to select cell in a systematic manners with out confusion.
Select a worksheet:
- Select a worksheet at the bottom. Name of the sheet appears on its sheet tab.
- Right-click on the sheet name and select rename to change the name of the sheet.
Insert worksheet:
- We can insert as many worksheets as we want.
- To insert worksheet right-click on the sheet and select insert option and select worksheet and click ok.
- To delete a worksheet right-click on the sheet you want to delete and select delete option.
Copy of worksheet:
- If we want same data but different values to a worksheet with the previous one then we go for copying the sheet because it is easy to copy than entering new again.
- To copy the sheet right-click on the sheet and select copy sheet.
Functions:
- We have the predefined functions in the Excel to use them in the particular cell.
- Select the cell and select function at the top of the sheet fx. Select desired function and range of rows or columns want to use the function.
- We can add a hyperlink to the cell with a value or name.
- Finally to save the sheet click file at the top and select save option. Save with a preferred name.
Notes:
