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…

What if Analysis

What-If Analysis
Excel 2016: 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 “Cost” respectively) for the Changing cells and click on OK. 
IV. Enter the corresponding value 1,50,000 and 1,34,000 then click on OK again. 
V. Next, add few other scenarios (Second, Third and Fourth). 
VI. Finally, your Scenario Manager should be consistent with the picture below:
Note: to see the result of a scenario, select the scenario and click on the Show button. Excel will change the value of cell C2 and C3 accordingly for you to see the corresponding result on the sheet. VII. Scenario Summary a. To easily compare the results of these scenarios, execute the following steps. b. Click the Summary button in the Scenario Manager. c. Next, select cell B4 (profit) for the result cell and click on OK. Scenario summary report:
NOTE   Scenario reports are not automatically recalculated. If you change the values of a scenario, those changes will not show up in an existing summary report. Instead, you must create a new summary report. 
Use Goal Seek to find out how to get a desired result 
If you know the result that you want from a formula, but you are not sure what input value the formula requires to get that result, you can use the Goal Seek feature. For example, suppose that you need to have a fixed Profit for your organization. You know how much money your organization have as Gross Revenue, You can use Goal Seek to estimate the Cost so as to achieve the required profit and meeI. On the Data tab, click What-If Analysis, Goal Seek. t your Goal.  
III. Select cell B4. 
IV. Click in the 'To value' box and type 30000. 
V. Click in the 'By changing cell' box and select cell B3. VI. Click OK. 
VII. Result. The company cost needs to be 70000 so as to get profit of Rs30000. 

Comments

Popular posts from this blog

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