Information Technology
Class-9
Part-B
Unit-4 Electronic Spreadsheet,
Chapter-2 Microsoft Excel
A. Multiple Choice Questions:
1. By default a workbook contains:
a 1 worksheet b. 2 worksheet c. 3 worksheet d. 4 worksheet
Answer: 3 worksheet
2. A worksheet contains:
a. 65256 rows and 26 columns b. 65256 rows and 256 columns c. 65536 rows and 256 columns d. 65556 rows and 256 columns
Answer: 65,536 rows and 256 columns
3. Cell address $A$4 in a formula say=$A$4*20% is an example of which of the referencing?
a. Absolute b. Relative c. Mixed d. All of the above
Answer: Mixed
4. If cells, A1:A3 contain 205,25,80 then=MAX(A1:A3,82) returns:
a. 18 b. 80 c. 82 d. 20
Answer: 82
5. The area of a chart in which the actual data is plotted is called:
a. Plot area b. data area c. chart area d. sheet area
Answer: Plot area
6. Relation between prices of an entity in percentage can be best represented in:
a. bar chart b. line chart c. pie chart d. none of the above
Answer: Pie Chart
