Scribd
Upload
5 views3 pages

Practical File

The document provides a practical guide to using MS Office, covering MS Word, Excel, and PowerPoint. It includes instructions for table handling, mail merge, salary calculations, and creating pivot tables in Excel, as well as designing a presentation on the benefits of exercise. Additionally, it outlines basic Excel functions and the use of animations and transitions in PowerPoint.

Uploaded by

Rachna
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views3 pages

Practical File

The document provides a practical guide to using MS Office, covering MS Word, Excel, and PowerPoint. It includes instructions for table handling, mail merge, salary calculations, and creating pivot tables in Excel, as well as designing a presentation on the benefits of exercise. Additionally, it outlines basic Excel functions and the use of animations and transitions in PowerPoint.

Uploaded by

Rachna
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MS Office Practical File

1. Introduction to MS Word

Microsoft Word is a word processing software used to create, edit, format, and print
documents.

2. Table Handling in MS Word

Steps:

- Open MS Word → Insert → Table → Select 4x6 table.

- Enter data such as Name, Class, Marks, City.

- Select table → Layout → Sort → Sort by Name.

3. Invitation Letter using Mail Merge

Steps:

- Mailings → Start Mail Merge → Letters

- Select Recipients → Use Existing List

- Insert Merge Fields → Name, Address

- Finish & Merge

4. Report on Artificial Intelligence

Artificial Intelligence (Artificial Intelligence) is a branch of computer science that enables


machines to think and act like humans. Artificial Intelligence is widely used in daily life such
as mobile phones, smart assistants, and healthcare systems. Artificial Intelligence helps in
automation and decision making.

5. Excel – Employee Salary

Formulas:
DA = Basic * 10%

HRA = Basic * 8%

Gross = Basic + DA + HRA

PF = Gross * 5%

Net = Gross - PF

6. Excel Operations

- Data Validation: Allow numbers 100–200

- Sorting: Net Salary (Descending)

- Filter: Net Salary > 30000

- Chart: Column Chart

7. Pivot Table

- Insert → Pivot Table

- Rows: Product

- Values: Sum of Sales

8. PowerPoint – Benefits of Exercise

Slides include:

- Title Slide

- Benefits

- Types of Exercise

- Weekly Plan

- Conclusion

9. Animations & Transitions


- Apply transitions to all slides

- Animate title and bullet points

10. Excel Functions

- Average: =AVERAGE()

- Max: =MAX()

- Min: =MIN()

- Total: =SUM()

- Count: =COUNTIF()

You might also like