Click the OK button to close the Column Width dialog box
Using Sorting Feature
Excel enables you to sort data in rows or columns. You can sort data based on ascending or descending order. To sort data perform the following steps:
Select the range of cells containing the data that need to be sorted
Select the Data à Sort command to display the Sort dialog box
Select the required options and click the OK button
The Sort Dialog box options:
Sort by: sort data by the specified column based on ascending or descending order.
Then by: sort data by more than one column. Excel first sorts the column specified in the Sort Bybox and then by the columns specified in Then By boxes in sequence.
My list has: This contains two radio buttons, Header row and No header row. If the first row has column labels, click the Header row radio button to exclude the first row from the sort. In contrast if you need to include the first row in the sort, you can click the No Header row radio button.
Using formulas and functions
At times there may be a need to perform some calculations on some numerical data that is represented in an Excel worksheet. To perform calculations, a formula can be used
Formulas in Excel begin with an equal sign (=)
E.g., =A1+A2+A3 is a formula to add the contents of cells A1, A2, and A3
The Formula bar is a bar at the top of the Excel window that displays the formula of the active cell
The Formula bar is displayed by default. You can choose not to view the Formula Bar. To stop viewing the Formula Bar, select View à Formula Bar command. You can later view the Formula Bar by selecting the same option.
Entering Formulas in a Worksheet
A formula can be typed in a cell to calculate and display the result of the formula in that cell. Eg., in a cell A1 a formula given as =B4+C5 adds the cell contents of cell B4 and cell C5 and display the result in cell A1
The formula specified must be preceded by an equal to (=) sign otherwise the calculation will not be performed
Listed below are some examples of formulas:
=35 * 44
=23 ^ 2
=S3 - D6 * 44 / 3
An important and useful feature of Excel is that it automatically recalculates the value of the cell that contains a formula if the values of the cells to which the formula refers to change. For example, the formula =C3+C4 in cell C5 is recalculated if the values of cells C3 or C4 change.
Excel provides many functions - mathematical, statistical, logical, etc.