Assi3344ttttttttgnment_Presentation.pptx

Ddr

1. MS Word & Excel Functions Assignment Presentation Your Name | Roll No | Class

2. Word Document Functions (Part 1) Saved as Word format Font settings (Times New Roman, sizes 12–14–16) Line spacing, margins, page size (A4) Alignment: Justified, Column: One Protect document function Find & Replace function [Insert Word screenshot here]

3. Word Document Functions (Part 2) Header & Footer functions Shapes & Symbols Hyperlink & Page numbers Footnote (SEBI report 2020) Endnote (RBI report 2020) Table of Contents [Insert Word screenshot here]

4. Word Document Functions (Part 3) SmartArt diagrams (2 examples) Table layout & design New chapter on new page Converted to PDF [Insert Word screenshot here]

5. Spreadsheet Functions (Part 1) Count, Countif, Average, Sum If, Sumif functions Text to column Lookup, Vlookup [Insert Excel screenshot here]

6. Spreadsheet Functions (Part 2) Create Table and apply features Charts (Column, Bar, Pie, Line, Area, Scatter) Pivot Table [Insert Excel screenshot here]

7. Spreadsheet Functions (Part 3) Protect Sheet function Sort function Filter function Freeze Panes [Insert Excel screenshot here]

8. Conclusion Learned to apply Word formatting & functions Learned to apply Excel formulas & features Developed presentation skills Enhanced documentation and data analysis knowledge