Page 49 - ModularV1.1 _c6_flipbook
P. 49
Periodic Assessment-2
(Based on chapters 3 to 5)
A. Fill in the blanks.
1. A workbook is a collection of different ................................. .
2. The Excel file is called a ................................. .
3. Cells arranged vertically across the screen are called ................................. .
4. ................................. bar is used to enter, edit formulas and perform calculations on worksheet.
B. Write ‘T’ for True and ‘F’ for False.
1. You cannot format the cells in a spreadsheet. .....................
2. Data cannot be entered in an active cell. .....................
3. A workbook may contain any number of worksheets according to a user’s need. .....................
4. The Pivot Table feature of MS Excel allows you to analyse large amount .....................
of data.
C. Label the components of an MS Excel window.
D. Application based question.
Sushmita wants to prepare a summary of financial transactions for an official presentation.
Which component of MS Office Suite 2010 is most suitable for her purpose?
...........................................................................................................................................................................................
...........................................................................................................................................................................................
Periodic Assessment-2 47

