IT First Term Class 10 Solved Question Paper 2021-2022 | letsbug

IT First Term Class 10 CBSE

Section A

Answer any 5 questions out of the given 6 questions

1. There are many reasons why interpersonal communication may fail. While communicating, the message may not be received exactly the way the sender intended and therefore it is important that the communicator seeks _______ to check that their messages is clearly to understood

1. Description 
2. Feedback 
3. Channel 
4. Sign

Answer : 2. Feedback

2. Which one of the following is not a barrier to effective communication?

1. Physical barrier 
2. Linguistics barrier 
3. Interpersonal barrier 
4. Subjective barrier

Answer : 4. Subjective barrier

3. To perform well at work and life in general, you must be able to manage and improve yourself in various skills. Which one of the following skills helps you to prioritise the things you have to do remove waste and redundancy from work ?

1. Responsibility
2.  Time management 
3.  Self awareness 
4.  Adaptability 

Answer : 2. Time management

4. Managing stress is about making a plan to be able to cope effectively with daily pressures . Always keep in mind the ABC of stress management. The acronym ABC stands for :

1.  Ability, burden , concise 
2.  Adore , belief , cause 
3.  Adversity , beliefs, consequences 
4.  Adapt , balance , co-operate 

Answer : 3. Adversity , beliefs, consequences

5. Neha is receiving several mails from companies who are advertising a product or trying to attract her their website. Sach type of mails are called ______

1.  Advertising mails 
2.  Bulk mails
3.  Spam mail's 
4.  Labelled mails

Answer : 3. Spam mail'

6. A computer automatically runs a basic program called ____ as soon as it is switched on or the power button is push on. 

1.  BIOS ( Basic  Input / Output system)
2.  IOS ( Input / Output / System)
3.  BOSS (Basic On System Startup)
4.  POS ( Power On System)

Answer: 1. BIOS ( Basic  Input / Output system)

Section B 

Answer any 15 questions out of the given 20 questions 

7. Styles help to improve consistency in a document . Indentify the style that is used to format graphic and texts frames, including wrapping type , boarders ,  background and columns .

1.  Numbering 
2.  Character 
3.  Graphics 
4.  Frame 

Answer : 4. Frame 

8. Arguments passed to a macro calc are always ____

1.  Strings 
2.  References 
3.  Numbers 
4.  Values

Answer: 4. Values

9. In document, ____ is used to apply to a style to many different areas quickly without having to go back to the styles and formatting window and double-cick every time.

1. Fill format mode 
2.  Formatting window 
3.  Painter mode 
4. Text wrapping

Answer : 1. Fill format mode

10. Tanu explained his class that to apply an exciting style, except for position the insertion point in the paragraph, frame or Page then double- click on the name of the style in one this line 

1. Windows style 
2. Character style 
3.  Paragraph style 
4.  Cell style

Answer: 2. Character style

11. The _____ windows show the type of styles available for the OpenOffice ( OpenOffice.org) components you are using 

1.  Styles and formatting 
2.  Font and formatting 
3. Insert 
4.  Edit 

Answer: 1. Styles and formatting

12. In writer,______ refers to the reference point  for the graphics. This  point could be the page or frame where the object is, a paragraph on even a character .

1. Arrangement 
2. Anchoring 
3.  Framing 
4.  Text wrapping

Answer: 2. Anchoring

13. _____ function text data from a series of worksheet all work books and summaries into a single worksheet that you can update easily 

1. Summation 
2.  Data consolidation 
3.  Data Format 
4.  Data Chart 

Answer: 2. Data consolidation

14. Two other toolbars can be open from picture toolbar are : the ____ and ____ 

1.  Edit picture, colour picture
2.  Format, drawing
3.  Graphics filter toolbar , colour toolbar
4.  Floating toolbar, colour toolbar

Answer: 3. Graphics filter toolbar , colour toolbar

15. If you are continually working with the same range, then you may give a name to the range using ____ option under Data Menu

1. Define data 
2.  Define range 
3.  Define reference 
4. Define address

Answer: 2. Define range

16. In Cala , using the subtotal dialog , you can select arrays and then choose a statistical function to apply to them . For efficiency, you can choose up to ____ groups of the array to which to apply a function .

1. Two 
2. Three 
3.  Four 
4.  Five

Answer : 2. Three

17. Solve option under Tools menu amounts to a more elaborate from of ____ . The difference is that the solver deals with equations with multiple _____ .

1. Unknown variables, Goals seek 
2.  Variable , equation 
3.  Goal seek , unknown variables 
4.  Subtotal , Goal seek 

Answer: 3. Goal seek , unknown variables

18. Usually , you run a formula to calculate a result based upon existing values . By contrast, using ____ , you can discover what values will produce the result that you want .

