GE3361 PROFESSIONAL DEVELOPMENT LAB

LIST OF EXPERIMENTS: TOTAL: 30 PERIODS

MS WORD:
1. Create and format a document
2. Working with tables
3. Working with Bullets and Lists
4. Working with styles, shapes, smart art, charts
5. Inserting objects, charts and importing objects from other office tools
6. Creating and Using document templates
7. Inserting equations, symbols and special characters
8. Working with Table of contents and References, citations
9. Insert and review comments
10. Create bookmarks, hyperlinks, endnotes footnote
11. Viewing document in different modes
12. Working with document protection and security
13. Inspect document for accessibility

MS EXCEL:
1. Create worksheets, insert and format data
2. Work with different types of data: text, currency, date, numeric etc.
3. Split, validate, consolidate, Convert data
4. Sort and filter data
5. Perform calculations and use functions: (Statistical, Logical, Mathematical, date, Time etc.,)
6. Work with Lookup and reference formulae
7. Create and Work with different types of charts
8. Use pivot tables to summarize and analyse data
9. Perform data analysis using own formulae and functions
10. Combine data from multiple worksheets using own formulae and built-in functions to generate
results
11. Export data and sheets to other file formats
12. Working with macros
13. Protecting data and Securing the workbook

4
 MS POWERPOINT:
1. Select slide templates, layout and themes
2. Formatting slide content and using bullets and numbering
3. Insert and format images, smart art, tables, charts
4. Using Slide master, notes and handout master
5. Working with animation and transitions
6. Organize and Group slides
7. Import or create and use media objects: audio, video, animation
8. Perform slideshow recording and Record narration and create presentable videos

Lab Requirements: for a batch of 30 students

Operating Systems: Windows
Tools : Microsoft World, Microsoft Excel, Microsoft Power point

5
MS Word

6
7
Ex no:1
CREATE AND FORMAT A DOCUMENT
Date:

AIM:
To create and format a Word document, you can follow these general steps.

PROCEDURE:
1: Open Microsoft Word, Launch Microsoft Word on your computer.
2: Create a New Document, click on "File" and select "New" to create a new document.
3: Add Content, Type or paste your content into the document.
4: Formatting Text, Highlight the text you want to format. Use the toolbar to change font,
size, color, bold, italicize, or underline.
5: Paragraph Formatting, adjust alignment (left, center, right, justified). Set line spacing
and paragraph spacing.
6: Inserting Elements, go to the "Insert" tab to add images, tables, charts, or other elements.
7: Headers and Footers, Use the "Header" and "Footer" options to add information at
the top or bottom of each page.
8: Page Layout, set page size, margins, and orientation under the "Layout" or "Page
Layout" tab.
9: Page Numbers, add page numbers from the "Insert" tab.
10: Save Your Document, click on "File" and select "Save" or "Save As" to save your
document.

8
Output:

9
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, creating and formatting with MS word is completed successfully.

10
11
 Ex No:2
WORKING WITH TABLES
Date:

AIM:
To create and work with tables in Microsoft Word, follow these steps.

PROCEDURE:
1: Open Microsoft Word, Launch Microsoft Word on your computer.
2: Insert a Table, click on the "Insert" tab in the top menu.
3: Choose "Table", select the number of rows and columns for your table.
4: Enter Data, Once the table is inserted
5: Format the Table, you can format the table by right-clicking to access options like "Insert,"
"Delete," "Merge Cells," and more. Also, use the "Table Design" tab to change the style, colors,
and other formatting options.
6: Borders and Shading, you can add borders and shading to cells or the entire table using the options
in the "Table Design" tab.
7: Save Your Document, don’t forget to save your document to keep the changes.

12
Output:

13
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, creating and working with tables in Microsoft Word was completed successfully.

14
15
Ex no: 3
WORKING WITH BULLETS AND LIST
Date:

AIM:
To create and work with bullets and list, follow these steps.

PROCEDURE:
1: Open a New Document. Launch Microsoft Word. Open a new or existing document.
2: Insert a Bullet List. Place the cursor where you want the list to begin. Click on the "Bullets"
button in the toolbar. This can usually be found in the "Home" tab.
3: Type Your List. Start typing the items of your list. Press "Enter" after each item.
4: Change Bullet Style. To change the bullet style, select the list. Click the small arrow next to the
"Bullets" button and choose a different style.
5: Numbered Lists. For numbered lists, use the "Numbering" button in a similar way.
6: Customizing Bullets or Numbers. Right-click on a bullet or number and choose "Bullets and
Numbering" for customization options.

