Site pages
Current course
Participants
General
18 February - 24 February
25 February - 3 March
4 March - 10 March
11 March - 17 March
18 March - 24 March
25 March - 31 March
1 April - 7 April
8 April - 14 April
15 April - 21 April
22 April - 28 April
Microsoft Excel
Features of Excel
Moving Cell pointer : Cell pointer is a rectangular box that represents the current cell position. Current cell address will be displayed in formula bar. Cell pointer can be moved to desired cell as follows Right arrow -> Next column cell Left arrow -> Previous column cell Up arrow -> Previous row cell Down arrow -> Next row cell Home -> Column A of current row Ctrl Home -> First cell (A1) Selecting cells Single cell - point to cell and click mouse left button Multiple adjacent cells - Shift arrow key or mouse dragging Multiple non adjacent - Ctrl + Click on the cells Entire row - Click on row heading. Ctrl+Click on the row heading for selecting more than one rows. Entire column - Click on column heading. Ctrl+Click on the column heading for selecting more than one rows. Entire worksheet - Click the intersection of the column and row heading. Label prefixes Characters : In excel, a sequence of text is referred to as a label. The alignment of a label within a cell can be controlled by label prefix characters. Label prefix characters are followed by the text. ‘(single quotes) - Left alignment “(double quotes) - right alignment ^ (caret) - centre alignment Typing numbers : A number can be typed in a cell without giving any label prefix characters. A number will be right aligned in a cell. The format of a number can be changed as follows.
Now the numbers typed in that cells will be automatically converted to the selected format. Subtotal : Subtotal is used to summarise the sorted data. We can apply functions such as sum, count, minimum, maximum etc in subtotal.
Functions : Functions are typed in a cell in following format=Function name(argument) Argument may be in any one of the following format.
Functions are classified into several functions such as
Statistical functions
|