Spreadsheets...Are programmes used toperform mathematical, statistical, financial and analytically related tasks. They attempt to simulatereal life models of either a statistical financial or mathematical models like Budgeting, Break-Even Analysis, Profitand Loss Statements, Balance Sheets and Forecasting etc.Within the Spreadsheet industry Microsoft Excel stands out above other competitors like Lotus 123, Quattro Pro,Microsoft Works, Multi Plan etc.Terms of Reference.Workbook:This is a term used to refer to a single file within the excel spreadsheet. Typically, all unsaved files inMicrosoft Excel will be given a generic name, e.g. Book1, Book2, Book3 ... Book n where n is a number.Worksheet:This is the working area within a workbook. It consists of a grid of rows and columns; the rows areidentified by numbers while the columns with alphabetical letters. Generally Microsoft Excel comes with aminimum of three Worksheets, however users have the ability to add and remove any existing ones.Cell:The point of intersection between a column and a row forms a cell; a cell is the actual data entry positionwithin the work sheet. It is uniquely identified by the coordinates of its column and row headings e.g. thefirst cell is termed as A1 (column A, row 1) the contents of a cell can be either of the following:1.Text, Narratives or Labels. e.g. EXPENSES, JAN, PROFITS/LOSS etc.2.Values, Numbers e.g.145, 45,000, $ 5,600 etc.3.Formulas e.g. =A2+A3, =B3*C5, =SUM(A2:A9)NB:All formulas are preceded by the Equal Sign (=)Range:This is a term that refers to a group of cells selected together. It is formed by the coordinates of the first cell(top, left) address within the selection, separated by a full colon (:), ending with the address of the last cellwithin the selection (bottom, right).NB:Ranges are only used within a formula. e.g. =SUM(B3:B9), =MAX(B3:F9), =AVERAGE(B3:G14) etc.Workbook/Worksheet ManagementAs earlier described, the worksheet provides the actual working area within the Workbook. It thus follows that theuser will make use of them every time a workbook is accessed. The following properties can be performed toworksheet:-Selection of WorksheetsTo select a single worksheet, simply click on the tab name. However for more than one sheet, click the first one, foradditional ones, hold down the CTRL key and click any more additional sheets at random. To deselect them, repeatthe procedure with CTRL key held down. For a consecutive group use the SHIFT key instead.Creation of WorksheetsTo create a new worksheet, from the insert menu, choose worksheetDeletion of WorksheetsSelect the worksheet(s) of interest, and from the edit menu, choose the delete sheet command NOT delete.Confirm appropriately.NB:the procedure is none reversible