16
Output:

17
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, creating and working with bullets and list was completed successfully.

18
19
Ex No: 4
WORKING WITH STYLES, SHAPES, SMART ART, CHATS
Date:

AIM:
To create and work with styles, shapes, smart art and chats follow these steps.

PROCEDURE:
1: Open a New Document. Launch Microsoft Word. Open a new or existing document.
2: Apply a Style. Modify a Style Right-click on a style in the Styles pane. Select "Modify" to
change font, size, color, etc.
3: Shapes. Insert a Shape. Format a Shape, Right-click on the shape, select "Format Shape.
“Adjust the fill color, outline, size, etc.
4: SmartArt: SmartArt graphics are used for creating visual representations of information. Insert
SmartArt.
5: Edit SmartArt. Click on the SmartArt graphic to reveal the SmartArt Tools. Use the Text pane
to enter or edit content.
6: Charts: Insert a Chart. Modify a Chart. Click on the chart to reveal the Chart Tools. Use the
Design and Format tabs to customize.
7: Change Chart Type. Right-click on the chart, select "Change Chart Type. "Choose a different
chart type if needed. Data Labels and Titles.

20
Output:

21
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, working with styles, shapes, smart arts and charts was done successfully.

22
23
Ex No:5 INSERTING OBJECTS, CHARTS AND IMPORTING OBJECTS
Date: FROM OTHER OFFICE TOOLS

AIM:
To insert objects, charts and to import objects from other office tools, follow these steps.

PROCEDURE:
1: Go to the "Insert" tab. Click on "Pictures" to insert an image from your computer. Select the
image and click "Insert."
2: Go to the "Insert" tab. Click on "Chart" to select a chart type. A linked Excel sheet will open
for you to input data.
3: Select the object, right-click, and choose "Copy" or use Ctrl+C.
4: Open the destination document (e.g., PowerPoint presentation).
5: Right-click where you want to insert and choose "Paste" or use Ctrl+V.

24
Output:

25
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, inserting objects, charts and importing objects from other office tools was completed
successfully.
26
27
Ex No:6
CREATING AND USING DOCUMENT TEMPLATES
Date:

AIM:
To Create and use document templates.

PROCEDURE:
1: Open a new blank document.
2: Set up the layout, fonts, styles, and any standard elements you want in your template. Include
placeholders for information that will change (e.g., [Company Name], [Date]).
3: Go to "File" and select "Save As."
Choose the location where you want to save the template. In the "Save as type" dropdown, select
"Word Template (.dotx)" or "Word Macro-Enabled Template (.dotm)."Enter a name for your
template and click "Save."
4: Importing. Replace the placeholder text with the actual content. Modify any other elements as
needed.
5: Save your document using "File" > "Save As" to avoid overwriting the original template.

28
Output:

29
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

.
Thus, Creating and using document templates was completed successfully

30
31
Ex No:7 INSERTING EQUATIONS, SYMBOLS AND SPECIAL
Date: CHARACTERS

AIM:
To insert equations, symbols and special characters in word document.

PROCEDURE:
1: Equations: Use a dedicated tool like LaTeX for complex equations.
2: Symbols: In text editors, you can often insert symbols from the "Insert" menu or by using
keyboard shortcuts (e.g., Alt + code on Windows).
3: In word processors, look for the "Symbols" or "Insert" menu.
4: Special Characters: find the "Insert" or "Symbols" menu in your application.
5: Explore character maps or special character palettes.

32
Output:

33
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, inserting equations, symbols and special characters was done successfully.

34
35
Ex No:8 WORKING WITH TABLE OF CONTENTS AND REFERENCES
Date: AND CITATIONS

AIM:
To work with table of contents and references, citations.

PROCEDURE:
1: Click where you want the TOC. Go to the "References" tab and Click "Table of Contents" and
choose a style.
2: After making changes, right-click on the TOC. Choose "Update Field" and select "Update
Entire Table."
3: Go to the "References" tab and Click "Insert Citation" or "Add New Source."
4: Choosing a Citation Style: Click "Style" in the "References" tab.
5: Select the desired citation style (APA, MLA, etc.).

