Question

What is the function of Autofill?

• A. Autofill feature helps us to get the added sum of the contents of a cluster of consecutive cells.
• B. Autofill feature allows us to quickly fill cells with repetitive or sequential data
• C. Autofill feature allows us to quickly fill numeric values in cell
• D. None of these

Answer 1

Answer:

B. Autofill feature allows us to quickly fill cells with repetitive or sequential data

Auto Sum

• Auto sum feature helps us to get the added sum of the contents of a cluster of consecutive cells.

Autofill

• Autofill feature allows us to quickly fill cells with repetitive or sequential data

Sorting

• Data ----> Sort----->'Sort by' dialog box appears.

Data Validation

•  To allows only numeric values in  a cell 

           Select the cells

           Data----> validation----> In the 'Allow box'

           Select ' Whole Number'

• To set acceptable values for a cell

           Data ------validation -----> Select the allowed data from 'Allow' box.