What is chart?

The graphical representation of numerical data is known as Chart or Graph. It makes easy to compare and to understand the numerical data. A chart is created with a range of data stored into the worksheet cells.

What is function?

To built in tool predefined formula that is used to perform specific calculations and return a value in a call where it is written is called function. The function is written in a cell of worksheet as formula. Every function returns a value and may accept one or more arguments. Arguments are passed to the functions within parenthesis.

What is absolute referencing?

The cell references used in formula that do not change when you copy formula to another cell in the worksheet are called the absolute references. An absolute reference is specified in the formula by using $(Dollar) sign before column letter and row number that used as cell reference in formula.

What is relative referencing ?

Calling a cell with the reference of its address (such as A1) is called relative referencing. When a formula contains relative referencing and it is copies from one cell to another, the spreadsheet does not create an exact copy of the formula.

What is formula?

A formula is a mathematical expression that is combination of numbers, 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, display the result of formula only.

What is active and passive cell?

There are two states of a cell, i.e. active and passive. The currently selected cell where data can be entered or edited is called the active cell. When another cell is selected or cell pointer is moved to another cell, that cell becomes the active cell. Actually, at a time a single is active and other cells of worksheet are inactive. The inactive cells are known as passive cells.

What is Microsoft Excel?

Microsoft Excel is most popular spreadsheet program that allows you to perform various calculations on numeric data, creating charts etc. it also allows you to format the text in cells and printing text etc.

What is workbook?

In MS-Excel the document or file in which data is permanently stored on the disk is called workbook. It is a collection of worksheets.

What is a worksheet?

A spreadsheet program used worksheets and workbooks. A worksheet is divided into a grid of columns and rows. In excel, a worksheet consists of 256 columns and 65536 rows. The columns are labeled with letters A,B,C…etc and rows are labeled with numbers 1,2,3 etc.

What is a cell?

The spreadsheet is a grid of rows and columns the columns are labeled with letters A,B,C….. and rows are labeled with numbers 1,2,3 ete. The intersection of row and column forms a cell.

What is spreadsheet program?

A spreadsheet program is a software tool for entering, calculating, manipulating and analyzing sets of numbers. It can hold large amount of data arranged in rows and columns just like a table. Ms-Excel is an example of spreadsheet program.