36
Output:

37
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

Thus, working with Table of contents and References, citations was completed successfully.

38
39
Ex No:9
INSERTING AND REVIEW COMMENTS
Date:

AIM:
To insert and review comments in MS Word.

PROCEDURE:
1: Open the document.
2: Select the text or position where you want to insert a comment.
3: Go to the "Review" tab in the menu. Click on "New Comment" or a similar option depending
on the software you're using.
To review comments:
4: Navigate to the "Review" tab. Look for options like "Next Comment" or "Previous Comment"
to move between comments.
5: To resolve a comment, you might find options like "Resolve" or "Delete Comment."

40
Output:

41
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

Thus, inserting and review comments was done successfully.

42
43
Ex No: 10
CREATE BOOKMARKS, HYPERLINKS, ENDNOTES FOOTNOTE
Date:

AIM:
To create bookmarks, hyperlinks, endnotes footnote in MS Word.

PROCEDURE:
1: Bookmarks: Open your document using the appropriate software.
2: Go to the specific section or page where you want to create a bookmark.
3: Look for an option like "Insert" or "Bookmark" in the menu. Enter a name for the bookmark
and confirm.
4: Hyperlinks: Highlight the text or select the element (e.g., image) you want to hyperlink.
5: Endnotes: Move to the end of your document where you want to add endnotes.
6: Footnotes: Place Cursor: Position your cursor where you want the footnote reference number
to appear.

44
Output:

45
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, creating bookmarks, hyperlinks, endnotes footnote was done successfully.

46
47
Ex No: 11
VIEWING DOCUMENTS IN DIFFERENT MODES
Date:

AIM:
To view documents in different modes, follow these steps.

PROCEDURE:
1: Open the Document: Launch the document viewing program on your device. Open
the specific document you want to view.
2: Access View Modes: Look for an option or menu labeled "View" or a similar term. Depending
on the program, you may find options like "View Modes" or "Display Modes."
3: Select Desired Mode: Choose the mode that suits your needs. Normal/Standard,
Reading Mode, Full Screen and Outline Mode
4: Adjust Settings: Some programs allow you to customize the view further. Look for
settings related to font size, color schemes, or page layout.
5: Navigation: Learn how to navigate through the document in each mode. This might involve
scrolling, page flipping, or using navigation tools.
6: Exit View Mode: To return to the standard view, locate an option like "Exit Full Screen" or
"Return to Standard Mode" in the menu.

48
Output:

49
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, the Viewing documents in different modes was done successfully.

50
51
Ex No: 12
WORKING WITH DOCUMENT PROTECTION AND SECURITY
Date:

AIM:
To work with document protection and security in MS Word.

PROCEDURE:
1: Password Protection: Secure your document by adding a password to limit access.
2: Encryption: Use encryption tools to safeguard the content of your document.
3: Access Control: Set permissions to restrict editing, printing, or copying for specific users.
4: Watermarking: Apply watermarks to identify confidential or sensitive documents.
5: Regular Backups: Ensure regular backups to prevent data loss and facilitate recovery.
6: Update Software: Keep your software and security features up-to-date to defend against
potential vulnerabilities.

52
Output:

53
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

Thus, working with document protection and security was done successfully.

54
55
Ex No: 13
INSPECT DOCUMENT FOR ACCESSIBILITY
Date:

AIM:
inspect document for accessibility in MS Word.

PROCEDURE:
1: Highlight the importance of ensuring that the document or content is accessible to all users,
including those with disabilities.
2: Clearly state the objectives and goals of the inspection and specify the type of document or
content being assessed (e.g., website, application, document).
3: Provide references to specific sections of the standards relevant to your inspection.
4: Specify which elements of the document or content will be assessed (e.g., text, images,
forms, navigation).
5: Provide specific recommendations for addressing accessibility issues, considering the
guidelines referenced in step 3.

56
Output:

57
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, inspecting document for accessibility was executed successfully.

58
59
MS EXCEL

60
61
Ex No: 1
CREATE WORKSHEETS, INSERT AND FORMAT
Date:

