PROJECT REPORT ON ONLINE SHOPPING
PROJECT
REPORT
ON ONLINE SHOPPING
RESPONSES:
SORTING:
As you add more content to a worksheet, organizing that information becomes especially important. You can quickly reorganize a worksheet by sorting your data. For example, you could organize a list of contact information by last name. Content can be sorted alphabetically, numerically, and in many other ways.
Sorting
When you enter data into your worksheet it is often unorganized making it difficult to examine. When analyzing the information in your spreadsheet, you may need to rearrange the data in different ways to answer different questions. Excel's sorting feature can help your rearrange your data so you can use it more efficiently.
To sort a list of data:
Select a single cell in the column containing the data you want to sort.
Select the Home tab.
Under the Editing group, press the Sort and Filtering button and select the order you want your data to be sorted.
STEPS IN SORTING:
Select a cell in the column you wish to sort
Select the Data tab on the Ribbon, then click the Ascending command to Sort A to Z, or the Descending command to Sort Z to A.
The worksheet will be sorted by the selected column.
Here we have sorted our data based on alphabets , which is applied in the NAME column .
Screenshot showing the sorting function for males and females
FILTERING:
Filtering is a way that you can use Excel to quickly extract certain data from your spreadsheet. Unlike sorting, filtering doesn't just reorder the list. It actually hides the rows or columns containing data that do not meet the filter criteria you define. Excel has an AutoFilter feature that makes it very easy to extract data from your spreadsheet.
To use the AutoFilter:
Click on any cell in your spreadsheet.
Select the Home tab.
Under the Editing group, press the Sort and Filtering button and select the Filter button.
Drop-down menus will appear next to each cell heading.
Clicking on any drop-down menu
REPORT
ON ONLINE SHOPPING
RESPONSES:
SORTING:
As you add more content to a worksheet, organizing that information becomes especially important. You can quickly reorganize a worksheet by sorting your data. For example, you could organize a list of contact information by last name. Content can be sorted alphabetically, numerically, and in many other ways.
Sorting
When you enter data into your worksheet it is often unorganized making it difficult to examine. When analyzing the information in your spreadsheet, you may need to rearrange the data in different ways to answer different questions. Excel's sorting feature can help your rearrange your data so you can use it more efficiently.
To sort a list of data:
Select a single cell in the column containing the data you want to sort.
Select the Home tab.
Under the Editing group, press the Sort and Filtering button and select the order you want your data to be sorted.
STEPS IN SORTING:
Select a cell in the column you wish to sort
Select the Data tab on the Ribbon, then click the Ascending command to Sort A to Z, or the Descending command to Sort Z to A.
The worksheet will be sorted by the selected column.
Here we have sorted our data based on alphabets , which is applied in the NAME column .
Screenshot showing the sorting function for males and females
FILTERING:
Filtering is a way that you can use Excel to quickly extract certain data from your spreadsheet. Unlike sorting, filtering doesn't just reorder the list. It actually hides the rows or columns containing data that do not meet the filter criteria you define. Excel has an AutoFilter feature that makes it very easy to extract data from your spreadsheet.
To use the AutoFilter:
Click on any cell in your spreadsheet.
Select the Home tab.
Under the Editing group, press the Sort and Filtering button and select the Filter button.
Drop-down menus will appear next to each cell heading.
Clicking on any drop-down menu