NEW OXFORD SCHOOL - CBSE
Affiliated to CBSE New Delhi, Affiliation No: 830703
Doddathimmasandra, Sarjapura(P), Anekal( T )–562 125
Formative Assessment - 4 January 2025
Subject : Computer Science
Name: _______________ Date:______
Class : V Section: ____ Marks: 20
I. Fill in the blanks. (4× 1 = 4)
1. MS Excel is a ______________________________software.
2. A _____________________________ is the intersection of a row and a
column in a worksheet.
3. Each page in an Excel workbook is called a
_____________________________.
4. ____________________________ is the default active cell in Excel.
II. Choose the correct answer. (4× 1 = 4)
1. An Excel file is saved with the ______________________________
extension.
a. doc b. .excel c. .xlsx
2.Which of the following displays the address of the active cell in MS
Excel?
a. name box b. formula bar c. column
3. How do you save an Excel file?
a. Press ctrl+P b. ctrl+S c. click on the print button
4. By mistake you delete a record in the sheet. Which command can be
used to restore it immediately.
a. Cut b. copy c. undo
1
III. Match the following. ( 4 × 2 = 2)
1. row a. the cell which gets highlighted when
selected
2. column b. a cell is identified by its column name
and row
3. active cell c. group of cells that runs
horizontally in a worksheet.
4. cell address d. group of cells that runs vertically
in a worksheet
1
IV. State whether the following statements are true or false.( 4 × 2 = 2)
1. By default, a workbook contains two worksheets. [ ]
2. Pressing ctrl + P saves a workbook. [ ]
3. Only some cells have addresses. [ ]
4. MS Excel is used to make calculations. [ ]
V. Answer the following. ( 2 ×1= 2)
1. What is a group of cells that runs horizontally?
_________________________________________________________
_________________________________________________________
2. What does a cell reference like “B3” represent in Excel?
_________________________________________________________
_________________________________________________________
VI. Answer the following in three or four sentences. (3 ×2=6)
1. Differentiate between a workbook and a worksheet.
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
2.Define cell and cell address.
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
3.Suggest how MS Excel can be helpful for teachers.
Or
What are spread sheets?
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
