Ms excel

Ms excel

Ms excel is special purpose application software.
Ms excel is spread sheet package.
Used in Account, share market, budget, and
financial report.
Excel file is called worksheet.
File extension of ms excel file is .xls

Spreadsheet - page of ms excel
Worksheet - collection of spread sheet
Work book - Collection of work sheet

Row - consist record
Colum - consist data


Caption - field name
Field (COLUM) - contain data as field name .
Record (ROW) - contain information.

Table
Table consist row and column
Table is a collection of record
Table Hold all information of data base

Cell
cell is intersection of row and Colum
Active cell – highlighted cell , show black out line
Active cell contents display on formula bar

Cell address - letter of Colum and number of row
of intersecting cell makes cell address
A1


A1 is a valid cell address.

Range - set of two or more cell
Merge - to add two cell

Referencing - accessing data from different spread
sheet
Transpose – change row data into Colum and
Colum data into row.
Gridline - row and Colum lines of table.

Formula -
Formula - all formula in excel start with =
sign.
Formula bar display the contents of active
cell.
Function –
Function is predefined formula.


Nested function - Function in other function is
called
nested function.

Example of function
Sum (d8:d12)
Financial – p.m.t. p.v.
Mathematical - sum a.b.s. avg max
logical IF AND

Numeric entries - number formula
Data validation - for valid data entry
Sort -to rearrange items


Data type
Alpha abcd
Numeric 1234
Int
Char
String
Variable
Constant

Shortcut
Shift + row to select the entire row
F2 to edit selected cell



F7 spell and grammar checking
F11 to create chart from selected cell.

There are 1048576 rows and 16384 Colum in ms
excel 2010.