Bikramjit Singh (CF) GSSS Chawinda devi

MS Excel: To create charts Ms Excel provides us different type of  charts which can be used according to the demand of data . Following type of charts can be used in ms excel: Pie Chart : It is used to express data in the form of percentage. Bar Chart:  It is used if we want to compare different values related to different categories.It runs horizontally as shown in fig below: Column chart: It is similar to Bar chart, however it runs vertically as shown in below diagram : Line Chart:   To show trend of  data over a span of time this kind of chart is used: Example: Lets us understand how to insert a chart in MS excel with an example. Consider we have a following data in the form of table and we want to display it in the form of chart. To display it in the form chart: Select the data Click on 'Column' under 'Insert' tab to select 'Column chart' Select the chart type to insert the chart 5 Most useful shortcuts in Excel

VLOOKUP function in Ms Excel:  This function is very useful in ms excel, it simply look up the first column for a value provided and returns the desired value in the same row. Lets have a look on VLOOKUP formula first: VLOOKUP(value,table,index_number,[approximate_match]) Here value is the actual value which we want to look up in the first column of a table table is two or more columns of data that is sorted in ascending order index_number is the number of column from which value must be returned approximate_match is optional, it can either be 'True' or 'False'. By default it assumed it as 'True'. False is used to find exact match,True is used to get an approximate value. Now understand this formula with the help of an example. Consider we have following data  Now, to fetch the student 'Name' (exact value in second column) for a student whose 'Roll number' is '1008', following VLOOKUP formula can be used:   VLOOKUP(1008, A2:B9, 2, FALSE) ...

Data Validation: Data validation let the user to enter restricted data only,so it helps to avoid mistakes.For example: For a student, marks should be between 0 and 100. To put this restriction, select all the cells and click on 'Data validation' in 'Data tab' as shown in fig below:   Now select the data type under 'Allow' like in our case, we are selecting 'whole number'. Under 'Data', select the condition which we want to impose on the data, as  'between' is selected to restrict the values from 0 to 100 as shown in fig below: Now click on 'Error Alert' tab  and type the title under 'Title' and message under 'Error message' which we want to display, if user enter different data other than restricted. Group and Ungroup: This option helps us to easily view and hide data in rows and columns. To do this select the rows and click on 'Group' option in 'Data' tab as shown in fig below: After clicking the ...

Merge & center: It is very easy to merge cells and align the text in center in Ms Excel. To do it, select the number of cells which you want to merge and click 'Merge&center' option from the 'Home' tab.This will merge the cells and align the text to the center. To un-merge the cells just click 'Merge&center' option once again. Sort and Filter: Sort: To sort the values, first select the cells which you want to sort , then select 'Sort&Filter' option from the 'Home' tab and click on 'Sort A to Z' or 'Sort Z to A' according to your need. Moreover you can click on 'Custom Sort' to try more options. For example, to sort the student list in alphabetical order, click on 'Sort A to Z', it will sort the values. Filter: To filter the data in Ms excel ,first select the column which you want to filter and  use 'Sort & Filter' option from the 'Home' tab and click on 'Filter' option.I...

Lets learn basic things about MS- excel. Very first question, What is it? Ms-Excel is a spreadsheet program developed by Microsoft.Using this we can manipulate, format or calculate various arithmetic functions on data arranged in columns and rows.It looks like below: MS Excel basically consists of rows and columns. Rows :  Rows consists of horizontal lines, two parallel horizontal lines make a row as shown in fig below:   Here first row is selected. Number 1 represent row number 1 and similarly each number represents respective row number. Columns: Columns consists of vertical lines, two parallel vertical lines make a column as shown in fig below:   Each column is identified by a different alphabet as first column is marked as A.  Cell : A cell is a rectangular box which occurs as the result of intersections of rows and columns as shown below:               How to perform various arithmetic...