Who should use these Microsoft Office assignments?

These assignments are designed for students, job seekers, professionals, office workers, and anyone who wants to improve their MS Office expertise.

Do these assignments include answers?

Yes, every Excel, Word, and PowerPoint assignment includes complete answers, formulas, and step-by-step explanations.

Are these assignments suitable for beginners?

Yes. The tasks start from intermediate level and gradually move to advanced skills. Even beginners can follow and learn.

What skills can students learn from these assignments?

Students will learn advanced Excel formulas, data analysis, pivot tables, Word formatting, Mail Merge, PowerPoint design, animations, and presentation skills.

Does PICT offer practical training for Microsoft Office?

Yes. PICT offers hands-on Microsoft Office training with real business tasks and practical assignments to prepare students for jobs.

Advanced Microsoft Excel, Word & PowerPoint Assignments with Answers

About this Assignments Collection

This page contains 50 advanced, practical assignments for Microsoft Office — 20 for Excel, 15 for Word, and 15 for PowerPoint. Each assignment includes clear instructions and answers so students can practice, verify their work, and build a professional portfolio.

The content is ideal for classroom use, self-study, assessments, or professional upskilling. Everything here emphasizes hands-on learning and real world implementation.

Assignments (Excel, Word & PowerPoint) — Full List with Answers

Click a category to expand the assignments and view answers.

Microsoft Excel — 20 Advanced Assignments

Task:

Use Pivot Tables, Slicers, and Charts.

Answer / Steps:

Insert Pivot Table → drag Salesperson, Product, Month into Rows/Columns/Values as required.
Insert Slicers for Month & Salesperson for interactive filtering.
Add Column Chart linked to Pivot Table and KPI cards using formulas like =COUNTIF() and =SUMIF().
Format slicers and charts, and place KPI cards above the chart for dashboard view.

Answer Formula:

=VLOOKUP(A2,SalaryTable!A2:D100,4,FALSE)

Answer Formula:

=SUMIFS(C2:C500, A2:A500, "Lahore", B2:B500, "January")

Answer Formulas:

=COUNTIF(B2:AF2, "P")  ' → Present
=COUNTIF(B2:AF2, "A")  ' → Absent

Answer Formula:

=IF(COUNTIF($A$2:A2, A2)=1, A2, "")

Answer:

Home → Conditional Formatting → Highlight Cells Rules → Less Than → enter <10 → choose red fill.

Answer Formula:

=IF(B2>100000, B2*0.10, 0)

Answer:

Data → Data Validation → Allow: List → Source: type or select the range containing options.

Answer Formula:

=DATEDIF(A2, TODAY(), "Y")

Answer:

Insert → Chart → choose Line Chart → select expense data range → format axes and labels.

Answer Formula:

=LEFT(A2, FIND(" ", A2)-1)

(Works when names have a single space.)

Answer Formula:

=RIGHT(A2, LEN(A2)-FIND(" ", A2))

(Adjust for middle names if needed.)

Answer Formula:

=CONCAT(A2, " ", B2)

(Or use =A2 & " " & B2.)

Answer Formula:

=(SellingPrice - CostPrice) / SellingPrice

Format cell as Percentage.

Answer Formula:

=SUM(1/COUNTIF(A2:A100,A2:A100))

Enter as an array formula in older Excel versions: Ctrl+Shift+Enter. Newer Excel has UNIQUE() and COUNTA(UNIQUE()).

Answer Examples:

=LARGE(C2:C200,1)
= LARG E(C2:C200,2)
...
= LARGE(C2:C200,5)

Answer Formula:

=IF(AND(B2>=90,C2>=90),"Excellent","Good")

Answer Formula:

=SUM($B$2:B2)

Drag down to keep cumulative total.

Answer:

Review → Protect Sheet → set password and choose allowed actions (select unlocked cells, etc.).

Answer Formula:

=NOW()

(Use =TODAY() if time not needed.)

Microsoft Word — 15 Advanced Assignments

Answer:

Use a 2-column table for layout, merge header cells for name/title, and apply "No Border" style to hide table lines while keeping alignment.

Answer:

Apply Heading 1/2/3 styles to section titles, then go to References → Table of Contents and insert an automatic TOC.

Answer:

Insert → Page Number → Break the document into sections (Insert → Breaks → Next Page), unlink headers/footers, then set page numbering to start at 1 on the desired section.

Answer:

Mailings → Start Mail Merge → Select Recipients (Excel/CSV) → Insert Merge Fields → Preview Results → Finish & Merge.

Answer:

Home → Multilevel List → choose the numbered style that matches I., 1., a. and apply it to headings or list items.

Answer:

Design → Watermark → choose Text Watermark → type "Confidential" and set transparency/size.

Answer:

Review → Restrict Editing → choose restrictions (e.g., tracked changes only) → Start Enforcement → set a password.

Answer:

Insert → Cover Page → choose a template → edit title, author, institute, and date to match academic format.

Answer:

References → Insert Footnote or Insert Endnote → enter citation text and format style.

Answer:

Review → Track Changes → reviewers can add edits which appear as tracked markup; accept/reject changes later.

Answer:

Layout → Columns → Two → adjust gutters and add images or pull quotes for newspaper effect.

Answer:

Insert → SmartArt → choose a Process diagram → add steps and adjust colors and text.

Answer:

References → Cross-reference → choose the item (figure/table/heading) and insert; updates automatically if items renumber.

Answer:

Insert table → Table Design → check "Banded Rows" or choose a table style with alternating shading.

Answer:

File → Open → choose PDF → Word imports and converts; then fix alignment, spacing, fonts and margins as needed.

Microsoft PowerPoint — 15 Advanced Assignments

Answer:

Use gradient background, add a large bold title, place logo in the corner, and use a clean font with ample spacing.

Answer:

Transitions → apply "Morph" or "Fade" → set duration and apply to all or selected slides.

Answer:

Insert → SmartArt → Process → add 5 steps and style to match brand colors.

Answer:

Animations → select bullets → choose "Appear" → set Start to "On Click" or sequence with delays.

Answer:

Insert → Video → choose file → Playback tab → set Start to "Automatically" (autoplay) and trim if needed.

Answer:

Insert → Chart → choose Bar Chart → enter values in the embedded Excel sheet → format axes and legends.

Answer:

Use Slide Master → add logo, footer, consistent placeholders and color theme to create reusable company profile slides.

Answer:

Insert → Audio → Record Audio for each slide or use Slide Show → Record Slide Show to record narration and timings.

Answer:

Insert multiple images → select and choose Picture Layout or convert to SmartArt → add transitions for gallery effect.

Answer:

Combine Shapes, Icons, SmartArt and consistent Color Themes to design a visually appealing infographic slide.

Answer:

View → Slide Master → edit master slide to set fonts, colors, footer and placeholders for consistent formatting across all slides.

Answer:

Insert → Link → choose "Place in This Document" → select target slide to create a clickable navigation menu.

Answer:

Insert Process SmartArt → add timeline milestones → animate each milestone with Entrance animations and adjust delays.

Answer:

File → Export → Create a Video → choose resolution (1080p) → include recorded timings and narrations if any.

Answer:

File → Info → Compress Media → choose quality (Presentation/Internet/Low) to reduce file size while keeping acceptable quality.

PICT

Advanced Microsoft Office Assignments — Excel, Word & PowerPoint

About this Assignments Collection

Quick Benefits

Assignments (Excel, Word & PowerPoint) — Full List with Answers

Microsoft Excel — 20 Advanced Assignments

Microsoft Word — 15 Advanced Assignments

Microsoft PowerPoint — 15 Advanced Assignments

Basic IT Course - Printable Workbook or PDF?

Get in Touch — PICT

About this Assignments Collection

Quick Benefits

Assignments (Excel, Word & PowerPoint) — Full List with Answers

Microsoft Excel — 20 Advanced Assignments

1. Create a Dynamic Sales Dashboard — Use Pivot Tables, Slicers, and Charts

2. Use VLOOKUP to fetch employee salaries

3. Calculate total sales using SUMIFS

4. Create an automatic attendance sheet

5. Remove duplicates using a formula

6. Conditional formatting for low stock items

7. Calculate bonus (10% if sales > 100,000)

8. Create a custom drop-down list

9. Calculate Age from DOB

10. Create a monthly expense chart

11. Extract first name from full name

12. Extract last name from full name

13. Combine first and last name

14. Calculate profit margin

15. Count unique values

16. Show top 5 sales using LARGE

17. Use IF + AND for performance grading

18. Create running total

19. Protect a worksheet with a password

20. Get today's date and time

Microsoft Word — 15 Advanced Assignments

1. Create a professional CV with table formatting

2. Insert automatic table of contents

3. Add page numbers starting from page 3

4. Create Mail Merge letters

5. Create a multi-level list (I. 1. a.)

6. Insert a watermark "Confidential"

7. Protect document from editing

8. Create an academic-style cover page

9. Add footnotes and endnotes

10. Track changes for document editing

11. Create a two-column newspaper-style article

12. Insert SmartArt for workflow diagram

13. Add cross-references in a research paper

14. Insert table with alternating row colors

15. Convert PDF to Word and fix formatting

Microsoft PowerPoint — 15 Advanced Assignments

1. Design a professional title slide

2. Create slide transitions

3. Insert SmartArt for business workflow

4. Create animated bullet points

5. Insert a video and set autoplay

6. Create a bar chart with company performance

7. Design a company profile template

8. Add voice narration to slides

9. Create picture slideshow gallery

10. Create an infographic slide

11. Use Slide Master for uniform formatting

12. Hyperlink slides for navigation menu

13. Create animated timeline

14. Export presentation as video

15. Compress media for smaller file size

Basic IT Course - Printable Workbook or PDF?

Get in Touch — PICT