Home » Ask & Discuss » Board Exams - CBSE, ICSE, State Boards » Computer Science « Back to Discussion

Computer Science

New kid on the Block

Joined:	3 Mar 2010
Post:	6

3 Mar 2010 22:41:06 IST

0 People liked this

231

ms office

None

ms office

Share this article on:

Comments (5)

surakarapu. swapna

New kid on the Block

Joined: 3 Mar 2010

Posts: 6

3 Mar 2010 22:41:53 IST

Like 0 people liked this

ms office

surakarapu. swapna

New kid on the Block

Joined: 3 Mar 2010

Posts: 6

3 Mar 2010 22:42:56 IST

Like 0 people liked this

interview questions

surakarapu. swapna

New kid on the Block

Joined: 3 Mar 2010

Posts: 6

3 Mar 2010 22:43:48 IST

Like 0 people liked this

what is a excel? why we are use excel?

siDDhESwaR MuKhErjEE

Blazing goIITian

Joined: 15 Nov 2009

Posts: 608

7 Mar 2010 11:04:53 IST

Like 0 people liked this

excel is used for making various charts and tables

edison

Forum Expert

Joined: 19 Oct 2006

Posts: 7449

25 Feb 2011 16:45:57 IST

Like 0 people liked this

Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.

When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows or columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

The intersection point between a column and a row is a small rectangular box known as a cell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell reference or address to identify it.

The cell reference is a combination of the column letter and the row number such as A3, B6, AA345.

Data Types, Formulas, and Functions

The types of data that a cell can hold include numbers, text or formulas. Just as in math class, formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions.

Excel and Financial Data

Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include:

Performing basic mathematical operations such as summing columns and rows of figures.
Finding values such as profit or loss.
Calculating repayment plans for loans or mortgages.
Finding the average, maximum, or minimum values in a specified range of data.

Excel's Other Uses

Other common operations that Excel can be used for include:

graphing or charting data to assist users in identifying data trends.
sorting and filtering data to find specific information.

The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.

Quick Reply

Reply

	Some HTML allowed.
	Keep your comments above the belt or risk having them deleted.
	Signup for a avatar to have your pictures show up by your comment
	If Members see a thread that violates the Posting Rules, bring it to the attention of the Moderator Team