Page 70 - modular4.0
P. 70
Chapter Profile
Perform the following steps to use the Pivot Table:
2 Click on the
Insert tab.
3 Click on the Pivot
Table command from
the Tables group.
1 Select the data
on which you want
to apply Pivot Table
command.
Exercise
A. Tick ( ) the correct option.
1. A form displays record at a time.
a. One b. two
c. three d. many
2. Which facility of Excel is used to hide data in a range of cells so that only the data that meets certain
criteria is visible?
a. Custom Sort b. Filter
4 Click on the OK button.
c. Conditional Filter d. Data Validation
3. Which option of Conditional Formatting is selected when you want to highlight all cells satisfying a
given condition?
a. Top/Bottom Rules b. Percent Rules
6 Similarly, drag the c. Highlight Cell Rules d. Data bars
Department column
into Column Labels 4. In which tab is Pivot table feature present?
box.
a. Home b. Formula
7 Finally, drag the c. Insert d. Page Layout
Total column into 5. Which of the following is not a tab option of Data Validation dialog box?
Values box.
5 Drag the Employee Name column from a. Settings b. Input Message
Choose fields to add to report box and c. Error Alert d. Define Range
drop into Row Labels box.
Your report will appear on the worksheet.
68 Modular (Ver. 4.0)-VII

