EXCEL NOTES

Name Box	Use To Cell Address
Cell Address	Alphabet N Numeric Like B15
By Deault Font	Calibari
Size	11
By Deafult Sheet	3
By Deafault Sheet Name	Sheet 1
File Name	Book 1
Text-right side	Number-
Active Cell	F2
Single Sheet	Worksheet
Multiple Sheets	Workbook
Max. Row	1048576
Max.Col	16384
Max Column Widht	0-255
Max Row Height	409 Points
Max Sheets	Limited By Available Memory
Hyperlink	66530
Zoom	10-400%
Undo	100 Times
Row Add	Above Slide
Column Add	Left Slide
Wrap Text	Move Next Line
Conditional Formatting	Formatting Using Condition
Insert Menu- Pivot Table And Chart	Summerize And Analysis Data
Page Layot
Print Area	Selected Area Printing
Scale	100% By Deafult
	10-400 %
WEBSOL	OLD GINNANI
7742306363	IA NOTES
Name Manger	Give Custom Name To Cell
DATA TAB
Get External Data	From Access
	From Web
	From Text
	From Other Source
DATA TOOLS
TEXT TO COLUMN	Convert Text Data Into Column
Remove Duplicate
Data Validation	Use To Validate Cell
	Like Number,Char,Date
Consolidate	Comabine Multiple Range From Cell
What If Analysis
Scenario Manger	Use To Create Different Scenario Manager
Goal Seek	Use To Find Future Value Of Any Cell
Data Table
VIEW TAB
Type of views	Normal
	Page Layot
	Page Break
	Custom View
	Full Screen
Freeze Panes	Use To Lock Or Freeze First Row /Column And Above From Selectio
Save Work Space
Error Shows
#####	Range
#NAME?	ERROR FORMULA
Terms In Excel
Auto Fill Options
Custom List
Cell Tip	Comments In Cell
Cell Reference	एक सेल के Data को दुसरे सेल या Sheet मे Refer करना
Relative Reference	Formula Is Changed When Copy Ex-A2:A5
Absulute Reference	Formula Is Not Changed When Copy F4 Key N $ Symbol Is Use Ex-$A$2+$A$5
Mixed Reference	Absulute+Relative Reference Ex-$A2
Function   Shift+F3	Predefined Method Like Sum Max Min
Forumla	User Defined Like A2/G2*100