MS Office Exam: Word, Excel, Access

Objectives: MS Office Exam: Word, Excel, Access

MS Office Exam: Word, Excel, Access

MS Office Exam: Microsoft Word, Excel & Access

Duration: 2 hours  |  Total Marks: 100

Instructions: Read carefully
Answer all sections
Printable: Yes

Part I — Microsoft Word (Total: 30 marks)

Time: 40 minutes

Section A — Multiple Choice (5 × 1 = 5 marks)

  1. Which file extension is used by default in Microsoft Word 2016 and later?
    a) .docb) .docxc) .txtd) .rtf
  2. Which shortcut is used to copy selected text?
    a) Ctrl + Vb) Ctrl + Cc) Ctrl + Xd) Ctrl + Z
  3. The feature that automatically corrects common spelling and typing errors is called:
    a) Find and Replaceb) AutoCorrectc) AutoFormatd) Spell Check
  4. Which tab in Word allows you to insert tables, pictures, and charts?
    a) Homeb) Insertc) Layoutd) References
  5. Which view is best for preparing a document for printing?
    a) Draft viewb) Outline viewc) Print Layout viewd) Web Layout view

Section B — Short Answer (5 × 2 = 10 marks)

  1. Define Word Processing. (2)
  2. Differentiate between Save and Save As. (2)
  3. What is the function of the Mail Merge feature? (2)
  4. Explain the difference between Header and Footer. (2)
  5. State any three uses of WordArt. (2)

Section C — Practical Tasks (3 × 5 = 15 marks)

  1. (5 marks) Create a document with a paragraph of at least 5 sentences. Change font to Times New Roman, size 14, color blue. Make the first sentence bold and underlined.
  2. (5 marks) Create a table (3 columns × 5 rows) with student names, subjects and marks. Apply borders and shading.
  3. (5 marks) Insert and resize a picture to 3cm × 3cm and apply a picture style.

Part II — Microsoft Excel (Total: 35 marks)

Time: 50 minutes

Section A — Multiple Choice (5 × 1 = 5 marks)

  1. Which file extension is the default for Microsoft Excel 2016 and later?
    a) .xlsb) .xlsxc) .csvd) .docx
  2. Which symbol is used before a formula in Excel?
    a) =b) +c) :d) *
  3. Which of the following is NOT a function in Excel?
    a) SUMb) AVERAGEc) TOTALd) COUNT
  4. The intersection of a row and a column in Excel is called:
    a) Boxb) Cellc) Fieldd) Block
  5. Which chart type is most suitable to show percentages?
    a) Line chartb) Pie chartc) Column chartd) Scatter chart

Section B — Short Answer (5 × 2 = 10 marks)

  1. Define Spreadsheet. (2)
  2. Differentiate between Workbook and Worksheet. (2)
  3. What is the difference between relative and absolute cell referencing? (2)
  4. List three uses of Excel in business. (2)
  5. Write the function to calculate the average of values from cell A1 to A10. (2)

Section C — Practical Tasks (4 × 5 = 20 marks)

  1. (5 marks) Create a worksheet with columns: Item Name, Quantity, Unit Price, Total. Enter 5 items and use a formula to calculate Total = Quantity × Unit Price.
  2. (5 marks) Using the given data, prepare a bar chart showing students' marks.
  3. (5 marks) In cell B10, write a formula to calculate the sum of B2:B9.
  4. (5 marks) Format the worksheet: bold headings, apply borders and shade the heading row light blue.

Part III — Microsoft Access (Total: 35 marks)

Time: 50 minutes

Section A — Multiple Choice (5 × 1 = 5 marks)

  1. Which of the following is the default file extension for Access 2016 and later?
    a) .mdbb) .accdbc) .dbfd) .xls
  2. In Access, a collection of related data organized in rows and columns is called:
    a) Recordb) Tablec) Fieldd) Query
  3. Which object is used to retrieve and filter data from a database?
    a) Tableb) Queryc) Formd) Report
  4. A unique identifier for each record in a table is called:
    a) Foreign Keyb) Indexc) Primary Keyd) Field Name
  5. Which view allows you to design the structure of a table in Access?
    a) Datasheet Viewb) Design Viewc) Layout Viewd) Form View

Section B — Short Answer (5 × 2 = 10 marks)

  1. Define Database Management System (DBMS). (2)
  2. Differentiate between a table and a query in Access. (2)
  3. What is the purpose of a primary key in a database? (2)
  4. State three uses of forms in Microsoft Access. (2)
  5. Explain the difference between a report and a form. (2)

Section C — Practical Tasks (3 × 6 = 18 marks)

  1. (6 marks) Create a new database named SchoolDB.accdb. Create a table Students with fields: StudentID (AutoNumber, PK), FullName (Text), Gender (Text), DateOfBirth (Date/Time), Class (Text). Add at least 5 records.
  2. (6 marks) Create a query to display only students in "Form Four". Show the SQL or design steps.
  3. (6 marks) Design a form for entering new student details and a report grouped by Class. Attach screenshots or describe the steps.

End of Exam

Ensure your name and candidate number are on every page. Use additional sheets if necessary and attach them to this paper.

Name: _____________________________    Candidate No: ____________________

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