AIM:
To create a worksheet in MS Excel for practicing data entry and formatting skills.

PROCEDURE:
1: Open MS Excel and create a new workbook.
2: Label the worksheet with a relevant title.
3: In cell A1, enter "Name," in B1, enter "Age," and in C1, enter "Occupation."
4: Enter sample data in rows 2 and below
5: Format the data: Apply bold to headers, align text, and use cell borders
6: Add a Total row: In the last row, use the SUM function for numerical columns.
7: Format the Total row: Apply a different background color
8: Save Your Document, click on "File" and select "Save" or "Save As" to save your document.

62
Output:

63
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

Thus, create worksheets, insert and format data is completed successfully.

64
65
Ex No: 2 VARIOUS TYPES OF DATA INCLUDING TEXT, CURRENCY,
Date: DATE, AND NUMERIC DATA IN MS EXCEL

AIM:
To practice handling various types of data including text, currency, date, and numeric
data in MS Excel.

PROCEDURE:
1: Open MS Excel and create a new workbook.
2: Text Data: In a cell, type any text data, like names or labels.
3: Currency Data: Enter monetary values in cells (e.g., 100.50) and use the "Currency"
format by selecting the cells, right-click, choose "Format Cells," and set the format to
Currency.
4: Date Data: Input dates in cells (e.g., 01/15/2023) and format them as dates by selecting
the cells, right-click, choose "Format Cells," and set the format to Date.
5: Numeric Data: Enter regular numeric values (e.g., 123) without any specific formatting.
6: Applying Formulas: Use mathematical operations (e. g., =A1+B1) to perform
calculations with numeric data.
7: Sorting Data: Select a range of cells, go to the "Data" tab, and use the "Sort" function to
arrange data alphabetically or numerically.
8: Filtering Data: Enable filters for the data range by selecting it and clicking the "Filter"
button. Filter based on criteria such as text, numbers, or dates.
9: Using Functions: Explore Excel functions like CONCATENATE for combining text,
SUM for adding numeric values, and TODAY for displaying the current date.
10: Conditional Formatting: Highlight cells based on conditions, such as greater than or
equal to a certain value, by selecting cells, right-clicking, and choosing "Conditional
Formatting."
11: Creating Charts: Select numeric data, go to the "Insert" tab, and choose a chart type to
visually represent numeric information.

66
Output:

67
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, to practice handling various types of data including text, currency, date and numeric data in MS
Excel is completed Successful.

68
69
Ex No: 3 SPLIT, VALIDATE, CONSOLIDATE, CONVERT DATA
Date:

AIM:
To Split, Validate, Consolidate, Convert Data

PROCEDURE

(A) Splitting Data:

1. Assume the full names are in column A (from A2 to A100).

2. In cell B2, enter the formula =LEFT (A2, FIND (" ", A2) - 1) to extract the first name.

3. In cell C2, enter the formula =MID (A2, FIND (" ", A2) + 1, LEN(A2)) to extract the last
name.

4. Drag these formulas down to apply them to the entire column.

(B) Validating Data:

1. Select the column of data (e.g., column D).

2. Go to the "Data" tab, click on "Data Validation."

3. Set the criteria, such as allowing only whole numbers, between 18 and 100.

4. Add an input message and error alert if desired.

(C) Consolidate Data:

1: Open all files (workbooks) that contain the data you want to consolidate.
2: Ensure the data is organized in the same way (see example below).
3: On the Data ribbons, select Data Tools and then Consolidate.
4: Select the method of consolidation (in our example, it’s Sum).
5: Select the data, including the labels, and click Add
6: Repeat step 5 for each worksheet or workbook that contains the data you need included
7: Check boxes “top row”, “left column”, and “create links to data source” (note you don’t have
to tick these boxes if you don’t want labels or don’t want live links) and click the OK button.

70
OUTPUT: (A) (B)

(C)

(D)

71
 Converting Data:
1. Assume the dates are in column E (E2:E100).

2. In cell F2, enter the formula =DATEVALUE(E2).

3. Drag the formula down to apply it to the entire column.

Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, data is meticulously split, validated, consolidated, and converted in Excel, yielding an
organized, refined dataset, ensuring integrity, and facilitating improved analysis

72
73
Ex No: 4
SORT AND FILTER DATA
Date:

