RRK COMPUTER
EDUCTIONS
Excel
Home |insert |draw |Design|Layout|Reference|Mailing|Review|
View
HOME
Clipboard -cut|paste|copy
Ctrl +x,v,c
Font -bold|italice|underline
Ctrl +b,I,u
Alignments
–left-Alt+H&AL
RIGHT-ALT+H&AR
CENTER—ALT+C&AC
TOP—ALT+H&
AT
MID-ALT+H&AM
BOTTOM-ALT+H&
AB
Orientation
–rotate the text
Ctrl +1
Increase
indent->>>>>
Decrease
indent--<<<<<
Merge center
–ALT+H&MC
Warp
text-ALT+H&W
Current
style-Ctrl+Shift+$
PERCENTAGE
STYLES-CTRL+SHIFT+%
COMMA STYLES-4700-47,000.00
CTRL +SHIFT+!
INCREASE
DECIMAL-.00>
DECREASE
DECIMAL-.00<
GENERAL-USED FOR
CLEAR THE ALL STYLES
DATE-SORT DATE
LONG DATE
TIME-SET TIME FORMAT
<12-AM
>12-PM
011
0022
000111
STEP TO USE HOW TO
WRITE THIS NUMBER
AREA SELECT- CTRL+1-
NUMBER -TEXT- OK
>11 DIGIT-981155962340—9.81156E+4
HOW TO WRITE FOLLOW
THIS STEP
AREA SELECT
-CTRL6+1-NUMBER-CUSTOM-0-OK
CELL STYLES-USED
FILL THE COLOR TO SEVERAL STYLES
FORMAT AS TABLE-USED
FOR ARRANGE THE FORMAT TO SEVERAL DESIGN
CONDITIONAL
FROMATINGS-USED FOR SET THE COLOR CONDITIONS INTO FORMAT
7 CONDITIONS
GRETER THAN >
LESS THAN <
BETWEEN—
EQUAL TO=
TEXT THAT COMMENTS
(A-Z)
A DATE OCCURING
DUPLICATE VALUE
INSERT-INSERT
ROW-SHIFT+SPACE&CTRL++
INSERT
COLUMN-SHIFT+SPACE&CTRL+
INSERT SHEET-SHIFT+F11
DELETE-DELETE
ROW-SHIFT+SPACE&CTRL+-
DELETE
COLUMN-SHIFT+SPACE&CTRL+-
DELETE SHEET-ALT+H & DS
AUTOSUM-ALT+==
SORT
A
Z
&
Z
A
ASCENDING AND DESCENDING
CLEAR-CLEAR ALL
CLEAR FORMAT
CLEAR CONTENTS
CLEAR COMMENTS(DATA)
CTRL+A &CTRL+-
Filter -used for
filter the data or record
(ctrl+shift+l&alt+down
arrow,space for select option&enter)
Find -find any data
form the record(ctrl+f)
Replace -replace any
data from the record(ctrl+H)
COUNT the any
particular data or value in database
Delete the any
particular data in database
Select -used for
select all data(Ctrl+A)
Go to-used for go to
any (Ctrl+G)
Formula
Comments(notes)
Contents (data/text)
Blank area
Transpose-arrange
the data from horizontal to vertical direction
arrange the data
from vertical to horizontal direction
procedure -data
select-copy-right click of mouse-paste special-click on transpose-ok
(CTRL+A---CTRL+C---PRESS
APPLICATION KEY-SSE-ENTER)
SKIP BLANKS-USED FOR
PASTE THE DATA OR RECORDS IN BLANK CELLS ONLY
PROCEDURE-
DATA
SELECT-COPY-RIGHT CLICK OF MOUSE-PASTE SPECIAL-CLICK ON SKIP BLANKS-OK
(CTRL+A—CTRL+C---PRESS
APPLICATION KEY-SSB-ENTER)
THANKS
