Bikramjit Singh (CF) GSSS Chawinda devi

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