AIM:
Sort and filter data to organize and extract specific information from a dataset.

PROCEDURE:

1: Sorting: Arrange data in ascending or descending order based on selection criteria.

2: Filtering: Display only the data that meets specific conditions

74
OUTPUT

75
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

.
Improved data organization and focused view for effective analysis and decision-making

76
77
Ex No:5 PERFORM CALCULATIONS AND USE FUNCTIONS
Date: (STATISTICAL, LOGICAL, MATHEMATICAL, DATE, TIME etc.,)

AIM:
To Perform Calculations and use Functions in a Dataset created in Excel.

PROCEDURE:
1. Create a Dataset in Excel File.
2. Save the Dataset (by Manual Button or Press Ctrl+S).
3.Press Formulas option in Menu Bar.
4. Select Export Option in File, then Change File Type.
5. Choose the Type of the Calculations You Wish to do (Statistical, Logical, Mathematical,
Date, Time etc.,).
6. Select the respective rows and columns for calculations and perform the calculations.
7.After setting Logics and Preferred rows and column in Function Arguments tab.

78
OUTPUT

79
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, the Calculations & Mathematical Functions in Excel File Are Executed, and Verified
Successfully

80
81
 Ex No:6
WORK WITH LOOKUP AND FORMULAE
Date:

AIM:

The AIM of working with lookup and reference formulas in Microsoft Excel to efficiently find and
retrieve specific information froma table or range.

PROCEDURE:

1. Identify the table or range where the data is located.

2. Choose an appropriate Lookup function such as VLOOKUP orHLOOKUP.

3. Specify the lookup value and the table or range where the dataresides.

4. Use reference formula like INDEX and MATCH for more flexible lookup
scenarios.

5. Apply the formula to retrieve the desired information based onthe specified conditions.

Ensure accuracy by checking cell references and adjustingformulas a

82
OUTPUT:

83
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:

Efficiently retrieve and use data from a large dataset, simplifying tasks such as searching for
information or performingdynamic calculations based on changing inputs.

84
85
Ex No:7
CREATE AND WORK WITH DIFFERENT TYPES OF CHARTS
Date:

AIM:
To create and work with different types of charts in Microsoft Excel, specifically focusing on a bar chart
and a pie chart.

PROCEDURE:

BAR CHART
1. Data Preparation:
Organize data in a table with categories and corresponding values.
2. Select Data:
Highlight the data range, including category labels and values.
3. Insert Bar Chart:
Go to the "Insert" tab, choose "Bar Chart," and select the desired subtype (e.g., clustered bar).
4. Format Chart:
Customize the chart by right-clicking on elements (bars, axis) and selecting "Format." Adjust
colors, labels, and titles.

PIE CHART
5. Data Preparation:
Create a table with categories and corresponding percentage values or counts.
6. Highlight the data range, including category labels and values.
7. Go to the "Insert" tab, choose "Pie Chart," and select the desired subtype.
8. Format:
Customize the chart by right-clicking on elements (slices, labels) and selecting "Format" Adjust
colors, explode slices, and add data labels.

86
OUTPUT:

BAR CHART:

PIE CHART:

87
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
A visually engaging bar chart and pie chart representing the proportional distribution of data categories.
88
89
Ex No:8
SUMMARIZE AND ANALYZE DATA USING PIVOT TABLES
Date:

AIM:
To summarize and analyze data using pivot table in Excel file

PROCEDURE:
1. Click the table and Click the INSERT tab on the Ribbon.
2. Click PivotTable in the Tables group. The PivotTable dialog box appears.
3. In the Table / Range Box, type the table name.
4. Click New Worksheet to tell Excel where to keep the PivotTable. Click OK. Now a empty pivot table is
created. Use the recommended pivot table.
5. In the recommended PivotTables dialog box, the possible customized PivotTables that suit your data are
displayed.
6. Click OK. The selected PivotTable appears on a new worksheet. You can observe the PivotTable fields

that was selected in the PivotTable fields list.

a) summarizing data steps

