Current Affairs 5th Class

Category : 5th Class

Working With Spread Sheet 2013

Introduction

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:

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.

Some Number Format in Excel