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…

Inserting Hyperlink and Symbol

1. Hyperlink: You may use Hyperlink to create a shortcut that opens a document or files stored on a network server, an intranet or the Internet. When you click the cell that contains the Hyperlink function, Microsoft Excel opens the file that is stored in link_location. 
3 Ways to Insert a Hyperlink in Microsoft Word - wikiHowThe Hyperlink can also be made for linking to any data in the same sheet or same workbook. 

So Hyperlink can be  o Within same file.  o With other files. 
Within same file 
To create a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Select Hyperlink from the popup menu or click on Insert from the “Tabs” and select the “Hyperlink” option. 
When the Insert Hyperlink window appears, click on the "Place in This Document" on the left. Enter the text to display. In this example, we've entered "Hyperlink to cell A5". This is the value that will be displayed in Excel. 
Next enter the cell reference that the hyperlink points to. We've chosen to link to cell A5. Click the OK button. Now when you return to the spreadsheet, you should see the hyperlink. If you click on the hyperlink, your active cell should become cell A5 (the selection would move from cell A1 to A5). You may also follow the same process to link data in another sheet of the same workbook, just by selecting “Sheet 2 or Sheet 3 or other sheet” from the option “Select a place in this document” and type the required cell reference (e.g. B22, D44, E3, etc.) in the “Type the Cell Reference” box. 
With other files 
a. To have the hyperlink open another document, a web page on a company’s intranet, or a website on the Internet, click the Existing File or web Page button if it isn’t already selected and then enter the file’s directory path or web page’s URL in the Address text box. 
i. If the document you want to link to is located on your hard drive or a hard drive that is mapped on your computer, click the Look In drop-down button, select the folder, and then select the file in the list box. If you’ve recently opened the document you want to link to, you can click the Recent Files button and then select it from the list box. ii. If the document you want to link to is located on a website and you know its web address, you can type it into the Address text box. If you recently browsed the web page  you want to link to, you can click the Browsed Pages button and then select the address of the page from the list box.
  
b. To open a new e-mail message addressed to a particular recipient, click the E-mail Address button and then enter the recipient’s e-mail address in the E-mail Address text box. 
i. As soon as you begin typing the e-mail address in the E-mail Address text box, Excel inserts the text “mailto:” in front of whatever you’ve typed. (mailto: is the HTML tag that tells Excel to open your e-mail program when you click the hyperlink.) ii. If you want the hyperlink to add the subject of the e-mail message when it opens a new message in your e-mail program, enter this text in the Subject text box. iii. If the recipient’s address is displayed in the Recently Used E-mail Addresses list box, you can enter it into the E-mail Address text box simply by clicking the address. 

c. (Optional) To change the hyperlink text that appears in the cell of the worksheet (underlined and in blue) or add text if the cell is blank, type the desired label in the Text to Display text box. 

d. (Optional) To add a Screen-tip to the hyperlink that appears when you position the mouse pointer over the hyperlink, click the Screen-tip button, type the text that you want to appear next to the mouse pointer in the Screen-tip box, and then click OK. 

e. Click OK to close the Insert Hyperlink dialog box. After you create a hyperlink, you can follow it to the site you associated with the hyperlink. To follow a hyperlink, position the mouse pointer or Touch Pointer over the blue text or graphic image. When the pointer changes to a hand, click the hypertext or graphic image, and Excel makes the jump to the external document, web page, cell within the workbook, or e-mail message. 

 2. Symbol:  

In this article we would see how to Insert a symbol by using the Symbol command Insert a symbol by using its character code 
Insert a symbol by using the Symbol command 
a. On the Insert tab, in the Symbols group, click Symbol. b. In the Symbol dialog box, on the Symbols tab, in the Font box, click Wingdings. c. Scroll to the bottom of the list, where you will find several common check mark symbols. Double-click the symbol that you want. 

Insert a symbol by using its character code 

a. You can also use the character code of the symbol as a keyboard shortcut. For example, to insert the check mark symbol, change the font to Wingdings, and then press and hold ALT while typing 0252 on the numeric keypad. NOTE   You must use the numeric keypad and not the keyboard to type the numbers. Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad. 


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. <