MS office - Excel

Home >> Computer Awareness

1. The Data menu option has the option to sort the data. The Data tab in MS Excel contains the Sort & Filter group which can be used to sort the data.


*******

2. A cell in a sheet of MS Excel can be activated by pressing TAB key , by pressing arrow keys or by clicking the cell in the sheet.


*******

3. The SUM function in MS Excel adds the arguments you enter in the SUM formula. The correct example of SUM formula is =SUM (A1:A5).


*******

4. VLOOKUP is an Excel function that is used to find things in a table or a range by row. VLOOKUP stands for Vertical Lookup and it supports approximate and exact matching, and wildcards for partial matches.


*******

5. When AutoSum option is clicked in MS Excel, it automatically enters a formula (that uses the SUM function) to sum the numbers.


*******

6. XLS file extension icon is the default MS Excel file extension. XLS is a file extension for a spreadsheet file format created by Microsoft for use with Microsoft Excel.


*******

7. A function inside a function is known as Nested function. A nested function takes another function as an argument to compute the result.


*******

8. Spelling, Thesaurus and Research tools are available in MS Excel. All these tools are available under the Review menu of MS Excel.


*******

9. When the Ctrl key is pressed with the Down Arrow, the last cell of the column gets activated. It is a shortcut to move to the bottom of the column in MS Excel.


*******

10. Ctrl + 9 is used to hide a selected row. When a row is selected and Ctrl + 9 key is pressed, the row gets hidden.


*******

11. CTRL + ; key combination inserts the current date in the selected cell. When the Ctrl key is pressed with ;(semi colon) key, the current date gets inserted.


*******

12. The current time can be inserted in an active cell by pressing 'Ctrl + Shift + :'. The Ctrl + ; key combination inserts current date.


*******

13. By pressing Ctrl + Space, all the cells of the active column gets selected. This a shortcut to select all the cells in a column.


*******

14. Ms Excel supports a wide variety of built-in functions that can be used when building formulas. The Insert Function button is located on the Formula bar.


*******

15. Shift + F2 inserts a comment in MS Excel. When a cell is active, pressing Shift and F2 button will allow entering comment in that cell.


*******

16. MS Excel's AutoFill feature is used to fill cells with data that follows a pattern or that is based on data in other cells. Microsoft Excel's AutoFill feature makes data entry efficient.


*******

17. If there is a need to count the total characters in a cell, it can be done by using the LEN function. To use the function, enter =LEN(cell) in a cell or in the formula bar and press Enter.


*******

18. When Shift and F11 key is pressed together, a new sheet is inserted in MS Excel. It is a quick way to add a new sheet.


*******

19. The Convert function will convert miles into kilometres. Excel's convert function ("=CONVERT()") converts a measurement from one unit to another.


*******

20. CTRL + Shift + & is used to add a border to the selected cell in MS Excel. It is a shortcut to add border to the active cell.


*******
Advertisement

Kindly help us to keep GKToday updated and error free. Use this form to report error or outdated information in questions. We shall rectify asap...