Class 12 Typography & Computer Application 817 Previous Year Question Paper 2023 – Solution

by

Series ƩHEFG
Question Paper Code 341 Set 4

TYPOGRAPHY & COMPUTER APPLICATION – SOLUTION UPDATING…
(Session 2022-23)

Time allowed : 3 hours
Maximum Marks : 60

General Instructions :

  1. Please read the instructions carefully.
  2. This question paper consists of 24 questions in two Sections : Section A and Section B.
  3. Section A has Objective type questions whereas Section B contains Subjective type questions.
  4. Out of the given (6 + 18) = 24 questions, a candidate has to answer (6 + 11) = 17 questions in the allotted (maximum) time of 3 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (30 marks) :
    • This section has 6 questions.
    • There is no negative marking.
    • Do as per the instructions given.
    • Marks allotted are mentioned against each question/part.
  7. Section B : Subjective Type Questions (30 marks) :
    • This section has 18 questions.
    • A candidate has to do 11 questions.
    • Do as per the instructions given.
    • Marks allotted are mentioned against each question/part.

Section A – (Objective Type Questions) (30 Marks)

1. Answer any 4 questions out of the given 6 questions on employability skills. (4X1=4)

(i) If a goal is attainable, then which kind of goal is it ?
Answer: Realistic

(ii) In which type of motivation is there no reward, but one can derive satisfaction from it ?
Answer: intrinsic motivation

(iii) Which symbol is used to add any formula in the cell ?
Answer: = (equal sign)

(iv) If a text is set towards left, right or center, which function is it called ?
Answer: text alignment

(v) Name the person who introduced a new and innovative technology to maximise agricultural produce.

(vi) Which is an initiative of the Government of India that intends to build an ecosystem for the growth of Startups ?
Answer: Startup India

2. Answer any 5 out of the given 7 questions. (5X1=5)

(i) E-correspondence has also become extremely essential for ____ business.
Answer: online

(ii) Write the full form of B2B and C2B.
Answer: B2B: Business-to-Business
C2B: Consumer-to-Business

(iii) ____ is used by the competent authority for issuing instructions for internal administration.
Answer: Memorandum

(iv) The other name of Inter-departmental note or Unofficial note is ____.
Answer: Demi-Official Letter (D.O. Letter)

(v) To become an efficient Office Assistant one should attain mastery in ____ signs.
Answer: shorthand

(vi) —->| Write the meaning of this sign.

(vii) Which manuscript sign is used to insert the matter in the margin ?
Answer: caret (^)

3. Answer any 6 out of the given 7 questions. (6X1=6)

(i) An Excel form is part of the ____.
Answer: Microsoft Office Suite (Package)

(ii) By default, which three commands does Quick Access Toolbar contain ?
Answer: Save, Undo, Redo

(iii) Fill handle is provided in the ____ corner of the cell.
Answer: Bottom-right

(iv) Write the mouse action by which the entire row gets selected.
Answer: Click the left mouse button on the leftmost edge of the row number that you want to select.

(v) Active cell is a component of spreadsheet. (True or False)
Answer: True

(vi) To move the cell contents only a short distance, the ____ method is used.
Answer: Drag and Drop

(vii) ____ is used to lock specific row or column.
Answer: Freeze Panes option

4. Answer any 5 out of the given 6 questions. (5X1=5)

(i) Which software is used for Speaker Notes and Handouts ?
Answer: PowerPoint

(ii) ____ Panel appears on the right-hand side of the current slide.
Answer: Slide Thumbnails

(iii) The shortcut key to start a Presentation from the current slide is ____.
Answer: Shift + F5

(iv) We need the services of the Search Engine for ____ the document on the Internet.
Answer: searching or locating

(v) ____ is an example of Web Directory.
Answer: Yahoo! Directory
Yahoo! Directory, in its original form, was eventually shut down in 2014.

(vi) Write the full form of “Google”.
Answer: Global Organization of Oriented Group Language of Earth

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

(i) ____ operator is used to expand the search.
Answer: asterisk (*)

