Topic Search

Custom Search

Monday, November 18, 2013

Type Lessons


EXERCISE-01
Note : Practise this exercise for 2 days . asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj asdfgf ;lkjhj  

EXERCISE-02
 ask had dad lad gas ass all sad lad jag hall fall flag slash glass flask flags dash glad flees salad shall hash shah

 EXERCISES - 3 & 4 1.
qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu

EXERCISE-03
Note: Practise this exercise for 2 days.

 qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu

EXERCISE-04

 qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj; qwertfa poiuyj;

 ate how ate how ate how ate how ate how ate how ate how ate how ate how ate how ate how ate how

EXERCISE-05

 ate how top tip off his for hat ore our ear the air old law fit ill awl did saw eye ago age ego paw hit art gap how low era try did you get got use day toe sky far see sea was yet owl shy dip

EXERCISE-06

 lead rate laws gold rent weak week poor task year your head that from with over type like rest else sell high sold gold does stop what part wait sure goes fair fare hold hole wish just good dark gear were wire area pure loud ship deer dear wide deaf help felt hour lake hate lest full fool last lost best rate only told fold cold show play fire hire hard look trip trap food list gist exit

 EXERCISE-07

these tasks after ahead right there light large right prior adopt adapt house rests sells field world lower stage stare sharp petty first order based party total rural other sorts argue power steel steal plead short jokes apply third shake reply ruled whole sheet greet great later speed total royal guard proud quiet quite agile legal silks jagged fails hedge kills deeds jaded dashed glide slights
 EXERCISE-08

 weaker weekly likely report people single rental higher should lowers design desire search really always growth threat powers assess future affair degree holder effort afford better latter hurdle series future
EXERCISE-09
healthy without already shelter rightly present through feature reshape serious holders dislike EXERCISE-10
suppose perhaps delight student squatter priority possible struggle research farther further equipped
EXERCISE -11 1.

zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn zxcvc .,mnbn

 EXERCISES - 12 to 21 1
inn and inn and inn and inn and inn and inn and inn and inn and inn and inn and inn and inn and

EXERCISE-12 inn and man one but own ten job men not net any van hen now ant cat can

EXERCISE-13
copy once knit five more born baby than rain made much home come many need plan been room find land them then seen very know vast snap nook over coal best make cool army from nine form farm firm gone deny meet meat lame soon time free ones

EXERCISE-14
 value creed alarm midst urban being force place which limit plans grain point stock major norms india under acute boast boost women needs blame court globe again vital above exact watch match catch patch snatch think charm round among alive drove miles range prove could exist about above

 EXERCISE-15

 mother minute wanted aiming varied answer nobody record except system former farmer beauty expand island almost family travel abroad person policy Indian market number census become cities needed rising costly masses openly cannot breach normal tender longer defend cradle nation office colour linked modern occurs social living fabric monger unless reason extent export plenty impact course severe global manage import

EXERCISE-16

 problem settled topmost gravity absence section society deprive privacy however indians confers violate himself enforce country inspire tragedy feeling oneness vitality several changes shrewd solicit comment average typical cluster arduous mention preface journey forever variety because expense million distant driving exhaust recover routine general adverse organic economy science poverty assumed radical obvious process achieve improve between pattern destiny umpteen bovine

EXERCISE-17

 majority standard approach alarming pavement appointed demanded suitable planning decision ministry practise conflict honestly cultures industry intimate content widening tensions casteism patience cohesion manpower advocate adequate purposes provided services motivate separate accuracy personal business relation purchase security contract recently involved consensus interrupt

 EXERCISE-18

 incentive secretary encourage certainly entertain certainly committee closeness expansion permanent tradition wonderful excluding including reservoir challenge necessity standards according tenements casualty important promotion principle criticise dismissal religions basically forgotten feudalism democracy political essential solutions transport education

EXERCISE-19
difficulty phenomenon importance everywhere sufficient congestion facilities population increasing decreasing activities investment commission colleagues government scientific experiment enthusiasm conclusion particular department confidence continuous visibility validation completely historical geography

