Coding Avengers

  Answer- Follow the given steps to sort data of a selected range of cells-  Step 1- Open Excel sheet. Step 2- Select the cell range we want to sort. Step 3- Click on Sort button in the Sort & Filter group on Data tab. Step 4-  The Sort  dialog box will appear. Choose the  column  you want to sort by. Step 5- Decide the sorting order (either ascending or descending). Step 6- Once you're satisfied with your selection, click OK. The cell range will be sorted by the selected column.

  Answer- Data validation is a feature in MS Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters. Data validation can simply display a message to a user telling them what is allowed.Data validation can also stop invalid user input.In addition, data validation can be used to present the user with a predefined choice in a dropdown menu.

Answer- Conditional formatting means highlighting or emphasizing selected cells on the basis of a criteria or condition. It allows us to set rules on how the cells should be formatted. We can change either the cell color or font color or font style of selected cells on the basis of a condition. We can highlight the cells with a background color to make the data more valuable.

Answer- Following are the two options available in MS Excel for filtering data- (i) Auto Filter ( For simple criteria) (ii) Advanced Filter ( For more complex criteria)

Answer- Adding New  Records Using Form We can add new records in our database using form feature of Ms Excel. To add new records, follow the given steps- Step 1- Select a cell and click on Form button in the Quick Access Toolbar . A dialog box appears on the screen. Step 2- Click on New button to add a new record in our database. Step 3- Here we can type the information for new record. Step 4- Click on Close button to exit from data form. Hence, the new record will be entered in our database.

Answer- In MS Excel filter feature is used to filter out only a desired data from a larger set of data. It will hide all the unwanted data and only the data specified in the filter will be shown. For example - We have a worksheet containing data about employees . Column A contains name and Column B contains Salary. If you want to see how many employees earn less than 10 thousand you can check the values in filter of column B which are less than 10 thousand . The result will be all the employees earning less than 10 thousand.

Answer- Sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize. E.g. Arranging a list on the alphabetical order, arranging your data on in increasing or decreasing order of numeric values.

Answer-  A database is an organized collection of data, so that it can be easily stored, accessed and managed in a computer system. We can organize data into tables, rows, columns, and index it to make it easier to find relevant information.