The customer is required to design the item number between 101 to 200. If the user types above 200 or below 100, the system should give an error message. Which of the following tool is used?

In a form, the teacher needs “True or False” as a drop down menu. Which of the following tool is used?

The size of an A4 paper is 21 cm x 29 cm. If the user chooses Landscape orientation, then the size of the paper is…..?

What is sorting?

What are the type of the filters?

What is header and footer?

Write the steps to format the margin of the paper as 1” in all sides.

The user needs page number at the bottom of all pages. Which tool is used? Write the steps to design the needs.

Write the steps for sorting the database based on the customer name in ascending order.

Write the steps to print the title row on every page of the spread-sheet.

Create a student database with register number, student name, Mark1, Mark2, and Mark3. Calculate the total and average of the students. Show the marks which are below 50 in red colour and marks above 50 is shown in green colour.

Explain the applications of Header and Footer with example.