Certainly, here's a sample 50-mark question paper for a computer science exam with a focus on MS Word and Excel, including various question types as requested:





[Your University/School Name]

Final Examination - Microsoft Word and Excel

Duration: 2 Hours

Total Marks: 50

Section A: Short Questions (5 Marks Each)

  1. In MS Word, explain how to create a numbered list with three levels of indentation.

  2. In Excel, describe the purpose of the SUM function and provide an example of its usage.

  3. What is the function of the "Find and Replace" tool in MS Word, and how can it be used effectively?

  4. Explain how to insert a new worksheet in an existing Excel workbook.

  5. Describe the difference between a cell reference with an absolute ($) and a relative cell reference in Excel.

Section B: Longer Questions (10 Marks Each)

  1. Using MS Word, create a step-by-step guide on how to insert and format a table with three rows and three columns.

  2. In Excel, create a budget spreadsheet that includes income, expenses, and calculates the total balance. Explain your formula and formatting choices.

  3. Discuss the advantages of using Excel's charts and graphs to present data effectively. Provide an example of a chart and its application.

  4. Describe the process of creating and applying styles in MS Word to format text and paragraphs consistently.

  5. In Excel, demonstrate how to create a pivot table and explain its utility in data analysis.

Section C: True or False (5 Marks Each)

  1. True or False: In MS Word, the "Page Layout" tab allows you to adjust margins, orientation, and page size.

  2. True or False: In Excel, functions like SUM, AVERAGE, and MAX can be used to perform calculations on data in a worksheet.

  3. True or False: You can add a password to protect an entire MS Word document from unauthorized access.

  4. True or False: In Excel, a cell can contain text, numbers, and formulas simultaneously.

  5. True or False: The "Find and Replace" feature in Excel can only search for text, not numbers or formulas.

Section D: Fill in the Blanks (5 Marks Each)

  1. To save a document in MS Word, go to the _______________ tab and select "Save."

  2. In Excel, the function _______________ is used to find the largest value in a range.

  3. The process of adjusting the width of columns and the height of rows in Excel is known as _______________.

  4. In MS Word, the feature that automatically corrects common spelling and typing errors is called _______________.

  5. To merge two or more cells in Excel, you can use the _______________ feature.

Section E: Matching Questions (5 Marks)

Match the MS Word or Excel feature on the left with its corresponding description on the right:

MS Word / Excel FeatureDescription
1. AutoFillA. A tool to check spelling and grammar
2. Page BreakB. Automatically fills cells with data
3. Spell CheckC. Separates content onto a new page
4. Formula BarD. Displays the contents of a cell
5. Header/FooterE. Adds text or graphics to the top/bottom of a page

Section F: Full Forms (5 Marks Each)

  1. Expand the following acronyms:
    • MS Word: _______________
    • MS Excel: _______________
    • PDF: _______________
    • HTML: _______________
    • CPU: _______________

Other 3-Mark Questions to Fill 50 Marks

  1. What is the primary function of the "Mail Merge" feature in MS Word?
  2. Explain the purpose of conditional formatting in Excel.
  3. How can you insert a hyperlink in an MS Word document?
  4. Define the term "cell reference" in the context of Excel.

Instructions:

  • Answer all questions.
  • Marks are indicated next to each question.
  • For Section B, provide detailed explanations and examples.
  • For Section C, mark "True" or "False."
  • For Section D, fill in the blanks with the correct terms.
  • For Section E, match the features with their descriptions.
  • For Section F, expand the acronyms provided.

Feel free to use and modify these questions to create your question paper as needed.