1. What is kept on ________ table.
a) an
b) the
c) of
d) a
2. The chemist shop is right next ____ the hospital. (for, to).
Ans: to
3. www stands for ________________ .
a) Whole World Web
b) World Wide Web
c) World With Web
d) Web Web Web
4. _____________ is designed to help users with auditory impairments.
a) Filter Key
b) Toggle Keys
c) Sound Sentry
d) Serial Key
5. Default tab stop position is __________ .
Ans: 0.5"
6. __________ can be used to break continuous text to one or more sentences.
Ans: Paragraph
7. __________ can be used for inserting information at the top of each page automatically.
Ans: Header
8. AutoSum option is available in __________ group under the Home tab.
Ans: Editing
9. __________ are used for playing sound files while making a presentation.
Ans: Audio Clips
10. Selecting the __________ view shows calendar for a month.
Ans: Month
11. You can categorize appointments in time management software by giving specific __________ to appointments.
Ans: Colours
12. A __________ creates a timeline of transactions that can be linked to a contact.
Ans: Journal
Very short Answer Questions (5X2=10)
13. Rohan’s father told him that they need to attach a modem for internet connection on their computer. Explain the meaning and function of modem to Rohan.
Ans: A MODEM is a device that converts digital computer signals into analog signals that can travel over phone lines. It also re-converts the analog signals back into digital signals. The word MODEM is derived from its function MOdulator/DEModulator.
14. What are document templates? State the purpose of using document template.
Ans: Templates or document templates refer to a sample fill-in-the-blank document or pre-defined layout that can help in saving time. Usually templates are customized documents that may have sample content, themes, etc. For example, if you want to create a resume you can use a resume template and modify only the sections that require changes.
15. What are Clip arts? List any two websites that offer free clipart.
Ans: Clip arts are pre-defined images available for use in documents. Clip Art can help in making a document look colourful and presentable.
Name of two valid websites that offer free clipart: Freepik, pngtree
16. Explain any two types of views available in Spreadsheet.
Ans: Two types of views are:
Normal View: The default view of the spreadsheet application is the Normal. It is a collection of cells arranged in the work area.
Page Layout: You can select the Page Layout view in order to quickly fine tune a worksheet that contains many charts or huge amounts of data and achieve professional looking results.
17. Explain the purpose of grouping objects in a Digital presentation.
Ans: Grouping can help when you want to move, rotate or resize multiple objects in a presentation. You can group objects such as pictures, clip art, shapes and text box; once grouped they appear as a single object.
18. Differentiate between Animation and Transition in digital presentation.
Ans: Animations are used for applying effects on objects and text where as Transitions are used for applying animation effects between the slides.
19. Pulkit has got a proposal for a meeting through Calendar. Suggest four types of responses that are available under calendar software.
Ans: Four types of responses for a meeting are:
(i) Accept (ii) Tentative (iii) Decline (iv) Propose New Time options
Short Answer Questions (5X3=15)
20. A stranger has helped your grandfather and you want to appreciate him for the help extended by him. Write any three lines to thank him.
Ans: (i) Thanks a lot!
(ii) Thanks! You helped my grandfather.
(iii) Thanks! I really appreciate your help
21. You have recently visited a hill station. Describe it using appropriate phrases.
Ans: Recently, I visited a beautiful hill station nestled among misty mountains and lush green valleys. The journey itself was filled with winding roads, cool breezes, and breathtaking views of forests and waterfalls. The weather was pleasant and refreshing, a perfect escape from the summer heat.
The town was surrounded by snow-capped peaks, blooming flowers, and tall pine trees. Early in the morning, the hills were covered with a soft blanket of fog, making everything look magical. The peaceful environment, chirping birds, and flowing streams made the place calm and relaxing.
22. List any three word wrapping options available under Word Processing software.
Ans: Various word wrapping options are:
(i) In line with text
(ii) Square
(iii) Tight
(iv) Through
(v) Top and bottom
(vi) Behind text
(vii) In front of text
23. Write steps to insert shape in a word document.
Ans: Steps to insert shapes are:
Step 1: Click on the Insert tab on the Ribbon. Click on the option Shapes in the Illustrations group
Step 2: Once you click the Shapes option a dropdown list with pre-defined shapes such as box, circle, etc. appears.
Step 3: Select the shape from the list of shapes available and draw the shape by dragging the mouse with the left button clicked. For example, if you like to insert a square, select the box shaped item from the list, click and drag the shape to draw a square.
24. Yashika is preparing a Digital Presentation for her project. Give any three basic guidelines to be followed while making a digital Presentation.
Ans: (i) Keep slides simple and clear: Use short points instead of long paragraphs so the audience can easily understand the content.
(ii) Use readable fonts and proper size: Choose simple fonts and make sure the text is large enough to be seen clearly.
(iii) Use images and colors wisely: Add relevant pictures and use limited colors to make slides attractive without making them crowded.
25. Ankush has to present monthly report of his department to his managing committee. Suggest him with appropriate tools to do the following in a digital presentation:
(a) To show statistical data pictorially for analysis.
Ans: Charts may be used
(b) Two ways to insert movie in his presentation.
Ans: You can insert a movie in two ways: (a) Using Insert tab (b) Using Title and Content Layout Option
(c) Which option he shall use to keep guided text used by presenter.
Ans: He should use Presenter View in Slide Show Tab
26. Define the following terms:
(a) Tuple - A row also called a record or tuple represents a single, data item in a table.
(b) Foreign Key - The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
(c) DBMS - Database Management System is a software package with computer programs that controls the creation, maintenance, and use of a database.
SECTION B
Long Answer Questions (5X3=15)
27. Ananya uses Internet for her School Project. Suggest any five security measure to ensure safety from online threats.
Ans: Five safety measures:
i) Use antivirus and antispyware software
ii) Use strong passwords
iii) Backup your data:
iv) Use encryption software
v) Keeping your username and password private
vi) Do not share personal information
28. Explain the following terms:
(a) Internet - The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite to serve billions of users worldwide.
(b) LAN - A local area network (LAN) is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.
(c) Instant Messaging - Instant messaging (IM) is a form of communication over the Internet that offers an instantaneous transmission of text-based messages from sender to receiver.
(d) Blog - A blog is a discussion style site used by non-technical (and technical users) users for creating personal web pages.
(e) P2P Architecture - (Peer to Peer) Networks in which all computers have an equal status are called peer to peer networks.
29. Write command to create table named ‘BOOK ‘ with following fields:
| Field Name |
Data Type |
| BOOK_ID |
CHAR(4) |
| Bname |
VARCHAR(15) |
| Author |
VARCHAR(20) |
| Price |
DECIMAL |
Ans: Create table BOOK (BOOK_ID char(4), Bname varchar(15), Author varchar(20), Price Decimal);
(a) Identify the primary key of the Book Table, also mention the suitable reason for choosing it as a Primary Key
Ans: Book_ID may be chosen as the Primary key because every book has a unique id that may be used to identify the book.
(b) Differentiate between (i) char and varchar data type (ii) DDL and DML
Ans: char and varchar data type: CHAR and VARCHAR are both used to store text in a database, but CHAR stores fixed-length data while VARCHAR stores variable-length data. This means CHAR always uses the full space given to it even if the word is small, whereas VARCHAR uses only the space needed for the text. For example, if CHAR(10) stores the word “RAM”, it will still use 10 characters by adding blank spaces, but VARCHAR(10) will use only 3 characters. CHAR is faster but wastes space, while VARCHAR saves memory.
DDL and DML: DDL (Data Definition Language) is used to create and change the structure of database tables, while DML (Data Manipulation Language) is used to add, update, and delete data inside those tables. In simple words, DDL is used to make and modify tables, and DML is used to work with the records stored in them. Examples of DDL commands are CREATE, ALTER, and DROP, while examples of DML commands are INSERT, UPDATE, and DELETE.
30. Write the SQL commands to answer the queries based on Fabric table
FabricID | Fname | Type | Disc |
|---|
F001 | Shirt | Woollen | 10 |
F002 | Suit | Cotton | 20 |
F003 | Tunic | Cotton | 10 |
F004 | Jeans | Denim | 5 |
F005 | Shorts | Cotton | 7 |
(a) To insert the following record
(“F005”, “Kurta”, “Woollen”,5)
Ans: insert into Fabric values (‘F005’, ‘Kurta’, ‘Woollen’,5);
(b) To display only those fabric whose disc is more than 10
Ans: select * from Fabric where Disc>10;
(c) To display those records whose type is “Woollen”
Ans: select * from Fabric where type = ‘Woollen’;
(d) To modify the fabric shirt by increasing discount by 10
Ans: update fabric set Disc =Disc + 10 where Fname = ‘Shirt’;
(e) To delete the record of fabric ‘F003’ from table
Ans: delete from Fabric where FabricID =‘F003’;
31. Given the following Spreadsheet, Write the appropriate Formula/ Expression/ Function to be used for (a) to (e)
(a) Write formula to calculate the Total Qty(C4:C7)) in cell C8
Ans: =sum(C4:C7)
(b) Write the feature used for arranging the Price from Highest to Lowest
Ans: Sort in ‘Sort and Filter’ group under Data tab
(c) To find the Maximum Price to be written in Cell D10
Ans: = max(D4:D7)
(d) To find the Average Qty to be written in cell C9
Ans: = average( C4:C7)
(e) Write formula to calculate the Total Amount in cell E8
Ans: = sum(E4: E7)
Download Now - Class 10 IT 402 Sample Question Paper 2025-26 with Solution