(ii) ____ is called an Indian Search Engine and it is powered by Google.
Answer: Bolo

(iii) ____ is a quick and inexpensive way to stay in touch with the near and dear ones.
Answer: Email

(iv) Electronic mail is stored in the ____.
Answer: inbox

(v) The compose button is provided on the ____ side of your Gmail page.
Answer: left

(vi) ____ icon at the bottom of the compose window refers to an attachment.
Answer: paperclip

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

(i) All deleted mails are placed at the ____.
Answer: “Trash” or “Deleted Items” folder

(ii) Viruses are classified on the basis of their nature of ____ and behaviour.
Answer: code

(iii) Computer virus is an ____ virus.
Answer: executable

(iv) ____ is the main reason of virus infection in computers.
Answer: Downloading files from untrusted sources

(v) Write any two Operating Systems available in the market.
Answer: Windows and MacOS

(vi) ____ virus has been known to damage and infect the entire LANS.
Answer: Worm

Section B (Subjective Type Questions) (30 Marks)

Answer any 3 questions out of the given 5 questions on employability skills. Answer each question in 20-30 words. (3X2=6)

7. Name and explain three parameters that describe an individual’s personality.
Answer: Three parameters that describe an individual’s personality include:
(i) Traits: These are the things that make you who you are, like being a quiet or outgoing person.
(ii) Temperament: It’s about how you naturally feel and react to things, like being happy or easily upset.
(iii) Values: These are your inner beliefs that help you decide what’s right or wrong and guide your choices in life.

8. Explain two ways by which one can become result-oriented.
Answer: Two ways by which one can become result-oriented are:
(i) Set Clear Goals: To become result-oriented, define specific, measurable, achievable, relevant, and time-bound (SMART) goals.
(ii) Prioritize and Plan: Break down tasks into manageable steps, prioritize them based on their impact on the desired results, and create a structured plan.

9. Name and explain types of data entry in Excel.
Answer: In Excel, there are various types of data entry methods, including:
(i) Manual Data Entry: This involves manually typing and suitable for small datasets.
(ii) Copy and Paste: You can copy data from a website or another Excel file and paste it into Excel.
(iii) Data Import: Excel provides tools for importing data from external sources such as databases, text files, or websites.
(iv) Using Formulas: Data can be entered into cells using Excel formulas or functions.

10. How will you use Format Painter in Excel ?
Answer: To use Format Painter in Excel, select a cell with the desired formatting, click the “Format Painter” icon, and then click on the cell or range where you want to apply the same formatting.

11. Who is a Social Entrepreneur ?
Answer: A social entrepreneur is an individual who applies innovative and sustainable business strategies to address social and environmental issues, aiming to create positive, impactful change alongside financial sustainability.

Answer any 3 out of the given 5 questions in 20-30 words each. (3X2=6)

12. Name the different types of official correspondence.

13. Write the meanings of the following signs :
ഗ, SP, //, #

14. What is the difference between row and column ?

15. Explain the steps to print a PowerPoint Presentation.

16. Define Search Engine.

Answer any 2 out of the given 3 questions in 30-50 words each. (2X3=6)

17. Explain the Mathematical operators in Excel.
Answer: In Excel, mathematical operators are symbols or characters used to perform various mathematical calculations within formulas. The common mathematical operators in Excel include:
Addition (+): The plus sign is used to add numbers together. For example, “=A1 + B1”
Subtraction (-): The minus sign is used for subtraction. For example, “=A2 – B2”
Multiplication (*): The asterisk is used for multiplication. For example, “=A3 * B3”
Division (/): The forward slash is used for division. For example, “=A4 / B4”
Exponentiation (^): The caret (^) symbol is used for exponentiation. For example, “=A5^2” raises the value in cell A5 to the power of 2.
Concatenation (&): The ampersand (&) is used to combine text or numbers. For example, “=A6 & ” ” & B6″ combines the text or values in cells A6 and B6 with a space in between.

18. What do you understand by Slide Show ?

19. Write down the basic action of E-mail.

Answer any 3 out of the given 5 questions in 50-80 words each. (3X4=12)