1.  Subtotal 
2.  Scenario 
3.  Sort Lists 
4.  Goal seek 

Answer : 4. Goal seek 

19. Rama and two of her friends are doing survey of gender wise employment rates of their locality as a school project using spreadsheet. They all want to work simultaneously to complete it on time. What option there should used to access the same spreadsheet to speed up their work. 

1.  Consolidated Worksheet 
2.  Shared Worksheet 
3.  Link Worksheet 
4.  Local Worksheet 

Answer: 2. Shared Worksheet 

20. In Calc, you can use a cell reference in one or several formulas to refer to : 

1. Data from one or more contiguous cell on the worksheet. 
2.  Data contained in any software 
3.  Data contained in any format in database 
4.  Images in picture gallery 

Answer: 1.Data from one or more contiguous cell on the worksheet. 

 21. Which one of the following is an example of RDBMS? 

1.   MongoDB 
2.  Windows registry 
3.  Publisher 
4.  Oracle 

Answer : 4. Oracle

22. The ___ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems .

1.  Knowledge concept 
2. Formula concept 
3.  Database concept 
4. Forms concept 

Answer : 3. Database concept 

23. Writer's table of contents features let's you build an automated table of contents from the ____ in your document

1. Template 
2.  Style 
3. Heading 
4.  Table's 

Answer : 3. Heading

24. In Calc, to crate the reference with the mouse : 

1.  Both spreadsheet need not to be equal 
2. Select the cell in which the formula is going to be entered 
3.  There is no need of '=' symbol 
4.  Cell reference is not required 

Answer: 1. Both spreadsheet need not to be equal 

25. ____ can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file , to different files or even  to website.

1. Table's 
2.  Goal seek 
3.  Auto sum 
4.  Hyperlinks

Answer:  4. Hyperlinks

26. Any settings that can be added to or modified in a document can be saved in a template. Which of the settings below cannot be included in writers Document and saved as a template for later use ?.

1. Styles for laters use 
2.  Printer settings 
3.  Format and setting of tables 
4. Formula settings

Answer : 4. Formula settings

SECTION C 

Answer any 5 questions out of given 7 questions 

27. Remakant is running a business and has to send letters to a number of delegates. A _____ can be also a quick way to take a list of people's mailing addresses and generate labels or envelopes with the address for different persons on each label or envelope 

1. Mail Marge 
2.  E mail 
3.  Paragraph 
4.  Style 

Answer : 1. Mail Marge 

28. Vineeta has to prepare a report on her research work in which she needs to include images with text. Which features helps to balance the relation of graphics to the surrounding text , which may warp around  the graphic on one side aur both sides, be over printed behind or in front of the graphic or treat the graphic as accepted paragraph or character ? 

1.  Arrangement 
2.  Alignment 
3.  Table of content 
4.  Text wrapping

Answer:  4. Text wrapping

29. Jagriti has inserted an image in a document. She wants to resize the image. Which option of word processor image format should be selected to let the two dimensions ( height and width ) change so that proportion is maintained, allowing for a scaled recising ?

1. Keep ratio 
2. Keep aspect 
3. Crop 
4.  Contrast 

Answer: 1. Keep ratio

30. Statement I : The data from the consolidation range and target range are saved when you save the worksheet.
Statement II : If you leter open a worksheet in which consolidation has been defined , this data will not be available again. 

Consider above two statements, identify the correct one 

1.  Statement I is wrong 
2.  Statement II is wrong 
3.  Both the statements I and II are wrong 
4.  Both the statements I and II are correct 

Answer: 2. statement is wrong

31. In Spreadsheets, 
Statement I : To consolidated to  labels or column labels , the label must be contented in the selected source rangers. 
Statement II: The text in the labels must be identical, so that row  or columns can be accurately matched.
Statement III : If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.

Consider the about three statements, identify the correct one

1.  Only statement I and II are correct
2.  Only statement II and III are correct
3.  Only statement II is correct
4.  All statements are correct

Answer: 4. All statements are correct 

32. Malini wants to store huge amount of information about her zone in database. Should not be repeat in her file. Har friend Gargi explain her various benefits of storing data in RDBMS . It helps in preventing/ controlling duplicates of data. Which of the following terms is used to referred to duplication data ? 

1. Data sharing 
2. Data privacy 
3.  Data redundancy 
4.  Data integrity 

Answer : 3. Data redundancy

33. Rohan has Rs 50,000 that he wants to invest into mutual funds for one  year. Fund A is a low risk fund with 80% interest rate and fund B is higher risk fund with 21% interest rate. Which feature of spreadsheet ( Calc) will be help him to decide ?

1. Solver 
2. Subtotal 
3. Linking sheets 
4.  Macros

Answer : 1. Solver