7. Click each of the PivotTable options to see the preview on the right side.
8. Click the PivotTable Sum of Order Amount by Salesperson and month.
9. In the PivotTable Fields List
10. Select the Field Account. Unselect the Field Order Amount.
11. Drag the field Account to Summarizing Values area. By default, Sum of Account will be displayed.
12. Click the arrow on the right side of the box.
13. In the drop-down that appears, click Value Field Settings.
14. The Value Field Settings box appears. Several types of calculations appear as a list under Summarize value
field by
15. Select Count in the list. The Custom Name automatically changes to Count of Account. Click OK.
16. The PivotTable summarizes the Account values by Count

90
OUTPUT (A):

91
b) analyzing data in pivot table

1. Select the Pivot Table. The following Pivot Table Tools appear on the Ribbon− analyze and design
2. Some of the ANALYZE Ribbon commands are−

• Set Pivot Table Options

• Value Field Settings for the selected Field
• Expand Field
• Collapse Field
• Insert Slicer
• Insert Timeline
• Refresh Data
• Change Data Source
• Move Pivot Table
• Solve Order (If there are more calculations)
• Pivot Chart

3. let see about expand field

4. By selecting the Expand symbol
■ Select the cell containing East in the Pivot Table.
■ Click on the Collapse symbol to the left of East.
5. All the items under East will be collapsed. The Collapse symbol to the left of East changes to the Expand
symbol
6. You can observe that only the items below East are
rest of the Pivot Table items are as they are
7. Click the Expand symbol to the left of East. All the items below East will be displayed

92
OUTPUT (B):

93
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, the summarizing and analyzing data in pivot tables in Excel Files Are Discussed and Verified by

Executing Successfully.

94
95
Ex No:9 PERFORM DATA ANALYSIS USING OWN FORMULAE AND
Date: FUNCTIONS

AIM:
To Perform data analysis using own formulae and functions.

PROCEDURE:
1: Mean: the formula to tell Excel to calculate a mean is"=average (select cells here)" Type this formula into
the appropriate cell and then hit enter.
2: Standard Deviation: the formula to tell Excel to calculate a standard deviation is "stdev (select cells here)".
Type this formula into the appropriate cell and then hit enter
3: Sample size: the formula to tell Excel to calculate your sample size is "=count (select cells here)". Type
this formula into the appropriate cell and then hit enter
4: Standard Error. The standard error is the standard deviation divided by the square root of the sample size.
Therefore, the formula to tell Excel to calculate a standard error is "= [select the cell for standard

deviation]/sqrt ([cell for sample size])". Type this formula into the appropriate cell and then hit enter.

96
SAMPLE OUTPUT:

97
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, perform data analysis using own formulae and functions is completed successfully

98
99
Ex No:10 COMBINE DATA FROM MULTIPLE WORKSHEET USING OWN
Date: FORMULA AND BUILT-IN FUNCTION TO GENERATE RESULT

AIM:
To combine data from multiple worksheets using own formula and built in function to generate result.

PROCEDURE:
1. (named "Sales") contains product sales data for different regions.
2. (named "Inventory") contains product inventory levels.
3.Combine sales and inventory data into a single summary table in a new worksheet.
4. Create a summary worksheet:
- Right-click any worksheet tab and select "Insert."
- Name the new sheet "Summary."
5. Reference data from other sheets:
- In cell A1 of the Summary sheet, type "Product."
- In cell B1, type "Total Sales."
- In cell C1, type "Inventory."
- In cell A2, enter the formula: `=Sales! A2` (assuming product names are in column A of Sales sheet).
- In cell B2, enter the formula: `=SUMIF (Sales! A: A, A2, Sales! B: B) ` (sums sales for the product
in A2).
- In cell C2, enter the formula: `=VLOOKUP (A2, Inventory! A: B, 2, FALSE)` (retrieves inventory
from Inventory sheet).
6. copy and fill formulas:
- Select cells A2:C2.
- Drag the fill handle (small square at the bottom right) down to copy formulas for other products.

100
OUTPUT:

101
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, combine data from multiple worksheets using a own formulae and build in function is verified and executed
successfully.

102
103
Ex No:11
EXPORT DATA AND SHEETS TO OTHER FILE FORMATS
Date:

AIM:
To Convert an Excel File to other File Formats by Exporting it.