20. Explain the difference between Official correspondence and Business correspondence.

AspectOfficial CorrespondenceBusiness Correspondence
NatureWithin government institutionsWithin and between businesses
PurposeGovernance, policies, complianceCommercial activities, relationships
RecipientsGovernment officials, agenciesCustomers, clients, suppliers
FormalityFormal, standardized formatsVaries in formality
ContentLegal, regulatory, officialCommercial, product info, sales
Legal ImplicationsOften has legal significanceInvolves contractual agreements

21. Explain the basic properties of formula.
Answer: Formulas in Excel are mathematical expressions used to perform calculations. They comprise input values, operators (+, -, *, /), functions (e.g., SUM, AVERAGE), and cell references.
Formulas are dynamic, recalculating when input values change, ensuring accuracy. They allow for consistency by adapting references when copied. Parentheses () control the order of operations, and errors may occur if a formula is incorrectly structured or references missing cells. Overall, formulas are a fundamental feature of Excel, enabling data analysis, mathematical operations, and automation of tasks within spreadsheets.

22. What is a Presentation and what are its uses ?
Answer: A presentation is a visual and/or verbal communication of information, ideas, or a message to an audience. It typically involves a speaker or presenter conveying content through various media, such as slides, images, text, and sometimes audio or video, to engage and share the informmation with the audience. Presentations can be delivered in person, online, or in recorded formats.
Uses of presentations include:
(i) Business Meetings: Presentations are commonly used in business meetings to share reports, proposals, and updates with colleagues, clients, or stakeholders.
(ii) Educational Instruction: Teachers and trainers use presentations to deliver lessons and educational content to students or trainees.
(iii) Sales and Marketing: Presentations are essential for sales pitches, product demonstrations, and marketing campaigns to persuade and inform potential customers.
(iv) Conference Talks: Professionals and experts present their research, insights, and ideas at conferences and seminars to educate and engage their peers.
(v) Training and Workshops: Presenters conduct training sessions and workshops to transfer knowledge and skills to participants in a structured manner.
(vi) Public Speaking: Public speakers use presentations to influence, inspire, and inform large audiences during events or rallies.

23. Write the steps for finding information through Search Engine.
Answer: To find information through a search engine:
Step 1: Open your web browser.
Step 2: Visit a search engine like Google.
Step 3: Type your query in the search bar and press “Enter” or click the search icon.
Step 4: Browse the search results for relevant information and click on a search result to access the webpage.
Step 5: Use filters, advanced search options, or related queries to narrow down results for more precise information.

24. Name any four Antivirus software and explain how you can protect your PC from virus.
Answer: Four popular antivirus software programs are Norton Antivirus, McAfee, Bitdefender, and Avast.
To protect your PC from viruses:
(i) Install Antivirus Software: Choose a reputable antivirus program, install it, and keep it updated to detect and remove viruses.
(ii) Enable Real-time Scanning: Ensure your antivirus software is set to scan files and websites in real-time to catch threats as they occur.
(iii) Keep Software Genuine and Updated: Use genuine softwares and regularly update your operating system and software applications to patch security vulnerabilities.
(iv) Use a Firewall: Enable a firewall to control incoming and outgoing network traffic, adding an extra layer of protection.
(v) Regular Backups: Backup your important files to an external drive or cloud storage to prevent data loss from potential virus attacks.

Find Class 12 Typography & Computer Application Previous Year Question Papers

Find Class 12 Typography & Computer Application Previous Year Question Papers Solution

Find Class 12 Typography & Computer Application Previous Year Compartment Question Papers

Find Class 12 Typography & Computer Application Previous Year Compartment Question Papers Solution

2 thoughts on “Class 12 Typography & Computer Application 817 Previous Year Question Paper 2023 – Solution”

  1. Pingback: Class 12 Typography & Computer Application 817 Previous Year Question Paper 2023 » Learn CSE
  2. Pingback: Class 12 Typography & Computer Application 817 Previous Year Question Paper 2023 » Learn CSE

Leave a Comment