AUTOSUM, SORTING, FILTERING AND FORMATTING IN MS ACCESS

AUTOSUM FEATURE IN MS ACESS

Autosum feature is used for quickly summing the data values stored in a row or column. This feature can be used by clicking Auto sum button presented in the formula tab.

The steps to use Autosum features are:

Step 1: click the formula tab.

2: select Autosum button.

Step 3: press the enter key after selecting the correct range to get the sum of values in the result cell.



SORTING DATA

In the spread sheet, it is easy to maintain data as the sheet is divided into rows and columns. Data when entered in the sheet may not be arranged in an order. However, you can arrange it either in describing or ascending order is called sorting.

To sort the data on the basis of alphabetical order, follow the steps:

Step 1: creates the worksheet and select the cells.

For example: A2:F8.

Step 2: click ont the data.

Step 3: on the sort and filter group, click sort A to Z to sort in ascending or sort Z to A to sort in descending order.

FILTERING DATA

Filtering shows the data you wish to see while temporarily hiding the rest. By defining different filters, you can compare data in multiple ways. Thus, filter can be defined as a facility in Excel that allows a user to filter items in a list according to set criteria.

To filter the data, follow the steps given below:

Step 1: click a cell in the range you want to filter.

Step 2: click on data tab.

3: On the sort and filter group, select filter option.

Step 4: click on the arrow on the column heading, for example Roll No.

Step 5: A list opens with all the values selected by default. Choose the value you want, for example 10, and click on Ok button.


CONDITIONAL FORMATTING

Conditional formatting refers to the features which apply formatting to cells that meets certain conditions.

To apply conditional formatting follows the steps given below:

Step 1: select the cells within the range. For example D1: D8.

Step 2: click on the home tab and select conditional formatting from styles group.

Step 3: select the required option from the drop down list to specify condition. For example, highlight cells rules – text that contain. A dialog box appears.

Step 4: Type the name. For example, Delhi.

Step 5: click OK button.