Question

(1) Practical no.1- Write the steps to show FILTER the records in a table.

(2) Practical no.2- Write the steps for data validation a table.​

Answer 1

Answer:

practical no.1-

1. Select the column header arrow. for the column you want to filter.
2. Uncheck (Select All) and select the boxes you want to show.
3. Click OK. The column header arrow changes to a. Filter icon. Select this icon to change or clear the filter.

Explanation:

practical no.2-

1. Select the cell(s) you want to create a rule for.
2. Select Data >Data Validation.
3. Data Validation On the Settings tab, under Allow, select an option:

• Whole Number - to restrict the cell to accept only whole numbers.
• Decimal - to restrict the cell to accept only decimal numbers.
• List - to pick data from the drop-down list.

• Date - to restrict the cell to accept only date.
• Time - to restrict the cell to accept only time.

• Text Length - to restrict the length of the text.

• Custom – for custom formula.

4. Under Data, select a condition.

5. Set the other required values based on what you chose for Allow and Data.

6. Select the Input Message tab and customize a message users will see when entering data.

7. Select the Show input message when cell is selected checkbox to display the message when the user selects or hovers over the selected cell(s).

8. Select the Error Alert tab to customize the error message and to choose a Style.

9. Select OK.

Now, if the user tries to enter a value that is not valid, an Error Alert appears with your customized message.

mark me as brainleist