PROCEDURE:
1. Create a Dataset in Excel File.
2. Save the Dataset (by Manual Button or Press Ctrl+S).
3. Press File option in Menu Bar.
4. Select Export Option in File, then Change File Type.
5. Choose the Type of the File You Wish to Convert (PDF, CSV, Etc.…).
6. Press Publish to Convert File Format.
7. Open the Converted File Format to View it.

104
OUTPUT:

105
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, the Excel File is Converted to Another File Format

106
107
Ex No:12 WORKING WITH MACROS
Date:

AIM:
To Create a Macros to Perform Calculations and Some Operations on a Dataset in Excel File.

PROCEDURE:

1. Create a Dataset in Excel File.

2. Save the Dataset (by Manual Button or Press Ctrl+S).

3. Enable the Developer Option from the Customize Options in File Menu.

4. Click on the Record Macros Button, near Macros Button in Developer Menu & give a Name to it.

5. Choose the type of Operations or Calculations that needed to performed under the Macro Key.

6. Then Click Stop Recording Button (Same Record Macros Button).

7. Add the Button to the Workbook from the Insert option in the Developer Menu.

8. After adding, Select the appropriate Macro for the inserted Button.

9. Then, click on the Button to format the Data in the Workbook.

10. In a Single Workbook we can use many Macros with different Operations & Calculations for the same
Dataset.

108
OUTPUT:

109
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
Thus, the Working of Macros in Excel Files Are Discussed and Verified by Executing Successfully

110
111
Ex No:13 PROTECTING DATA AND SECURINGTHE WORKBOOK
Date:

AIM:
To protecting data and securing the workbook in MS Excel

PROCEDURE:
1: Open the Excel workbook containing the sensitive data.
2: Navigate to the "Review" tab on the Excel ribbon.
3: Click on "Protect Workbook" and choose "Encrypt with Password."
4: Set a strong password to restrict unauthorized access to the workbook.
5: Utilize Excel's cell and sheet protection features to control access to specific data and prevent accidental
modifications.
6: Implement file-level security measures, such as restricting file access permissions on the operating system level.
7: Consider using third-party encryption tools for an additional layer of security, especially if the workbook contains
highly sensitive information.
8: Regularly update and change passwords to enhance security.
9: Educate users on security best practices and the importance of safeguarding sensitive information.

112
OUTPUT:

113
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

Result:
To protecting data and security the workbook is completed successfully

114
115
MS POWERPOINT

116
117
Ex No: 1
SELECT SLIDE TEMPLATES, LAYOUT AND THEMES
Date:

AIM:
To select a slide templets, layouts and themes in power point.

PROCEDURE:
1. Open PowerPoint and start a new presentation.
2. Go to the "Design" tab at the top of the window.

3. Click on "Slide Design" or "Themes" (the exact wording might vary based on your version of PowerPoint).

118
OUTPUT:

119
 Mark Allocation
Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the slide templets, layouts and themes completed successfully in MS PowerPoint.

120
121
Ex No: 2 FORMATTING SLIDE CONTENT AND USING BULLETS AND
Date: NUMBERING

AIM:
To practice and handling slide content and using bullets and numbering in power point.

PROCEDURE:
1. Highlight the text where you want bullets or numbering, then click the "Bullets" or "Numbering" button
in the "Home" tab.
2. Create a sub-level list, use the "Increase Indent" button in the "Paragraph" section of the "Home" tab.
3. Customize bullet or numbering styles, click the arrow beside "Bullets" or "Numbering" and select
"Bullets and Numbering" to modify the appearance further.

122
OUTPUT:

123
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the practice and handling slide content and using bullets and numbering completed successfully in
MS PowerPoint.

124
125
Ex No: 3
INSERT AND FORMAT IMAGES, SMART ART, TABLES AND CHARTS
Date:

AIM:
To practice and handling insert and format images, smart art, tables, charts in power point.

PROCEDURE:
1. Click on the "Insert" tab, select "Pictures" to add an image from your computer.
2. Navigate to the "Insert" tab, choose "SmartArt" to select a visual graphic, such as a process flow or
hierarchy.
3. Click on "Table" in the "Insert” tab to create a table.
4. Click on “Chart” in the “Insert” tab to create a chart.

126
OUTPUT:

127
 Mark Allocation
Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the practice and handling insert and format images, smart art, tables, and charts completed
successfully in power point.

