Credit:2
STAFF NAME: Class: I [Link] - B
Lecture
[Link] [2023 - 2026]
Hours :2
Proposed date of
[Link] Expt. No Execution Period
(DD/MM/YYYY)
1 1 1
2 2 1
3 3 1
4 4 1
5 5 1
6 6 1
7 7 2
8 8 2
9 9 2
10 10 1
11 11 1
12 12 1
13 13 1
14 14 1
15 15 1
16 16 1
17 17 2
18 18 2
19 19 1
20 20 1
21 21 1
22 22 1
23 23 1
24 24 1
25 25 1
30
SUBJECT NAME: [Link] for Commerce (Practical)
SUBJECT CODE: 146S1A
Name of the Experiment (LAB)
Text Manipulations
Usage of Numbering, Bullets, Footer and Headers
Usage of Spell check and Find & Replace
Text Formatting using Text Box and Word Art
Picture insertion and Alignment
Creation of documents using Watermark Hyperlink
and Bookmark
Creation of Table - Rows , Columns, Cell - Merge Cell -
Split Cell
Creation of Table of Content - Update entire -
Header / Footer - Cover Page - Break - Section Break -
Spell Check - ABC / F7 - Word Count
Mail Merge Concepts
Creating Presentation and applying Background
Creation of Slide Master
Insertion of Logo( to display in all slides - Change
Text color - to maintain
consistency in all slides) in the presentation
Insertion of New slides,Animation Effects - Apply in
objects within the Slide
Transition Effect - Apply between slides
Rehearse Timing - Set timing to each slide
Loop until ESC - After reaching LAST slide, display
again from 1st slide and Slideshow
Paste the Chart from Excel - Data linked to Excel
sourc
Preparation of Organization charts - Data linked
internally
Cell Editing
Usage of Formulae
Built-in functions
File Manipulations
Working with AutoCorrect
Checking Spelling - Using Find and Replace - Using
Hyperlinks ( Internal /
External )
Working with huge Dataset Using multilevel Sort -
Using Filters - Fetching Unique Records
Finding Duplicates - Applying Conditional Formatting
Rules
Applying Freeze Panes
Using Pivot Table ( Layout & Format )
Working with Charts Pie / Bar / Column / Line Charts
- Titles / Legends / Data labels Copy / Pasting in
Word / PowerPoint
Page Setup Tools - Working in Page Layout View -
Creating a Header and Footer