EXERCISE-20

environment accordingly prosecution expectation resignation integration unfortunate reorganised subsistence agriculture progressive egalitarian operational communalism individuals significant competitive recruitment improvement exclusively inclusively qualitative preparation prohibition exploration intelligent unsolicited electronics

EXERCISE-21

 complication relationship urbanisation civilisation construction constitution nevertheless unemployment parochialism quantitative accommodation psychological modifications institutional qualification indispensable contradiction responsibility developments developmental

Saturday, April 13, 2013

Microsoft Excel keyboard shortcuts


Microsoft Excel keyboard shortcuts

By learning Keyboard Short cuts you can work on any version on ms-office, you can also do work fast without click on menus or tabs, you need not to search for functionality.

మీరు కీబోర్డ్ షార్ట్ కట్ (key board short cuts )కీస్ నేర్చుకోవడం వల్ల మీరు వర్క్ వేగంగా చెయ్య గలరు. కావున మీరు కీబోర్డ్ షార్ట్ కట్ కీస్ నేర్చుకోవడం ఎంతగానో అవసరం. అందుకొరకు మేము మీకోసం .....

General

Description
Shortcut Key
New file
Ctrl + N
Open file
Ctrl + O
Save file
Ctrl + S
Move between open workbooks
Ctrl + F6
Close file
Ctrl + F4
Save as
F12
Display the print menu
Ctrl + P
Select whole spreadsheet
Ctrl + A
Select column
Ctrl + Space
Select row
Shift + Space
Undo last action
Ctrl + Z
Redo last action
Ctrl + Y
Start a formula
Equals Sign (eg. SUM(A1+A2)
Exit Excel 97
Alt + F4

Navigating

Description
Shortcut Key
Move to next cell in row
Tab
Move to previous cell in row
Shift + Tab
Up one screen
Page Up
Down one screen
Page Down
Move to next worksheet
Ctrl + Page Down
Move to previous worksheet
Ctrl + Page Up
Go to first cell in data region
Ctrl + Home
Go to last cell in data region
Ctrl + End

Formatting Text In Worksheet

Description
Shortcut Key
Bold toggle for selection
Ctrl + B
Italic toggle for selection
Ctrl + I
Underline toggle for selection
Ctrl + U
Strikethrough for selection
Ctrl + 5
Change the font
Ctrl + Shift + F
Change the font size
Ctrl + Shift + P
Apply outline borders
Ctrl + Shift + 7
Remove all borders
Ctrl + Shift + Underline
Wrap text in same cell
Alt + Enter

Formatting Cells

Description
Shortcut Key
Format cells
Ctrl + 1
Select font
Ctrl + Shift + F
Select point size
Ctrl + Shift + P
Format as currency
Ctrl + Shift + 4
Format as general (to remove any formatting)
Ctrl + Shift + # (hash sign)
Format as percentage
Ctrl + Shift + 5
Format as number
Ctrl + Shift + 1

Editing/Deleting Text

Description
Shortcut Key
Delete one character to right
Delete
Delete one character to left
Backspace
Edit active cell
F2
Cancel cell entry
Escape Key

Highlighting Cells

Description
Shortcut Key
Select entire worksheet
Ctrl + A
Select entire row
Shift + Spacebar
Select entire column
Ctrl + Spacebar
Manual select
Hold Shift + with Left, Right, Up, Down Arrow Key

Copying and Moving Text

Description
Shortcut Key
Cut
Ctrl + X
Copy
Ctrl + C
Paste
Ctrl + V

Inserting Text Automatically

Description
Shortcut Key
Autosum a range of cells
Alt + Equals Sign
Insert the date
Ctrl + ; (semi-colon)
Insert the time
Ctrl + Shift + ; (semi-colon)
Insert columns/rows
Ctrl + Shift + + (plus sign)
Insert a new worksheet
Shift + F11

Miscellaneous

Description
Shortcut Key
Find text
Ctrl + F
Replace text dialog
Ctrl + H
Create a chart automatically on new sheet
F11
Edit a cell comment
Shift + F2

Main Jaws Keystrokes In Excel

 

Description
Shortcut Key
Say Version of Excel
Ctrl + Shift + V
Move to Next Sheet
Ctrl + Page Down
Move to Prior Sheet
Ctrl + Page Up
Go to a cell command
Ctrl + G
Collapse Selection To Active Cell
Shift + Backspace
Say Active Cell Coordinates
Insert + C
AutoSum
Alt + Equals
Formula Mode
Equals Sign
Insert Date In Current Cell
Ctrl + ; (semicolon)
Insert Time In Current Cell
Ctrl + Shift + ; (semicolon)
Current Column First Cell From Top
Alt + 1
Current Column Second Cell From Top
Alt + 2
Current Column Third Cell From Top
Alt + 3
Current Column Fourth Cell From Top
Alt + 4
Data Region Left
Ctrl + Left Arrow
Data Region Right
Ctrl + Right Arrow
Data Region Down
Ctrl + Down Arrow
Data Region Up
Ctrl + Up Arrow
Select Whole Data Region
Ctrl + Shift + 8
Say Formula
Ctrl + F2
Spell Check
F7
Report Gridline Status
Alt + Shift + g
Read Row Total
Insert + Delete
Read Column Total
Insert + Enter
Say Column Title
Alt + Shift + C
Say Row Title
Alt + Shift + R
Say Visible Range Coordinates
Alt + Shift + V
Cycle Through Controls in Dialog Box
Tab
Tab Backwards
Shift + Tab
List Cells With Comments
Ctrl + Shift + ' (apostrophe)
Row Second Cell From Left
Alt + Ctrl + 2
Row First Cell From Left
Alt + Ctrl + 1
Row Third Cell From Left
Alt + Ctrl + 3
Row Fourth Cell From Left
Alt + Ctrl + 4
Describe Cell Border
Alt + Shift + B
Read Cell Comment
Alt + Shift + ' (apostrophe)
Auto Filter
Ctrl + Shift + A
Read Cell Hyperlink
Alt + Shift + H
Close Office Assistant
Ctrl + Insert + F4
Set Monitor Cell One
Alt + Ctrl + Shift + 1
Set Monitor Cell Two
Alt + Ctrl + Shift + 2
Set Monitor Cell Three
Alt + Ctrl + Shift + 3
Set Monitor Cell Four
Alt + Ctrl + Shift + 4
Set Monitor Cell Five
Alt + Ctrl + Shift + 5
Set Monitor Cell Six
Alt + Ctrl + Shift + 6
Set Monitor Cell Seven
Alt + Ctrl + Shift + 7
Set Monitor Cell Eight
Alt + Ctrl + Shift + 8
Set Monitor Cell Nine
Alt + Ctrl + Shift + 9
Set Monitor Cell 10
Alt + Ctrl + Shift + 0
Read Monitor Cell One
Alt + Shift + 1
Read Monitor Cell Two
Alt + Shift + 2
Read Monitor Cell Three
Alt + Shift + 3
Read Monitor Cell Four
Alt + Shift + 4
Read Monitor Cell Five
Alt + Shift + 5
Read Monitor Cell Six
Alt + Shift + 6
Read Monitor Cell Seven
Alt + Shift + 7
Read Monitor Cell Eight
Alt + Shift + 8
Read Monitor Cell Nine
Alt + Shift + 9
Read Monitor Cell Ten
Alt + Shift + 0
List Visible Cells With Data
Ctrl + Shift + D
Lists Data In Current Column
Ctrl + Shift + C
List Data In Current Row
Ctrl + Shift + R
Select Hyperlink
Ctrl + Shift + H
Move To Worksheet Listbox
Ctrl + Shift + S
Move To Monitor Cell
Ctrl + Shift + M
Select Worksheet Objects
Ctrl + Shift + O
List Cells At Page Breaks
Ctrl + Shift + B
Options Listbox
Insert + V