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…

Insert Tab

Pivot Table 
How to Delete a Pivot Table in Excel (Easy Step-by-Step Guide)
1. Pivot Table: Pivot tables are used to summarize or arrange data of a Table, so that they may be viewed in a easy to analyze manner. You would be able to see the details of each summarize section by simple double click. 

Using Pivot-tables:  

Suppose we wanted to answer the question: "What is the amount sold by each salesperson?" for the sales data in the example below.  Answering this question could be very time-consuming and difficult—each salesperson appears on multiple rows, and we would need to total all of their different orders individually.  

Fortunately, a Pivot-table  can instantly calculate and summarize the data in a way that's both easy to read and manipulate. When we're done, the Pivot-table will look something like this: 

Once you've created a Pivot-table, you can use it to answer different questions by rearranging, or pivoting, the data.  
For example, if we wanted to answer the question: "What is the total amount sold in each month?" we could modify our Pivot-table to look like this: 

To create a Pivot-table:

1. Select the table or cells (including column headers) containing the data you want to use. 

2. From the Insert tab, click the Pivot-table command. 

3. The Create Pivot-table dialog box will appear. Choose your settings, then click OK. In our example, we'll useTable1 (A1:E15) as our source data and place the Pivot-table on a new worksheet. You may select the required table after clicking in the box (Table/Range) and then by mouse just select the whole table. 

4. A blank Pivot-table and Field List will appear on a new worksheet (Sheet 2). 

5. Once you create a Pivot-table, you'll need to decide which fields to add. Each field is simply a column header from the source data. In the Pivot-table Field List, check the box for each field you wish to add. In our example, we want to know the total amount sold by each salesperson, so we'll check the “Salesperson” and “Order Amount” fields. 

6. The selected fields will be added to one of the four areas below the Field List. In our example, the Salesperson field has been added to the Rows area (so as to display the content as it is), while the Order Amount has been added to the Values area (so as to display the sum our count of the data, as per requirement of the user). Alternatively, you can click, hold, and drag a field to the desired area. 

7. The Pivot-table will calculate and summarize the selected fields. In our example, the Pivot-table shows the amount sold by each salesperson. 

Just like with normal spreadsheet data, you can sort the data in a Pivot-table using the Sort & Filter command in the Home tab. You can also apply any type of number formatting you want. For example, you may want to change the Number Format to Currency. However, be aware that some types of formatting may disappear when you modify the Pivot-table. 

If you change any of the data in your source worksheet, the Pivot-table will not update automatically. To manually update it, select the Pivot-table and then go to Analyze Refresh. 

Pivoting data

One of the best things about Pivot-tables is that they can quickly pivot, or reorganize, data, allowing you to look at your worksheet data in different ways. Pivoting data can help you answer different questions and even experiment with the data to discover new trends and patterns. 
In our example, we used the Pivot-table to answer the question: "What is the total amount sold by each salesperson?" But now we'd like to answer a new question: "What is the total amount sold in each month?" We can do this by simply changing the field in the Rows area. 
To change the row: 
1. Click, hold, and drag any existing fields out of the Rows area. The field will disappear. 

2. Drag a new field from the Field List into the Rows area. In our example, we'll use the Month field. 

3. The Pivot-table will adjust, or pivot, to show the new data. In our example, it now shows the total Order Amount for each month. 

To add columns: 
So far, our Pivot-table has only shown one column of data at a time. In order to show multiple columns, you'll need to add a field to the Columns area. 
1. Drag a field from the Field List into the Columns area. In our example, we'll use the Region field. 

2. The Pivot-table will include multiple columns. In our example, there is now a column for each region. 

Filters 

Sometimes you may want focus on just a certain section of your data. Filters can be used to narrow down the data in your Pivot-table, allowing you to view only the information you need. 
To add a filter: 
In our example, we'll filter out certain salespeople to determine how they affect the total sales. 
1. Drag a field from the Field List to the Filters area. In this example, we'll use the Salesperson field. 

2. The filter will appear above the Pivot-table. Click the drop-down arrow, then check the box next to Select Multiple Items. 

3.Uncheck the box for any items you don't want to include in the Pivot-table. In our example, we'll uncheck the boxes for a few different salespeople, then click OK. 

4. The Pivot-table will adjust to reflect the changes. 

Pivot-charts 

Pivot-charts are like regular charts, except that they display data from a Pivot-table. Just like regular charts, you'll be able to select a chart type, layout, and style that will best represent the data. 
To create a Pivot-chart: 
In this example, our Pivot-table is showing each person's total sales per month. We'll use a Pivot-chart so we can see the information more clearly. 
a. Select any cell in your Pivot-table. 

b. From the Insert tab, click the Pivot-chart command. 

The Insert Chart dialog box will appear. Select the desired chart type and layout, then click OK. 

c. The Pivot-chart will appear. 

Try using slicers or filters to change the data that is displayed. The Pivot-chart will automatically adjust to show the new data. 

 From the above table perform the following tasks: 

