Skip to main content

NETWORK BASICS

Network A system of interconnected computers and computerized peripherals such as printers is called computer network. This interconnection among computers facilitates information sharing among them. Computers may connect to each other by either wired or wireless media. A computer network consists of a collection of computers, printers and other equipment that is connected together so that they can communicate with each other.  


Network application
A Network application is any application running on one host and provides a communication to another application running on a different host, the application may use an existing application layer protocols such as: HTTP(e.g. the Browser and web server), SMTP(e.g. the email-client). And may be the application does not use any existing protocols and depends on the socket programming to communicate to another application. So the web application is a type of the network applications. 
There are lots of advantages from build up a network, but the th…

Shortcuts for Excel

Shortcuts for Excel
Microsoft Excel lessons give anyone valuable new professional skills
                                                       MS Excel
Shortcut
Effect
Shortcut
Effect
CTRL +N:
NEW WORKBOOK
CTRL +1:
FONT WINDOW
CTRL +O:
OPEN WORKBOOK
ALT +H+A+M:
MIDDLE ALLIGNMENT
CTRL +S:
SAVE WORKBOOK 
ALT +H+A+C:
CENTER ALLIGNMENT
ALT +F+A:
SAVE AS
ALT +H+A+T:
TOP ALLIGNMENT
F12:
SAVE AS 
ALT +H+A+B:
BOTTOM ALLIGNMENT
CTRL +C:
COPY
ALT +H+A+L
LEFT ALLIGNMENT
CTRL +X:
CUT
ALT +H+A+R:
RIGHT ALLIGNMENT
CTRL +V:
PASTE
F1:
HELP
CTRL +Z:
UNDO
F2:
EDIT SELECTED CELL
CTRL +Y:
REDO
F7:
SPELL CHECK
CTRL +D:
DUPLICATE FROM ABOVE
ALT +H+F+F:
FRONT STYLE
CTRL +F:
FIND
ALT +H+F+S:
FONT SIZE
CTRL +H:
REPLACE
ALT +H+F+C:
FONT COLOR
CTRL +G:
GOTO 
ALT +H+H:
CELL BACKGROUND COLOR
F5:
GOTO
ALT +H+5:
DECREASE INDENTATION
CTRL +0:
HIDE COLUMN
ALT +H+6:
INCREASE INDENTATION
CTRL + SHIFT +):
UNHIDE COLUMN
ALT +H+M+C
MERGE AND CENTER
CTRL +9:
HIDE ROW
ALT +H+M+A:
MERGE ACROSS
CTRL + SHIFT +9:
UNHIDE ROW
ALT +H+M+M:
MERGE CELLS ONLY
CTRL +I
ITALICS
ALT +H+F+A:
ALLIGNMENT WINDOW
CTRL +3:
ITALICS
ALT +=:
SUM() FUNCTION
CTRL +B:
BOLD
ALT +1:
1ST QUICK ACCESS ICO
CTRL +2:
BOLD
ALT +2:
2ND QUICK ACCESS ICON
CTRL +U:
UNDERLINE
ALT +3:
3RD QUICK ACCESS ICON
CTRL +4:
UNDERLINE
ALT +4:
4TH QUICK ACCESS ICON
CTRL +5:
STRIKE-THROUGH
ALT +5:
5TH QUICK ACCESS ICON
CTRL +L
CREATE TABLE
ALT +H+E+F
CLEAR FOR-MATING
CTRL +R:
DUPLICATE FROM LEFT
ALT +H+E+M:
CLEAR FOR-MATING
CTRL + SHIFT +>:
DUPLICATE FROM LEFT
ALT +N+V:
PIVOT TABLE
CTRL +A:
SELECT BLOCK
ALT +N+T:
INSERT TABLE
CTRL +A:
SELECT ALL CELLS
ALT +N+I:
INSERT HYPERLINK
CTRL +T:
CREATE TABLE
ALT +H+I+S
INSERT SHEET
CTRL +P:
PRINT 
ALT +H+I+R:
INSERT ROW
CTRL ++:
INSERT CELL(S)
ALT +H+I+C:
INSERT COLUMN
CTRL +-:
DELETE CELL(S)
ALT +H+F+I+D:
FULL  DOWN
ALT +D+F+F
FILTER
ALT +H+F+I+R:
FILL RIGHT
ALT +H+S+F:
FILTER
ALT +H+F+I+L:
FILL LEFT
ALT +W+F+F:
FREEZE PANE
ALT +H+F+I+U:
FILL UP
ALT +H+F+G:
INCREASE FONT SIZE
ALT +H+F+I+S:
FILL SERIES
ALT +H+F+K
DECREASE FONT SIZE
ALT +H+F+I+J:
FILL JUSTIFIED
ALT +H+F+N:
FONT WINDOW 
ALT +H+S+S:
SORT ASCENDING
ALT +H+B+M:
BORDERS
ALT +H+S+O:
SORT DESCENDING

Comments

Popular posts from this blog

What if Analysis

What-If Analysis What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily.  Use scenarios to consider many different variables  A scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. 
Create Different Scenarios 
Note: You can simply type in a different revenue and Cost into cell B2 and B3 respectively to see the corresponding result of a scenario in cell B4. However, what-if analysis enables you to easily compare the results of different scenarios.  
I. On the Data tab, click What-If Analysis and select Scenario Manager from the list. The Scenario Manager Dialog box appears  II. Add a scenario by clicking on Add.  III. Type a name (e.g. “First Case”), select cell B2 and B3 (represents “Revenue” and “…

PROFESSIONAL ENGLISH

Asking For and Giving Opinions on Likes and Dislikes

Words Meaning Sample Sentence Opinion A statement or judgment formed about some matter. Bhoomika gave her final opinion on the company’s matter. Dialogue A conversation between two or more people. Her dialogue stated her opinion about the company’s matter. Expression The action of making known one’s thought or feelings. Her expression was sad at the meeting. Frank An open, honest, and direct speech or writing Bhoomika is very frank with her friends. Recover Return to normal state of health, mind or strength. The company’s economic crisis will be recovered soon. Turmoil A state of great disturbance. The company is facing financial turmoil. Economics The branch of knowledge concerned with the production, consumption, and transfer of wealth. Bhoomika studied Economics at the State University. Betrayed Expose to danger by treacherously giving information to an enemy.

DAILY LIFE VOCABULARY

Apology Etiquette and Office Vocabulary 

Chapter Vocabulary

Word Meaning Sample Sentence Stressed A state of any mental or emotional tension. Ram seems much stressed after his poor exam. Launch An act of instance of starting something. The government launched a new scheme for the poor people. Error A mistake Ravi found a grammatical error in his new grammar book. Scold Blaming someone for any wrong doing Bhuvan scolded his employees for their poor performance. Accuse Claiming that someone has done something wrong. Bharati accuses her friend Chaya for stealing her necklace. Fair Good and honest Ravi got promoted for doing a fair job. Ashamed Embarrassed or guilty because of one’s action. <