Microsoft Excel Introduction - Wisdom Lighter

Tuesday, 22 May 2018

Microsoft Excel Introduction


MS EXEL
Task#1
What is Cell?
A particular entity(field) in a work sheet is called cell. A box shape with particular row number and column number such as shown below

a cell consists of row and column, hence the selected cell have a column B and a row 4.Such Cell is called B4.

Task#2
What is Column?
A number of vertical cells in a sequence one after another is called a column such as shown below

*   Short Cut key to Add a New Column is Ctrl+"+" or Right click on the column and select Insert, then choose the options where you have to add a New Column.
*   Short Cut key to Delete a Column is Ctrl+"-'  or Right Click on the selected column and select Delete option.
*   For selection of  a hole Column with the Selected Cell, the Short Cut key is Ctrl+<Space>.
*   For Multiple Selection of  Columns, the Short Cut key is Shift+ ArrowKeys.
Task#3
What is Row?
A number of Horizontal Sequential Cells one after another is called Row such as given below

*   For Addition of New row the short cut key is Ctrl+"+" or right click on the selected row and select Insert option and select the location where you wants to add a new row.
*   For Deletion of a Row, the short cut key is Ctrl+"-" or right click on the selected row and choose the Delete option.
*   For Entire Selection of row, the short cut key is Shift+<Space>.
*   For Multiple Selection of Rows, the short cut key is Shift+Arrow keys.

Task#4
What is Range?
Collection of cells  is called Range. For further explanation the Screen Shot is pasted given below


Task#5
How to insert a Value?






No comments:
Write comments