Bikramjit Singh (CF) GSSS Chawinda devi

 MS Excel: 5 Most useful shortcuts in Excel 1. Shift+space : This shortcut is used to select the single entire row . Hold down the shift key and use up/down arrows to select multiple rows. 2. Ctrl+ space : This shortcut can be time saving to select an entire column . Hold down the shift key and use left/right arrows to select multiple columns 3. Ctrl+T : This is used to quickly insert the table . It would ask where the data is for your table before creating the table. 4. Ctrl+9 : It can be used to hide rows  in a worksheet.Note, hidden rows will not be printed. 5. Ctrl+0 : This is helpful in hiding the columns in a worksheet. Note,hidden columns will not be printed.  Click here to learn about Charts in Excel

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