Digital Learning

Sunday, May 3, 2020

Data- Input, Edit, Select and Modifying in MS Excel:

Enter Data in a Worksheet:
Data can be entered in a cell by selecting any cell or placing the cursor in the cell. When you will select a cell, the boundary of the cell will become bold and thick. Now you type the text or data in the cell. You can move around the active cell i.e. up, down, left and right by using arrows keys. When you will select a cell, it will be display in the formula bar so that you can also type text in the formula bar and typed text also display in the selected cell.

Editing Data in Worksheet:
After typing the text in a Worksheet you can make changes in the text. Changing in the text also called text editing. There are some steps for editing the data.
1.     Select the cell that you want to edit. Now type the new data, the new data will be entered in place of old data.
2.     To change a portion of a data, move mouse pointer at the position and double click. Now you can enter new portion of data.
3.     Selected cell data also appears in the formula bar so editing of data can also be done in the formula bar.

 Selecting a Range of Cells:
·         A range or group of cells can be selected by dragging the mouse over them holding down the left button of mouse.
·         Keyboard can also be used to select a range of cells.
Place the cursor on the border cell of the range. Press the shift key and holding this key move the cursor up /down using arrow keys over the cells to select them.
·         To select all cells of a worksheet, use shortcut key Carla.
·         To select non-adjacent cell ranges, select the first range of cells, and then hold down CTRL key and select the other cells or ranges.
·         You can select entire column by clicking on the column heading.
·         You can select entire row by clicking on the row heading.

Modifying Data in a Worksheet:
1.    Undo/Redo: Undo option is used to undone the last action and Redo shows the last action.
2.   Cut: It will place the selected data on the clipboard and delete from old location. You can use shortcut key for cut i.e. Ctrl+X.
3.     Copy: To copy the data, select the range of cells. Now click on copy option under clipboard group. Now place the cursor or mouse pointer at the desired location on worksheet and click on Paste option under clipboard group. User can use shortcut key for copy a text i.e. Ctrl+C.
4.     Paste: Copied data stored in clipboard group under Home tab. To be paste this data click on desired location or move mouse pointer. Now click on Paste option on the clipboard group. User can also use shortcut keys for paste copied data i.e. Ctrl+V.
5.     Find: This option helps us to find any text, number and formula in a worksheet. Find option is available in the Editing group under Home tab in Excel.
6.     Find and Replace: This option is very useful. It is available in the editing group of Home tab. You can click on replace option on the Editing group, a dialog box will appear. Enter the data you want to find, in case you want to replace this data, click on Replace button then another dialog box will appear; now you can type another data that you want to replace.

7.     AutoFill: This option in MS Excel allows us to fill a range of cells in a row or column with a particular series of values.Type 1 in cell A1. Select it and drag the small black cross sign at the bottom right corner of the cell downwards it as you want. You will see that all the range cells will be filled with 1.Type 1 in cell A1 and 2 in A2. Select A1 and A2 and drag the cross sign downwards, the selected range of cells will be filled with values 1, 2, 3, 4, …….and so on. If you type 1 in A1 and 3 in A2 and then drag the fill handle (black cross sign) downwards, the selected range of cells will be filled with values 1, 3, 5, 7, 9 …….. So AutoFill automatically checks the relation between the first two values and fills up the reaming of the cells in range with appropriate values.

Cells Group:
Cells group is available under Home tab in MS Excel. This group consists of Insert, Delete and Format option. Insert option also includes Insert Cells, Insert Sheet Rows, Insert Sheet Columns and Insert Sheets. Delete option includes Delete Cells, Delete Sheet Rows, Delete Sheet Columns and Delete Sheets. Format option includes Row height, Column Width, hide/unhide, Rename Sheet etc.
If we right click on any cell in a sheet, a drop-down list will appear. This list have some options like Cut, Copy, Paste, Insert, Delete, Clear Contents, Filter, Sort, Insert comments etc.
1.     Insert Cells: This option is used to insert a cell in the sheet
2.     Insert Sheet Rows: This option is used to insert a sheet row.
3.     Insert Sheet Column: This option is used to insert sheet column.
4.     Insert Sheet: This option is used to insert a sheet.
5.     Delete Cells: This option is used to delete a cell.
6.     Delete Sheet Rows: This option is used to delete a row from a excel sheet.
7.     Delete Sheet Column: This option is used to delete a sheet column.
8.     Delete Sheet: This option is used to delete entire sheet from workbook.
9.     Row Height: This option is used to increase or decrease row height.
10.  Column Width: This option is used to increase or decrease the column width.

Different tabs of MS Excel are:
Home Tab: Home Tab has the following groups:
i.                    Clipboard,
ii.                 font,
iii.               Alignment,
iv.               Styles,
v.                 Number,
vi.               Cells, and
vii.            Editing.
Insert Tab: Insert Tab has the following groups:
i.                   Table,
ii.                Illustration,
iii.             Charts,
iv.              Links, and
v.                 Text.
Page Layout tab: Page Layout Tab has the following groups:
                                     i.                  Themes,
                                     ii.                 Page setup,
                                     iii.               Scale to fit,
                                     iv.                Sheet options and
                                      v.                 Arrange.
Formula: Formula Tab has the following groups:
                                     i.                  Function library,
                                     ii.                Defined names,
                                     iii.              Formula Auditing and
                                     iv.               Calculation.
Data:  Data Tab has the following groups:
                                     i.                  Get External data,
                                     ii.                Connections, Sort & Filter,
                                     iii.             Data tools and
                                     iv.              Outline.
Review: Review Tab has the following groups:
                                     i.                  Proofing,
                                     ii.                Comments and
                                     iii.              Changes.
View Tab: View Tab has the following groups:
                                     i.                 Workbook views,
                                     ii.               Show/hide,
                                     iii.             Zoom,
                                     iv.             Window and
                                      v.              Macros.
    Some other links:

1 comment:

  1. Real instructive and excellent complex body part of written content , now that’s user friendly (:. spreadsheet guru

    ReplyDelete