Invertis University markInvertis University logo Faculty Course Portal · 2026–27
Home › VOI001 › Sample Exam Paper I
Sample Exam Paper

VOI001Sample Examination Paper — I

Course: Introduction of MS Office (VOI001)Programme: B.Sc. ZBC (Zoology, Botany, Chemistry) — Semester I (Vocational/Skill Enhancement Course)
Time: 2 HoursMaximum Marks: 50

General Instructions:

  1. All questions in Section A are compulsory.
  2. Attempt any two parts from each question in Section B.
  3. Attempt any one question in full from Section C.
  4. A practical demonstration on the computer may accompany this paper as per the internal scheme.

Section A — Short Answer (Compulsory)

  1. What is the difference between hardware and software? (2 marks)
  2. Define the Ribbon and the Backstage view in MS Office applications. (2 marks)
  3. What is the purpose of Mail Merge in MS Word? (2 marks)
  4. Differentiate between relative and absolute cell referencing in Excel. (2 marks)
  5. What is the use of the IF() function in Excel? Give one example. (2 marks)
  6. What is a Slide Master in PowerPoint? (2 marks)
  7. What is the difference between CC and BCC in an email? (2 marks)

Section B — Attempt any two parts of each

  1. Explain the steps to perform Mail Merge in MS Word to send a personalized letter to a list of students. (5 marks)
  2. Explain, with examples, how relative, absolute and mixed cell references behave when a formula is copied across cells in Excel. (5 marks)
  3. Explain how to calculate the total marks and assign a grade to a student using Excel functions, based on given boundary conditions. (5 marks)
  4. Explain the difference between a transition and an animation in MS PowerPoint, with examples. (5 marks)
  5. Describe the basic components of MS Access — Tables, Queries, Forms and Reports. (5 marks)

Section C — Attempt any two questions in full

  1. Describe, step by step, how you would create a formatted bio-data/resume with a covering letter in MS Word, including the use of styles, tables and page layout features. (10 marks)
  2. Explain in detail how MS Excel can be used to calculate the total marks and grade of a class of students, covering the formulas/functions used, conditional formatting for highlighting failing students, and creating a chart to visualize class performance. (10 marks)