Page 1 :
Field representsa column in the database., , luesi, subtotal values in the database are calculated with Countf, multiple Choice Questions: san, tion i:, which oP jon is used to restrict the cell entries within a specified range?, , , , , , a.Advanced Filter \b; Data Validation c.PivotTable, , , , hich button under Data tabi, wi ‘ab is used to remove a duplicate value from one or more columns?, , , , a.Remove b. Remoy, ve Data \_c-Rerniove Duplicates, , , , pich feature ina database i, wi provides an easy way to enter display a complete row of information?, , , , —, , arom b. Adding Subtotal c. Filter, , , , What do we calla rowina database?, , , , Not [ip | ;, Ot like | a. Form b. Field _&Record, , Answer the following:, , Describe the term Database. ,,¢, , , , , , , , , , , , , What is the use of Sorting feature in Excel?, , , , 3, Briefly explain the utility of Filter feature., , , , Whats a PivotTable? Describe its utility., , , , , , , , , 5, HowisAdvanced Filter different from Filter?