Spreadsheet
The word "spreadsheet" came from "spread" in its sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large one. The compound word "spread-sheet" came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.
A spreadsheet is a computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid consisting of rows and columns.
Introduction
Microsoft Excel is an excellent program for organizing, formatting, and calculating numeric data. Excel displays data in a row-and-column format, with gridlines between the rows and columns, similar to accounting ledger books or graph paper. Consequently, Excel is well suited for working with numeric data for accounting, scientific research, statistical recording, and any other situation that can benefit from organizing data in a table- format. e.g. Teachers often record student grade information in Excel.
Excel run by using any of three methods that use to run Microsoft Word.
When you start Excel, a blank workbook, titled Book1, opens by default.
Worksheets
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources.
The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet.
Terms
Cell: The intersection of a column and row. Information is stored in cells.
Cell References: The address, consisting of the column and row IDs, of a specific cell. The current cell location is displayed in the upper left corner of the worksheet.
Column: A vertical group of cells within a worksheet. Total no of columns are 16,384.
Formula: A self made method of calculation is called formula.
Function: A pre-defined method of calculation is called function.
Range: A group of cells. Ranges can be selected by clicking and dragging over the cells.
Row: A horizontal group of cells within a worksheet. Total no of rows are 1,048,576.
Value: A number that can be used in an Excel calculation.
Workbook: A collection of worksheets contained within a single file.
EmoticonEmoticon