128
129
Ex No: 4
USING SLIDE MASTER, NOTES AND HANDOUT MASTER
Date:

AIM:
To practice and handling using slide master, notes and handout master in power point.

PROCEDURE:
1. Click "View" tab, select "Notes Master."
2. Customize the layout and formatting for presenter notes, including headers, footers, and fonts.
3. Click "View," then choose "Handout Master."
4. Adjust the layout, orientation, headers, footers, and number of slides per page for handouts.

130
OUTPUT:

131
 Mark Allocation
Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the practice handling using slide master, notes and handout master completed successfully in
PowerPoint.

132
133
Ex No: 5
WORKING WITH ANIMATION AND TRANSITONS
Date:

AIM:
To practice and handling working with animation and transitions in PowerPoint.

PROCEDURE:
1. Click animate and transitions you want to edit videos.
2. Located in the ribbon at the top.
3. Click on the "Add Animation and transitions" dropdown to select an animation effect (entrance, emphasis,
exit, or motion path).
4. Adjust the animation and transitions options in the Animations Pane (timing, duration, delay, etc.).
5. Click on "Preview" to see how the animation and transitions looks.
6. Repeat steps 1-4 to add multiple animations to the same object.

134
OUTPUT:

135
 Mark Allocation
Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the handling and working with animation and transitions completed successfully in PowerPoint.

136
137
Ex No:6
ORGANIZE AND GROUP SLIDES
Date:

AIM:
To practice and handling organize and group slides in MS PowerPoint.

PROCEDURE:
1. Open the PowerPoint presentation.
2. Click on the "View" tab and select "Slide Sorter" view.
3. Click and drag slides to rearrange their order.
4. Right-click on a slide, select "Add Section" to group related slides. Name the section for better
organization.

5. Drag and drop slides into the respective sections for better grouping.

138
OUTPUT:

139
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the handling organizes and group slides completed successfully in MS PowerPoint.

140
141
Ex No: 7 IMPORT OR CREATE AND USE MEDIA OBJECTS: AUDIO, VIDEOS,
Date: ANIMATION

AIM:
To import and handling use various media objects, including audio, video, and animation, in Microsoft
PowerPoint presentations.

PROCEDURE:
1. Importing Media Objects**
- Open Microsoft PowerPoint and create a new presentation.
- Navigate to the "Insert" tab in the ribbon.
- Select "Audio," "Video," or "Animation" from the options.
- Choose the desired media file from your computer and click "Insert."
2. Placing Media on Slides**
- Drag and drop the imported media object onto the desired slide.
- Adjust the size and position as needed to enhance visual appeal.
3. Configuring Audio and Video Settings**
- For audio, right-click on the inserted audio file, select "Playback," and set options like "Start"
And "Volume."
- For video, use the playback options to control settings such as "Start," "Pause," and
"Volume."
4. Adding Animation**
- Select the object (text, image, etc.) to animate.
- Navigate to the "Animations" tab in the ribbon.
- Choose an animation effect from the gallery.

142
OUTPUT:

INSERT IMAGE:

INSERT AUDIO:

INSERT VIDEO:

143
 Mark Allocation
Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, demonstrating the effective use of media objects in your PowerPoint presentation is successfully
executed and verified.

144
145
Ex No: 8 PERFORM SLIDESHOW RECORDING AND RECORD NARRATION AND
Date: CREATE PRESENTABLE VIDEOS

AIM:
To perform and handling slideshow recording and record narration and create presentable videos in MS
PowerPoint.

PROCEDURE:
1. Create or open your PowerPoint presentation.
2. Go to the "Slide Show" tab, select "Record Slide Show."
3. Choose "Start Recording from Beginning" or "Start Recording from Current Slide" as per your preference.
4. Speak clearly as you advance through slides; narrate your content.
5. Use slide navigation to move between slides.
6. Click on the square "Stop" button to end the recording.
7. Review your narration, and re-record if needed. Edit timing, narration, or slide transitions as required.
8. Save your PowerPoint presentation

146
OUTPUT:

147
 Mark Allocation

Details Mark Allotted Mark Awarded

PROCEDURE 30
Execution &Output 40
Viva 10
Record 20
Total 100

RESULT:
Thus, the handling and perform slideshow recording and record narration and create presentable videos
completed successfully in MS PowerPoint.

148