Class 10 IT Code 402 Previous Year Question Paper 2022 – Term 1 – Solution

Series JSK/1
Question Paper Code 089/1/4

INFORMATION TECHNOLOGY
Term I (Session 2021-22) – SOLUTION

Time allowed: 60 Minutes
Maximum Marks: 25

General Instructions:

  1. Please read the instructions carefully.
  2. This question paper is divided into 3 sections, viz., Section A, Section B and Section C.
  3. Section A is of 5 marks and has 6 questions on Employability Skills.
  4. Section B is of 15 marks and has 20 questions on Subject Specific Skills.
  5. Section C is of 5 marks and has 7 Competency-Based Questions.
  6. Do as per the instructions given in the respective sections.
  7. Marks allotted are mentioned against each section.
  8. All questions must be attempted in the correct order.

SECTION A
(Employability Skills)

Answer any 5 questions out of the given 6 questions. (5×1=5)

1. There are many reasons why interpersonal communications 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 message is clearly understood.
(a) Description
(b) Feedback
(c) Channel
(d) Sign

2. Which one of the following is not a barrier to effective communication?
(a) Physical barrier
(b) Linguistic barrier
(c) Interpersonal barrier
(d) 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 of the following skills helps you to prioritize the things you have to do remove waste and redundancy from work?
(a) Responsibility
(b) Time management
(c) Self awareness
(d) Adaptability

4. Managing stress is about making a plan to be able to cope effectively with daily pressure. Always keep in mind the ABC of stress management. The acronym ABC stands for:
(a) Ability, Burden, Concise
(b) Adore, Belief, Cause
(c) Adversity, Believes, Consequences
(d) Adapt, Balance, Cooperate

5. Neha is receiving several mails from companies who are advertising a product or trying to attract her to their websites. Such type of mails are called _____
(a) Advertising mails
(b) Bulk mails
(c) Spam mails
(d) Labelled mails

6. A computer automatically runs a basic program called ______ as soon as it is switched on or the power button is pushed on.
(a) BIOS (basic input output system)
(b) IOS (input output system)
(c) BOSS (basic on system startup)
(d) POS (power on system)

SECTION B
(Subject Specific Skills)

Answer any 15 questions out of the given 20 questions (15X1=15)

7. Styles help to improve consistency in a document. Identify the style that is used to format graphics and text frames, including wrapping type, borders, background and columns.
(a) Numbering
(b) Character
(c) Graphics
(d) Frame

8. Arguments passed to a macro from Calc are always _____.
(a) Strings
(b) References
(c) Numbers
(d) Values

9. In a document, ______ is used to apply style to many different areas quickly without having to go back to the styles and formatting window and double-click every time.
(a) Fill format mode
(b) Formatting window
(c) Painter mode
(d) Text wrapping

10. Tanu explained his class that to apply and existing style, except for _____, position the insertion in the paragraph, frame or page and then double click on the name of the style in one of these lists.
(a) Window style
(b) Character style
(c) Paragraph style
(d) Cell style

11. The __ window shows the types of styles available for the OpenOffice (openoffice.org) component you are using.
(a) Styles and formatting
(b) Font and formatting
(c) Insert
(d) Edit

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 or even a character.
(a) Arrangement
(b) Anchoring
(c) Framing
(d) Text wrapping

13. ____ function takes data from a series of worksheets or workbooks and summarize it into a single worksheet that you can update easily.
(a) Summation
(b) Data consolidation
(c) Data format
(d) Data chart

14. To other toolbars can be opened from picture toolbar are: the ____ and ____.
(a) Edit picture, colour picture
(b) Format, drawing
(c) Graphics filter toolbar, colour toolbar
(d) Floating 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.
Define data
Define range
Define reference
Define address

16. In Calc, using the Subtotals dialog, you can select arrays and then choose a statistical function to apply to them. For efficiency, you can choose up to __ groups of array to which two apply a function.
Two
Three
Four
Five