Find,

  •   Region Wise number of orders for each item sold 
  • Region Wise total units for all orders against each item 
  • Region wise performance of Agents against the total costing cost of orders 
  • On which date, which agent took the number of orders against each item. 
  • Make a line chart for Total against order date 
  • Make a column chart for Units of item against representative 
  • Highlight each cell of the column “Total” with data bars, so as to represent the smaller and bigger value through graphical bars. 
Table:  
Insert a table To quickly insert a basic table, click Insert > Table and move the cursor over the grid until you highlight the number of columns and rows you want. Click and the table appears in the document. If you need to make adjustments, you can add table rows and columns, delete table rows and columns, or merge table cells into one cell. When you click in the table, the Table Tools appear. Use Table Tools to choose different colors, table styles, add a border to a table or remove borders from a table. You can even insert a formula to provide the sum for a column or row of numbers in a table. If you already have text in your document that would look better as a table, Word can convert the text to a table. Insert larger tables or tables with custom width bThis way you can create a table with more than ten columns and eight rows, as well as set the column width behavior. 1. Click Insert > Table > Insert Table. 2. Set the number of columns and rowsehaviors For larger tables and for more control over the columns, use the Insert Table command. 
3. In the Auto-fit behavior section you have three options for setting how wide your columns are:  Fixed column width: You can let Word automatically set the column width with Auto, or you can set a specific width for all of your columns.  Auto-fit to contents: This will create very narrow columns that will expand as you add content.  Auto-fit to window: This automatically changes the width of the entire table to fit the size of your document. 4. If you want each table you create to look like the table you’re creating, check Remember dimensions for new tables. Table Tools: Once you click on any portion of a table, the Table tools option appears. The Table Tools option consist of Design Tab and Layout Tab. 

Design Tab: It consists of Commands to give different styles to your selected table, various color shading to the table, to change the border styles and border thickness.

Layout Tab: It consists of Commands to   Delete rows, column and table  Insert rows and columns in the table (you may also increase the number of rows by clicking tab at the last cell of the table),   Auto-fit option to automatically resize the table to its contents,   Change the height or width of rows or columns,   Align the text of the table towards any edge or center of the respective cell,   Text direction to change the orientation of the text,   Sort to arrange the contents of any column in alphabetical or numerical order.
Table Navigation When you are entering data into your table, you can simply click into different cell with your mouse to move your cursor around. This will allow you to enter text into different cell.  However, you may find it faster to move around using the keyboard. The table below outlines some keyboard techniques for moving in a table: Header and Footer 

You’ve updated an old document with new information and now you want to update a header or footer. Double-click the header or footer area (near the top or bottom of the page) to open the Header & Footer Tools or click on Insert Tab and then click the Header option.  Type your new header or footer. Double-click the body of the document to close the Header & Footer Tools or click on “Close the Header and footer” option.
To also change the design of the header or footer You can change the look of a header or footer with dozens of built-in designs in the Header & Footer Tools. In the-insert tab, click the arrow below Header or Footer and then select the one that you want. This overwrites your current header or footer and you’ll have to type the information in again. 
Insert Page number To quickly insert page numbers in your document, use the Page Number gallery. Click or tap Insert > Page Number. NOTE: The Page Number gallery will replace an existing header or footer if you have one. To add page numbers to an existing header or footer, see Add page numbers to a header or footer in the next section. 
Use the Page Number gallery to insert page numbers The Page Number gallery provides a menu of ready-to-use page numbers. 1. Under Insert, click Page Number, click a location (such as Top of Page), and then pick a style. Word automatically numbers every page. 2. When you’re done, under Design > Header & Footer Tools, click Close Header and Footer, or double-click anywhere outside the header and footer area. Add page numbers to a header or footer 

If you have a header or footer in your document, and you want to add page numbers without losing any information in that header or footer, use the Page field code. Click Insert > Quick Parts > Field > Field Names >Page.  NOTE    If you don’t have a header or footer and you want to add page numbers, you can use the Page Number Gallery. See Add page numbers. Remember, though, the Gallery will replace your existing header or footer. Use the Page field code to insert page numbers 1. Double-click in the header area or the footer area (near the top of the page or near the bottom of the page). This opens the Design tab under Header & Footer Tools. 2. Position your cursor where you’d like to add the page number. To place the page number in the center or on the right side of the page, do the following:  To place your page number in the center, click Insert Alignment Tab in the Position group of the Design tab, click Center, and then click Ok  To place your page number on the right side of the page, click Insert Alignment Tab in the Position group of the Design tab, click Right, and then click OK. 3. On the Insert tab, click Quick Parts and then click Field.4. In the Field names list, click Page, and then click OK. 5. To change the numbering format, click Page Number in the Header & Footer group, and then click Format Page Numbers. 6. To return to the body of your document, click Close Header and Footer on the Design tab (under Header & Footer Tools). 

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