Cambridge International Sr.Sec.
School
Bhadana,Jhajjar
Unit Test-2 (2025-26)
Class: 7th Subject: Computer
Max.Marks:25 Time Allowed :45 Minutes
Name: ________________________ RollNo.: _______ Sec.:
Q.1Fill in the blanks:- (1*5=5)
(i) ________________ is a collection of inter -related data about a perticular subject.
(ii) Click on data validation button in ______________under data tab.
(iii) One way of colour feeling is by using ___________ tab in format cells dialog boxes.
(iv) ______________ is a process of making certain data bold or setting its font, size colour etc. to increase
readability and beauty of the spreadsheet.
(v) One way to apply formatting to numbers , text , date or time is by using __________tab in formatt cells
dialog box.
(vi) ______________ means only that data is accepted that satisfies specified condition (s).
Q.2 True/False :- (1*5=5)
(i) In excel, we may add a record in the database.
(ii) In excel we can not delete records from database.
(iii) Sorting is a process of arranging data in ascending or descending order of a particular field.
(iv) Excel cannot change the appearance of data without any change in its value.
(v) Entered text in a cell cannot be longer than the number of spaces in the cell.
(vi) Alignment refers to the position to which data is placed with in the boundary of a cell.
Q.3 M.C.Q. (1*7=7)
(i) By using Excel you can apply formatting on:
a) Numbers b) Text c) Date and time d) All the above
(ii) By default, numbers are _________ aligned.
a) Left b) Right c) Both d) None of these
(iii) Shortcut methods for formatting are available in ___________ tab.
a) Insert b) Home c) View d) None of these
(iv) Excel provides facility to fill a cell background with desired _______________.
a) color b) color pattern c) color style d) all of above
(v) Using Excel we can:
a) Add new record b) Delete a record c) Both a and b l d) None of these
(vi) To add new record , click on_____________ button available in quick access toolbar.
a) form b) New c) Create d) None of these
(vii) To sort data,click on sort button in___________ group in data tab.
a) sort & filter b) filter & merge c) Merge & sort d) None of these
(viii) Click on___________ button. Excel options dialog box is displayed.
a) Excel options b) Office options c) Both a and b d) None of these
Q.4 Application based questions:- (1*2=2)
(i) School office has large spreadsheet containing information about students. It often needs to access
selected data on the basis of specified criterion. What feature of Excel can help the office? Briefly explain that
feature.
(ii) Arjit has records of all the students of class 9. He wants to arrange them in ascending order of their
name. Suggest and explain Excel feature that can help him.
(iii) Sanjeev wants to display text in a cell at an angle of 45º instead of normal horizontal display. What
feature of Excel can help him in doing so?
Q.5 Answer the following:- ( 3*2=6)
(i) What do you mean by data formatting in excel?
(ii) Write steps to sort a range of data.
(iii) Write steps to delete a record in excel.
(iv) Write steps to fill color.