17. Solve option under Tools menu amounts to a more elaborate form of _____. The difference is that the Solver deals with equations with multiple _____.
(a) Unknown variables, Goals Seek
(b) Variables, Equation
(e) Goal Seck, Unknown variables
(d) Subtotal, Goal seek

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.
(a) Subtotal
(b) Scenario
(c) Sort Lists
(d) Goal Seek

19. Rama and two of her friends are doing survey of genderwise employment rates of their locality as a school project using Spreadsheet, They all want to work simultaneously to complete it on time. What option they should use to access the same Spreadsheet to speed up their work.
(a) Consolidate Worksheet
(b) Shared Worksheet
(c) Link Worksheet
(d) Lock Worksheet

20. In Cale, you can use a cell reference in one or several formulas to refer to:
(a) Data from one or more contiguous cells on the worksheet
(b) Data contained in any Software
(c) Data contained in any format in databases
(d) Images in picture gallery

21. Which one of the following is an example of RDBMS ?
(a) MongoDB
(b) Windows registry
(c) Publisher
(d) Oracle

22. The _____ has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining complex information systems.
(a) Knowledge concept
(b) Formula concept
(c) Database concept
(d) Forms concept

23. Writer’s table of contents feature lets you build an automated table of contents from the _____ in your document.
(a) Template
(b) Style
(c) Headings
(d) Tables

24. In Cale, to crate the reference with the mouse :
(a) Both Spreadsheets need not be open
(b) Select the cell in which the formula is going to be entered
(c) There is no need of =” symbol
(d) Cell reference is not required

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 websites.
(a) Tables
(b) Goal Seek
(c) AutoSum
(d) 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 Writer’s Document and saved as a template for later use ?
(a) Styles for later use
(b) Printer settings
(c) Format and setting of tables
(d) Formula settings

SECTION C
(Competency-Based Questions)

Answer any & questions out of the given 7 questions.

27. Remakant is running a business and has to send letters to a number of delegates. A ______ can also be 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.
(a) Mail Marge
(b) E-mail
(c) Paragraph
(d) Style

28. Vineeta has to prepare a report on her research work in which she needs to include images with text. Which feature helps to balance the relation of graphic to the surrounding text, which may wrap around the graphic on one side or both sides, be overprinted behind or in front of the graphic or treat the graphic as a separate paragraph or character?
(a) Arrangement
(b) Alignment
(c) Table of content
(d) Text wrapping

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

30. Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
Statement IT: If you later open a worksheet in which consolidation has been defined, this data will not be available again.
Consider above two statements, identify the correct one.
(a) Statement I is wrong
(b) Statement II is wrong
(c) Both the Statements I and II are wrong
(d) Both the Statements I and II are correct

31. In Spreadsheets,
Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.
Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.
Statement III: If the row or column label does not mateh any that exist in the target range, it will be appended as a new row or column.
Consider the above three statements, identify the correct one.
(a) Only Statements I and Il are correct
(b) Only Statements II and III are correct
(c) Only Statement Il is correct
(d) All the Statements are correct

32. Malini wants to store a huge amount of information about her zone in a database. Should not be repeated in her file. Her friend Gargi explained her various benefits or storing data in RDBMS, It helps in preventing/controlling duplication of data. Which of the following terms is used to refer to duplication data ?
(a) Data sharing
(b) Data privacy
(c) Data redundancy
(d) Data integrity

33. Rohan has Rs. 50,000 that he wants to invest in two mutual funds for one year. Fund A is a low risk fund with 18% interest rate and Fund B is a higher risk fund with 21% interest rate. Which feature of spreadsheets (Calc) will be help him to decide?
(a) Solver
(b) Subtotal
(c) Linking sheets
(d) Macros

Class 10 Information Technology Previous Year Question Papers

Class 10 Information Technology Previous Year Question Papers Solution

Class 10 Information Technology Previous Year Compartment Question Papers

Class 10 Information Technology Previous Year Compartment Question Papers Solution

Leave a Comment