Page 109 - modular4.0
P. 109
Chapter Profile
2 TEST SHEET
(Based on chapters 6 to 9)
Section A
A. Tick ( ) the correct option.
1. In which tab is Pivot table feature present?
a. Home b. Formula
c. Insert d. Page Layout
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
c. Conditional Filter d. Data Validation
3. Which area includes all objects and elements in a chart?
a. Plot Area b. Chart Area
c. Data Area d. Legend
4. Which of the following devices is not mandatory for video conferencing?
a. Internet connection b. Webcam
c. Microphone d. Scanner
5. Which layout shows files as a series of lines stacked one above the other?
a. Grid Layout b. List Layout
c. Serial Layout d. Line Layout
6. Which approach is followed by the if…elif…else ladder?
a. top-down approach b. bottom-top approach
c. top-left approach d. bottom-right approach
B. Fill in the blanks.
1. By default, button is not visible on the ribbon.
2. A database contains data in the form of and .
3. chart show the correlations between the two sets of values.
Test Sheet 2 107

