EXCEL USEFULL COMMANDS

Ctrl+pageup/down	Switches between worksheet
Shift+f11	New sheet
F11	Chart on new sheet(column chart)
CTRL+SHIFT+&	Applies the outline border
CTRL+;	Enters the current date.
CTRL+SHIFT+:	Enters the current time.
CTRL+1	Displays the Format Cells dialog box.
CTRL+2	BOLD
CTRL+3	Italic
CTRL+4	Underline
CTRL+5	Strikethrough
CTRL+9	Hide row
Ctrl+0	Hide column
Ctrl+D	Fill down
Ctrl+L/t	Create table
Ctrl+R	Fill right
F2	Active cell
Shift+f2	Comment
Ctrl+spacebar	Select column
Shift+spacebar	Select row
Ctrl+shift+spacebar	Complete sheet
Ctrl+shift+ plus	Insert dialog box
Ctrl+-	Display delete
Ctrl+;	Current date
Ctrl+shift+:	Current time
Ctrl+shift+$	Currency format
Ctrl+shift+%	Percentage format
Ctrl+shift+#		Date format
Ctrl+shift+@		Time format
F11		Column chart on new sheet
Ctrl+’		Copy formula
Type of functions		One argument like =sqrt(25)
Two argument(=power(5,2)		Range like (=sum(a2:b2))
Comma =rank(a2,a2:a5)
Colon( : ) symbol for range a2:b2		Comma(,) for separator   a2,b2
If formula (total 3 statements)		1-condition 2.true 3.false
Pmt(for payments calculation )		Pv,nper,rate,fv
Rank-for rank
WEBSOL    IA EXAM 2018 EXCEL NOTES 77423606363		WEBSOL    IA EXAM 2018 EXCEL NOTES 77423606363