5th Class Computers Microsoft Excel Working With Spread Sheet 2013

Working With Spread Sheet 2013

Category : 5th Class

Working With Spread Sheet 2013



Microsoft Excel provides a spreadsheet is essentially a matrix of rows and columns. A 'spreadsheet is the computerized equivalent of a general ledger. Intersection of rows and columns is called cell. Each cell can hold text, a number of a mathematical formula. You -?: use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. A cell is referred to by column and row e.g., the upper left cell is cell Al. The cell right below that is A2 etc.


Microsoft Excel enables you to:


v  Format you data

v  Organize your data by sorting it.

v  Name ranges of data and use the range names in formulas and navigation for automatic updating.

v  Generate charts and graphs illustration your data.

v  Automate and customize procedures by using macros.





Starting Excel 2013 in Windows 10


v  Click on Windows button at the bottom left of the screen

v  Select Microsoft Office 2013.

v  Select Excel 2013 as shown in the figure.


Excel Toolbars


v  Title bar: Displays the title of the workbook you are currently in.

v  Menu bar: Group or collection of different toolbars which are used for specific or particular use.

v  Formatting Toolbar: Used for different formatting styles.

v  Standard Toolbar: This toolbar usually appears at the above of the menu bar and just right of the title bar. This toolbar contains short cuts of some of the most frequently used commands from the menu bar.

v  Status bar: At the bottom of the window is the status bar. This bar displays information about your document, such as if you entering some data or text in the cell, "Enter" option will display in the status bar.

v  Worksheet Tabs: Show the worksheet or chart names, By default new files haveone worksheet.

v  Scroll bars: Navigates to different areas of the active worksheet, located on the right and bottom of the worksheet.


Inserting Column/Rows


v  Click Home menu.

v  Click Insert option under Home tab and select insert sheet rows/columns options.


Deleting column


v  Move the mouse pointer to column or row header and select the entire column or row.

v  Click delete option under home tab and select delete sheet columns or delete sheet rows options.


Deleting Rows/Columns Contents


v  Select the row/columns content which your desire to delete.

v  Press Delete button to remove the content of row/column.


Data Selection


Use the Mouse/Keyboard to select (highlight) cells, rows and columns of data:


v  Single clicking on the column label will highlight the whole column.

v  Single clicking on the row label will highlight the whole row.

v  Clicking and dragging across several row or column labels will highlight several rows and columns respectively.

v  Clicking and dragging across a group of cells will highlight the contiguous groups.

v  Single clicking on one cell, pressing the F8 key (once) or holding down the shift key and then using the arrow keys to select the contiguous group will also highlight them.

v  With the F8 key, you must press F8 key once again or press the Escape key once to escape from the highlighting.

v  Non contiguous cells can be highlighted by holding down the Ctrl key and using the mouse to single click the desired cells.

v  Clicking on the gray box where the row labels and column labels intersect (top left corner of worksheet) will highlight the whole worksheet.

v  Some other shortcuts for selecting cells include:




Ctrl + Spacebar

Highlight the entire column

Shift + Spacebar

Highlight the entire row

Ctrl + A

Highlight the entire worksheet


Cut. Copy and Paste

The cut, copy and paste editing tools are available in microsoft excel.


Cut, Copy and Paste by using the drag and drop method:


v  Select the cells you desire to move.

v  Point to an outside border of the cell.

v  Click and drag the cell to the new location.


Write the drag-and-drop method, the data is removed from its original location and overwrites the contents in the destination location.


Selecting a Range

A range refers to a group of adjacent or contiguous cells. A range may be small as a single cell or as large as the entire worksheet.


To Select


A rang

Drag until you select the entire range. Alternatively A range click the first cell in the range, press and hold shift and then click the last cell in the range.

An entire column

Click the column heading

An entire row

Click the row heading.

Current range containing data

Click select all or press Ctrl + A twice.

Non adjacent range

Select the first range, press and hold, Ctrl, and then Non adjacent rang



Some Number Format in Excel


Format style 



Numbers are shown as integers (e.g. 12S45), decimal fraction (e.g. 1234.5) or in scientific natation (e.g. 1.23E +10).


A number with or without the 1000 separator (e.g. comma) and with Number any number of decimal places. Negative numbers can be displayed with parentheses and/or red.


A number with the 1,000 separator and an optional dollar sign (which is placed immediately to the left of the number). Negative values are preceded by a minus sign or are displayed with parentheses or in red. Two decimal places display by default


The data in different ways, such as long date (March 18, 2017) or short date (3/18/17 or 18-Mar-17).


The data left aligned by default, is useful for numerical values that have leading zeros and should be treated as text, such as postal codes or phone numbers. Apply text format before typing a leading zero so that the zero displays in the cell.


Other Topics

You need to login to perform this action.
You will be redirected in 3 sec spinner