1st Year Computer Chapter 9 Notes

• What is Spreadsheet?
• List some features of the spreadsheet program.
• What is a Worksheet?
• What is a Workbook?
• What is a Cell? What is an Active Cell?
• What is a Column Header?
• What is a Row Header?
• What is the use of the formula bar in the Excel interface?
• What is meant by cell formatting?
• What is the formula?
• What is the cell address?
• What is Relative Referencing?
• What is Absolute Referencing?
• What is a chart?
• List some functions of a spreadsheet.
• Define functions in Excel.
• Write the formula for calculating the average of cells B2 and B3.
• Write some applications of spreadsheets.
• What is formula: A formula is a mathematical expression that is a combination of numbers, constants, cell addresses (or cell references) and arithmetic operators. In Excel, mostly the formula is build by using cell references along with arithmetic operators. Formula is entered in the worksheet cell and must begin with an equal sign "=" The cell in which formula is written, displays the result of formula only.
• People work with numbers every day. Corporations track profits and losses; economists generate graphs of growth of the country's economy; statisticians calculate probability of crashing the market; and women manage their household budgets. To perform all these tasks, people use spreadsheet programs. A Spreadsheet program is a software tool for entering, calculating, manipulating and analyzing sets of numbers. The specialty of spreadsheet software is working with numbers. It can hold large amount of data arranged in rows and columns. It can manipulate numbers and present information in numerous ways. Like Word Processors, the Spreadsheet software also varies significantly e.g. LOTUS 123, MS Excel etc. But all of them have the following basic features:
• Grid of Rows and Columns: The spreadsheet is a grid of rows and columns. Each row is assigned a number and each column a letter. The intersection of a row and a column forms a cell. Each cell has a reference number that is formed by combining the column number and row number c.g. Al, G18 etc. A cell contains labels or values. A label is a text entry such as "Gross Salary" whereas a value can be a number, a date, a formula or a formula's result. Formulas: Formulas are used to express mathematical relationships between cells. Functions: Functions are used to perform certain tasks Commands: Commands are used to manipulate the worksheet or its contents Text Manipulation: Some simple text manipulation can also be performed. Print: Allows you to send a document to a printer to get a hardcopy.
• Starting to Use Spreadsheet: To understand the functionality of spreadsheet software you should be familiar with its interface. The interface represents the way through which you can interact with the spreadsheet software.