PRC 110 Model Lab Test — Set A

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

Complete paper with clickable formatting lives on the course hub → Lab Test Model tab. Practice offline; use invigilator sample images (not Stock Images).

General rules

  • All questions compulsory; save often; name files with your roll number.
  • No internet. Unit 1 (install/network) is not retested here.
  • Suggested pace: Word ~30 min, Excel ~40 min, PowerPoint ~20 min.

Section A — MS Word (35)

  1. Page setup (3) — A4; margins Top/Bottom 1”, Left 1.25”, Right 1”; 1.5 line spacing; 6 pt After. Save A_Word_[RollNo].docx.
  2. Heading + paragraph (7) — Passage on technology in modern business; Heading 1 title centred; body Normal justified TNR 12; bold+underline one phrase; yellow highlight another.
  3. Table (8) — 5×5 student marks table; dark blue header/white bold; 0.5 pt borders; Total row with merge + sum 294; centre numbers.
  4. Header/footer (5) — Course left / name right; footer “Model Lab Test — Set A” + Page X of Y; Different First Page.
  5. TOC (5) — Extra Heading 1 “Conclusion”; blank first page with Automatic TOC; update fields.
  6. Mail merge (7) — Three recipients (Rajan/Sunita/Mohan); merge City field; save A_Merge_[RollNo].docx.

Section B — MS Excel (40)

Workbook A_Excel_[RollNo].xlsx, sheet Sales.

  1. Data + format (5) — Product sales table; freeze header; number formats; orange header.
  2. Formulas + refs (8) — Revenue relative; SUM/AVERAGE/MAX/MIN; Bonus with absolute $H$1.
  3. Logical + lookup (10) — Nested IF Status; VLOOKUP; COUNTIF/SUMIF for High.
  4. Sort/filter/CF (7) — Sort by Revenue desc; AutoFilter Discount > 0; colour scale + Status fills.
  5. Chart + pivot (10) — Clustered column on own sheet; Pivot Sum + Average of Revenue; pie from pivot.

Section C — MS PowerPoint (25)

File A_PPT_[RollNo].pptx — topic Benefits of MS Office for Business Students.

  1. Five slides (5) — Title, Agenda, Word, Excel, Thank You.
  2. Design (5) — Theme; 16:9; title 40 pt / subtitle 20 pt italic.
  3. Objects (5) — SmartArt on Word slide; shape callout on Excel; offline image on title (office_view.svg / sample pack).
  4. Motion (5) — Fade all; Agenda Wipe After Previous; SmartArt Fly In On Click.
  5. Master + show (5) — Footer + numbers except title; Set Up Show speaker + Presenter View; notes on Agenda.

📚 Related: Unit 2 · Unit 3 · Unit 4