PRC 110 Model Lab Test — Set B

Full Marks: 100 · Time: 90 minutes · Apps: Word (35) · Excel (40) · PowerPoint (25)

Complete paper: course hub → Lab Test Model. Offline images only.

General rules

Same as Set A. Suggested pace: Word ~30 min, Excel ~40 min, PowerPoint ~20 min.

Section A — MS Word (35)

  1. Page setup (3) — A4 Portrait; Narrow margins; 1.5 spacing; 12 pt Before / 6 pt After. Save B_Word_[RollNo].docx.
  2. Heading + paragraph (7) — Digital literacy passage; Heading 1 left; Georgia 12 body; dark-red italic phrase; Drop Cap 3 lines.
  3. Table (8) — Employee salary table; Table Grid style; sort by Basic desc; Total with =SUM(ABOVE); alignments as specified.
  4. Footnotes + citations (5) — Footnote on “practicum”; two APA sources; Insert Bibliography.
  5. Track Changes (5) — Insert/delete/replace; one comment; accept insertion; reject deletion.
  6. Custom style + TOC (7) — MyBodyStyle; Heading 1/2 structure; Automatic TOC on blank first page.

Section B — MS Excel (40)

Workbook B_Excel_[RollNo].xlsx, sheet Employees.

  1. Data + validation (5) — Payroll table; department dropdown; freeze header.
  2. Mixed/absolute refs (8) — Gross/Tax/Net; tax rate $I$1; SUM/AVERAGE/MAX/MIN rows.
  3. Stats + lookup (10) — COUNTIF/SUMIF/AVERAGEIF by dept; INDEX-MATCH Net; VLOOKUP Tax.
  4. CF + filter (7) — Net rules; sort Dept then Net; filter IT+Finance; data bars on Gross.
  5. Pivot + linking (10) — Summary sheet cross-links; Pivot by Department; stacked bar; Slicer for Department.

Section C — MS PowerPoint (25)

File B_PPT_[RollNo].pptx — How MS Office Improves Business Productivity.

  1. Six slides (5) — Title, Contents, Word (+ offline image), Excel SmartArt, PPT comparison table, Takeaways.
  2. Slide Master (5) — Background fill; title font; footer Pokhara University; custom My Layout.
  3. SmartArt/chart/link (5) — Chevron process; bar chart; hyperlink Back to Contents → slide 2.
  4. Motion + notes (5) — Push all; Wipe bullets; Pulse SmartArt; notes on slides 2, 4, 6.
  5. Show + export (5) — Rehearse timings; try kiosk then revert to speaker; Presenter View; export B_PPT_[RollNo].pdf; numbers except title.

📚 Related: Unit 2 Advanced · Unit 3 Functions · Unit 4 Advanced