Question

1.
Which option is used to restrict the cell entries within a specified range?
2.
1.
a. Advanced Filter b. Data Validation
c. Pivot Table
Which button under Data tab is used to remove a duplicate value from one or more columns?
a. Remove
b. Remove Data
c. Remove Duplicates
Which feature in a database provides an easy way to enter display a complete row of information?
a. Form
b. Adding Subtotal
c. Filter
3.
N
4.
What do we call a row in a database?
a. Form
b. Field
c. Record
Which feature allows us to arrange the given data according to a particular field either in an ascending or
descending order?
5.
a. Data Form
b. Sort
c. Filter​

Answer 1

answer of 1st question is option b ) data validation