Page 50 - COMPUTER

 SHORTCUT KEYS OF MS EXCEL 

1) Ctrl+Shift+Spacebar:- To Select All Rows & Columns
2) Ctrl+ Right Arrow:- Last Cell Of The Row
3) Ctrl+Left Arrow:- First Cell Of The Row
4) Ctrl+Up Arrow:- First Cell Of The Column
5) Ctrl+Down Arrow:- Last Cell Of The Column
6) Ctrl + Home :- First Cell Of The Worksheet
7) Ctrl+ End :- Last Cell Of The Worksheet
8) Page Up :- Up On The Screen
9) Page Down :- Down On The Screen
10) Alt+ Page Down:- Right On The Screen
11) Alt+Page Up :-Left On The Screen
12) Ctrl+ Page Up :- Next Sheet
13) Ctrl+ Page Down :- Previous Sheet
14) Shift+ Spacebar :- To Select One Row
15) Ctrl+ Spacebar :- To Select One Column
16) Ctrl+; :- To Enter Date
17) Ctrl+Shift+: :- To Enter Time

 USE OF SIMPLE FUNCTIONS 

➢ =Sum( Number1,Number2....) :- It Returns The Sum Of The Range
Example: - =Sum(C5:C10)
=Sum(A2,A5,A7)

➢ Note:- :(Colon) Used For Range Continuous
, (Comma) Used For Particular Cell

➢ =Average(Number1,Number2...):- It Returns Average Of The Number In The
Range
Example :- =Average (C5:C10)
= Average (A2,A5,A7)
➢ Maximum (Max) :- It Return The Largest Value In A Set Of Value

Example :- =Max(C5:C10)
= Max(A2,A5,A7)

➢ Minimum(Min) :- It Return The Smallest Number In A Set Of Values
Example :-= Min(C5:C10)
=Min(A2,A5,A7)

49