IT Lab File

Download as pdf or txt
Download as pdf or txt
You are on page 1of 25

TRINITY INSTITUTE OF PROFESSIONAL

STUDIES
SEC-9 DWARKA, NEW DELHI- 110075

(AFFILIATED TO)
GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY
SECTOR-16C, DWARKA, NEW DELHI

COMPUTER APPLICATIONS
PRACTICAL FILE
2021-2024

SUBMITTED BY: SUBMITTED TO: Mr.


Himanshu sharma Ms. Neha Aggarwal
INDEX
Practical list Remarks
Q1 INTRODUCTION TO MSWORD:
• HISTORY OF MS WORD
• FEATURES OF MSWORD
• VERSIONS OF MS WORD
• HOW TO OPEN AND SAVE MS WORD DOCUMENT

Q2 CREATE A TIME TABLE IN MS WORD DESCRIBING THE SCHEDULE OF


LECTURES/CLASSES.

Q3 CREATE YOUR RESUME IN MS WORD.


Q4 DESIGN A POSTER IN MS WORD ON THE FOLLOWING TOPICS INCLUDING PAGE
BORDER, PAGE COLOUR, WATERMARK, IMAGES ETC:
a. CORONA VIRUS(SYMPTOMS AND PREVENTION)
b. IMPORTANCE OF TIME
c. FIT INDIA
d. IMPACT OF SOCIAL MEDIA IN OUR LIFE
e. ORGANIC V/S INORGANIC EATABLES
f. CORONA WARRIORS

Q5. PREPARE A NOTICE IN MS WORD ON ANY OFFICIAL TOPIC OF YOUR CHOICE.

Q6.CREATE A MAIL MERGE APPLICATION WHICH PRODUCES MULTIPLE


INVITATION LETTERS ON ANY OCCASION/RECRUITMENT/JOB OFFER LETTER TO
BE SENT TO VARIOUS EMPLOYEES IN AN ORGANIZATION IN MS WORD. MENTION
STEPS ALSO.
Q7. INTRODUCTION TO MS POWER POINT
A) HISTORY OF MS POWER POINT
B) FEATURES OF MS POWER POINT
C) VERSIONS OF MS POWER POINT
D) HOW TO OPEN AND SAVE MS POWER POINT
Q8. PREPARE MINIMUM 5-10 SLIDES ON MS POWER POINT ON ANY TOPIC THAT
YOU HAVE STUDIES IN COMPUTER APPLICATION THEORY
Q9. INTRODUCTION TO MS EXCEL
A) HISTORY OF MS EXCEL
B) FEATURES OF MS EXCEL
C) VERSIONS OF MS EXCEL
D) HOW TO OPEN AND SAVE MS EXCEL
Q10. PERFORM THE FOLLOWING STATISTICAL FUNCTION IN MS
EXCEL:(PERFORM MIN 5-5 FUNCTIONS FOR EACH FORMULAS)
A) AVERAGE
B) COUNT
C) COUNT
D) COUNT A
E) COUNT IF
F) COUNT BLANK
G) MAX
H) MIN
I) IF
Q11. PERFORM THE FOLLOWING MATHS FUNCTION IN MS-EXCEL:(PERFORM MIN
5-5 FUNCTIONS FOR EACH FORMULAS)
A) ABS
B) EXP
C) RAND
D) RAND BETWEEN
E) SQRT
F) SUM
G) SUMSQ
H) TRUNC
Q12. PERFORM THE FOLLOWING DATE AND TIME FUNCTION IN MS-EXCEL
:(PERFORM MIN 5-5 FUNCTIONS FOR EACH FORMULAS)
A) TODAY
B) DAY
C) DAYS
D) TIME
E) NOW
Q13. PERFORM THE FOLLOWING TEXT FUNCTION IN MS-EXCEL :(PERFORM MIN 5-
5 FUNCTIONS FOR EACH FORMULAS)
A) CONCATENATE
B) LENGTH
C) FIND
D) LEFT
E)RIGHT
F) MID
G) SUBSTITUTE
H)EXACT
I) PROPER
J) UPPER
K) TRIM
Q14. USE THE TABLE CREATED IN QUESTION 10, PREPARE THE BAR/COLUMN
CHART TO COMPARE THE RESULT OF STUDENTS ON THE BASIS OF MARKS
OBTAINED BY THE STUDENTS.
Q15. USE THE TABLE CREATED IN QUESTION 10, PREPARE THE PIE/DONUT CHART
TO COMPARE THE RESULT OF STUDENTS ON THE BASIS OF MARKS OBTAINED BY
THE STUDENTS.
Practical list of computer applications
Practical 1
Q1 INTRODUCTION TO MSWORD:
• HISTORY OF MS WORD
• FEATURES OF MSWORD
• VERSIONS OF MS WORD
• HOW TO OPEN AND SAVE MS WORD DOCUMENT

MS WORD
INTRODUCTION
Microsoft Word is word processing software developed by Microsoft. It was first released on October
25, 1983 under the name Multi-Tool Word for Xenix systems. Subsequent versions were later written for
several other platforms including IBM PCs running DOS (1983), Apple Macintosh running the Classic
Mac OS (1985), AT&T UNIX PC (1985), Atari ST (1988), OS/2 (1989), Microsoft
Windows (1989), SCO Unix (1990), and macOS (2001).
Commercial versions of Word are licensed as a standalone product or as a component Microsoft
office 365, or Microsoft 365 Premium subscription, Windows RT or the discontinued Microsoft Works
suite.
HISTORY OF MS WORD
In 1981, Microsoft hired Charles Simonyi, the primary developer of Bravo, the first GUI word processor,
which was developed at Xerox PARC. Simonyi started work on a word processor called Multi-Tool
Word and soon hired Richard Brodie, a former Xerox intern, who became the primary software engineer.
Microsoft announced Multi-Tool Word for Xenix and MS-DOS in 1983. Its name was soon simplified
to Microsoft Word. Free demonstration copies of the application
were bundled with the November 1983 issue of PC World, making it the first to be distributed on-disk with
a magazine. That year Microsoft demonstrated Word running on Windows.
Unlike most MS-DOS programs at the time, Microsoft Word was designed to be used with a
mouse. Advertisements depicted the Microsoft Mouse and described Word as a WYSIWYG, windowed
word processor with the ability to undo and display bold, italic, and underlined text, although it could not
render fonts. It was not initially popular, since its user interface was different from the leading word
processor at the time, WordStar. However, Microsoft steadily improved the product, releasing versions 2.0
through 5.0 over the next six years. In 1985, Microsoft ported Word to the classic Mac OS (known as
Macintosh System Software at the time). This was made easier by Word for DOS having been designed for
use with high-resolution displays and laser printers, even though none were yet available to the general
public. It was also notable for its very fast cut-and-paste function and unlimited number of undo operations,
which are due to its usage of the piece table data structure.
Following the precedents of Lisa Write and MacWrite, Word for Mac OS added true WYSIWYG features. It
fulfilled a need for a word processor that was more capable than MacWrite After its release, Word for Mac
OS's sales were higher than its MS-DOS counterpart for at least four years
In 1986, an agreement between Atari and Microsoft brought Word to the Atari Sunder the name Microsoft
Write. The Atari ST version was a port of Word 1.05 for the Mac OS and was never updated

FEATURES OF MS WORD

Home

This Feature of MS word has options like font color, font size, font style, alignment, bullets, line spacing,
etc. Additionally, all the basic elements which one may need to edit their document are available under the
Home option.

Insert

You can enter tables, shapes, images, charts, graphs, header, footer, page number, etc., in the document.
These Features of MS word are available in the “Insert” category.

Design

You can create or select the template or the design under the Design Tab in which you want your document
to be by using this Features of MS word. Moreover, choosing an appropriate tab will enhance the
appearance of your document on MS Word.

Page Layout

This Features of MS word under the Page Layout tab come options like margins, orientation, columns, lines,
indentation, spacing, etc.

References
This tab is the most useful feature of MS word for those who are creating a thesis or writing books or
lengthy documents. Options like citation, footnote, table of contents, caption, bibliography, etc. are present
under this tab.

Review

Spell check, grammar, thesaurus, word count, language, translation, comments, etc., everything is track able
under the review tab .Additionally it benefits those who review their documents in Microsoft Word.

VERSIONS OF MS WORD

Word for
1989 Windows 1.0 Code-named Opus
1.0

Word for
1990 Windows 1.1 For Windows 3.0. Code-named Bill the Cat
1.1

Word for
On March 25, 2014 Microsoft made the source code to Word for Windows
1990 Windows 1.1a
1.1a available to the public via the Computer History Museum.
1.1a

Word for
1991 Windows 2.0 Included in Office 3.0.
2.0

Version numbers 3, 4 and 5 were skipped, to bring Windows version


Word for
numbering in line with that of DOS, Mac OS, and WordPerfect (the main
1993 Windows 6.0
competing word processor at the time). Also a 32-bit version for Windows
6.0
NT only. Included in Office 4.0, 4.2, and 4.3.

Word for
1995 7.0 Included in Office 95
Windows 95

1997 Word 97 8.0 Included in Office 97

1998 Word 98 8.5 Included in Office 97


1999 Word 2000 9.0 Included in Office 2000

2001 Word 2002 10.0 Included in Office XP

Microsoft
2003 11.0 Included in Office 2003
Word 2003

Included in Office 2007; released to businesses on November 30, 2006,


Microsoft
2006 12.0 released worldwide to consumers on January 30, 2007. Extended support
Word 2007
until October 10, 2017.

2010 Word 2010 14.0 Included in Office 2010; skipped 13.0 due to triskaidekaphobia.

2013 Word 2013 15.0 Included in Office 2013

2016 Word 2016 16.0 Included in Office 2016

2019 Word 2019 16.0 Included in Office 2019

2021 Word 2021 16.0 Included in Office 2021

HOW TO OPEN AND SAVE MS WORD DOCUMENT

• Opening MS Word
1. Click the Start button. Type "word" without quotation marks into the search box. Click "Microsoft
Word 2010" in the list that appears.

2. Click the Start button. However the mouse pointer over "All Programs." Scroll down to the Microsoft
Office folder and click it. Select "Microsoft Word 2010."

• Saving MS Word document

1. Move up to the top of the ribbon and click the FILE tab, and the backstage opens. You won't find
any commands for working with text here.
2. The backstage is all about opening, saving, printing, sharing, and exporting. In other words, the
behind-the-scenes stuff you do with a document file.
3. Click Save and you get a choice.
4. You can save it to your Computer, or you can save to the cloud by using Microsoft 365
SharePoint or One Drive.
5. I have already signed in to my online account, so now I can click here and Browse for a location on
my One Drive.
6. Enter a File name and click Save.
7. It's just like saving to a computer, except that now I can access the file on any computer connected to
the Internet, or I can Share it with others by sending an email message containing a link to the online
file.
8. After you save your document, you can keep working on it if you want, or you can click Close and
work on it later.
9. When your document is ready to go, click the FILE tab, and Save it one last time
Practical 2
Q2 CREATE A TIME TABLE IN MS WORD DESCRIBING THE SCHEDULE OF
LECTURES/CLASSES.
TIME TABLE
10:00am – 11:00am - 12:00am 12:30pm – 01:30pm – 02:30pm -
Day/Time 11:00am 12:00am – 01:30pm 02:30pm 03:30pm
12:30pm
BUSINESS IT Financial Business
MONDAY ECONOMICS Applications in
(Dr. Deepali)

BUSINESS
business
(Ms.Neha)
Business maths
B accounting
(Ms.Divya)

Management
maths
(Ms.Knaika)

IT
-
TUESDAY ECONOMICS (Ms.Knaika)
(Dr. Deepali)
R process &
organizational
behavior
(Ms.Shweta)
Applications
in business
(Ms.Neha) -
Financial Business maths IT Management
WEDNEDAY accounting
(Ms.Divya)
(Ms.Knaika)
E Applications
in business
(Ms.Neha)
process &
organizational
behavior -
(Ms.Shweta)
THRUSDAY Management
process &
organizational
behavior
Financial
accounting
(Ms.Divya)
A IT
Applications
in business
(Ms.Neha)
BUSINESS Entrepreneurial
ECONOMICS mindset
(Dr. Deepali) (Ms. Tanya)

FRIDAY
(Ms.Shweta)
Management Entrepreneurial
K Business IT
process &
organizational
behavior
(Ms.Shweta)
mindset
(Ms. Tanya)
maths
(Ms.Knaika)
Applications
in business -L
(Ms.Neha) -
Financial BUSINESS IT Business
SATURDAY accounting
(Ms.Divya)
ECONOMICS
(Dr. Deepali)
Applications
in business -L
(Ms.Neha)
maths
(Ms.Knaika)
-
Practical 3
Q3 CREATE YOUR RESUME IN MS WORD.
Practical 4
Q4 DESIGN A POSTER IN MS WORD ON THE FOLLOWING TOPICS INCLUDING PAGE BORDER,
PAGE COLOUR, WATERMARK, IMAGES ETC:
a. CORONA VIRUS(SYMPTOMS AND PREVENTION)
b. IMPORTANCE OF TIME
c. FIT INDIA
d. IMPACT OF SOCIAL MEDIA IN OUR LIFE
e. ORGANIC V/S INORGANIC EATABLES
f. CORONA WARRIORS

Practical 5

NOTICE
Trinity institute of professional studies
NOTICE

22nd January, 2022

Change in college Timings


all students are hereby informed about a change in college timings from 1st October, 20xx.
The college will now start at 9 a.m. & end at 3 p.m. In the past few years, it has been seen
that winters are rather severe and it becomes quite difficult to start early due to the extreme
cold weather and the dense fog. So these new timings will be followed till further notice.

Principal

Practical 6
Create a mail merge application which produces multiple invitation letters on any occasion/Recruitment/job offer
letter to be sent to various employees in an organization in ms word. Mention steps also.

1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group,

click Start Mail Merge.


2. Click Step-by-Step Mail Merge Wizard.

3. Select your document type. In this demo we will select Letters. Click Next: Starting document
.

4. Select the starting document. In this demo we will use the current (blank) document. Select Use the
current document and then click Next: Select recipients.
o Note that selecting Start from existing document (which we are not doing in this demo)
changes the view and gives you the option to choose your document. After you choose it, the

Mail Merge Wizard reverts to Use the current document.


5. Select recipients. In this demo we will create a new list, so select Type a new list and then
click Create.
o Create a list by adding data in the New Address List dialog box and clicking OK.
o Save the list.
o Note that now that a list has been created, the Mail Merge Wizard reverts to Use an existing
list and you have the option to edit the recipient list.
o Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can
edit the list and select or unselect records. Click OK to accept the list as is.
o Click Next: Write your letter.

6. Write the letter and add custom fields.

o Click Address block to add the recipients' addresses at the top of the document.
o In the Insert Address Block dialog box, check or uncheck boxes and select options on the left

until the address appears the way you want it to.


o Note that you can use Match Fields to correct any problems. Clicking Match Fields opens up
the Match Fields dialog box, in which you can associate the fields from your list with the
fields required by the wizard.
7. Press Enter on your keyboard and click Greeting line... to enter a greeting.

8. The Insert Greeting Line dialog box, choose the greeting line format by clicking the drop-down

arrows and selecting the options of your choice, and then click OK.
9. Note that the address block and greeting line are surrounded by chevrons (« »). Write a short letter
and click next: Preview your letters.\

• Preview your letter and click next: Complete the merge.


• Click Print to print your letters or Edit individual letters to further personalize some or all of the
letters.
Practical 7
Introduction to MS Power Point
a) History of MS Power Point
b) Features of MS Power Point
c) Versions of MS Power Point
d) How to open and save MS Power Point

Note: kindly paste the screenshots

Introduction to MS Power Point


MS PowerPoint is a program that is included in the Microsoft Office suite. It is used to make presentations
for personal and professional purposes.
In this article, we shall discuss in detail the functions and features of a PowerPoint presentation, followed by
some sample questions based on this topic for the upcoming competitive exams.
To learn more about the different programs under Microsoft Office

Features of MS Power Point

Advanced Features of MS PowerPoint


• Customize Color Schemes.
• Add Animation effects.
• Use the Slide, Notes and Handout Masters.
• Create Edit and Import Charts.
• Create and Edit Tables.
• Manage Hyperlinks.
• Create Custom Shows.
• Export Outlines & Presentation Slides to Word

Versions of MS Power Point

Date Name Version System

January 2018 PowerPoint 2016 for Windows Store 16.0 Windows


Date Name Version System

2018 PowerPoint 2019 17.0 Windows and other OS

September 2015 PowerPoint 2016 for Windows 16.0 Windows

July 2015 PowerPoint Mobile 2016 for iOS 16.0 iOS

July 2015 PowerPoint Mobile 2016 16.0 Windows 10 Mobile

July 2015 PowerPoint 2016 for Macintosh 16.0 Macintosh

June 2015 PowerPoint Mobile 2016 for Android 16.0 Android

November 2014 PowerPoint Mobile 2013 for iOS 15.0 iOS

March 2014 PowerPoint 2013 for iPad 15.0 iPad

February 2014 PowerPoint 2013 Online 15.0 Web

July 2013 PowerPoint Mobile 2013 for Android 15.0 Android

June 2013 PowerPoint Mobile 2013 for iPhone 15.0 iPhone

January 2013 PowerPoint 2013 15.0 Windows

November 2012 PowerPoint RT 2013 15.0 Windows RT

November 2012 PowerPoint Mobile 2013 15.0 Windows Phone 8

October 2012 PowerPoint Web App 2013 15.0 Web

April 2012 PowerPoint Mobile 2010 14.0 Nokia Symbian

November 2010 PowerPoint 2011 14.0 Macintosh


Date Name Version System

June 2010 PowerPoint Mobile 2010 14.0 Windows Phone 7

June 2010 PowerPoint 2010 Web App 14.0 Web

June 2010 PowerPoint 2010 14.0 Windows

January 2008 PowerPoint 2008 12.0 Macintosh

September 2007 PowerPoint Mobile 12.0 Windows Mobile 6

January 2007 PowerPoint 2007 12.0 Windows

May 2005 PowerPoint Mobile 11.0 Windows Mobile 5

June 2004 PowerPoint 2004 11.0 Macintosh

October 2003 PowerPoint 2003 11.0 Windows

November 2001 PowerPoint v. X 10.0 Macintosh

May 2001 PowerPoint XP 10.0 Windows

August 2000 PowerPoint 2001 9.0 Macintosh

June 1999 PowerPoint 2000 9.0 Windows

March 1998 PowerPoint 98 8.0 Macintosh

January 1997 PowerPoint 97 8.0 Windows

July 1995 PowerPoint 95 7.0 Windows

October 1994 PowerPoint 4.0 Macintosh


Date Name Version System

February 1994 PowerPoint 4.0 Windows

September 1992 PowerPoint 3.0 Macintosh

May 1992 PowerPoint 3.0 Windows

May 1990 PowerPoint 2.0 Windows

December 198 PowerPoint 2.01 Macintosh

May 1988 PowerPoint 2.0 Macintosh

October 1987 PowerPoint 1.01 Macintosh

April 1987 PowerPoint 1.0 Macintosh

How to open and save MS Power Point

• How to open Ms Power point

1. Click the Windows "Start" button, and then select “All Programs.”
2. Scroll through the list of folders that appear to find the folder labeled “Microsoft Office.”
3. Click that folder, and then click the “Microsoft PowerPoint” icon to open PowerPoint.

• How to save Ms Power point presentation

Practical 8
Prepare minimum 5-10 slides on MS Power Point on any topic that you have studies in Computer Application theory

NOTE: Take printout of min 3-4 slides only


1.

2.
3.

Practical 9
Introduction to MS EXCEL
a) History of MS EXCEL
b) Features of MS EXCEL
c) Versions of MS EXCEL
d) How to open and save MS EXCEL

Note: kindly paste the screenshots

Introduction to MS EXCEL

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It
features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming
language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of
software

History of MS EXCEL
Microsoft developed a competing spreadsheet, and the first version of Excel was released in 1985 for Apple
Inc.’s Macintosh computer. Featuring strong graphics and fast processing, the new application quickly
became popular.

Features of MS EXCEL

1. Add Header and Footer


MS Excel allows us to keep the header and footer in our spreadsheet document.
2. Find and Replace Command
MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing
data with a new one.
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their
information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays
only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering
ranges:

• AutoFilter; which includes filter by selection, for simple criteria


• Advanced Filter; for more complex criteria
5. Data Sorting
Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in
ascending or descending order.
6. Built-in formulae
MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per
our needs.
7. Create different charts (Pivot Table Report)
MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This helps us to
analyze and compare data very easily.
8. Automatically edits the result
MS Excel automatically edits the result if any changes are made in any of the cells.
9. Formula Auditing
Using formula auditing we can graphically display or trace the relationships between cells and formulas with
blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the
cells that depend on the value in a specific cell).

Versions of MS EXCEL
Excel 365
Excel 2019
Excel 2016 and 365
Excel 2013 (Windows)
Excel 2011 (Mac)
Excel 2010 (Windows)
Excel 2008 (Mac)
Excel 2007 (Windows)
Excel 2004 (Mac)
Excel 2003 (Windows)

How to open and save MS EXCEL


How to open MS excel

• Click the Start button. Type "word" without quotation marks into the search box. Click "Microsoft
Word 2010" in the list that appears.
• Click the Start button. Hover the mouse pointer over "All Programs." Scroll down to the Microsoft
Office folder and click it. Select "Microsoft Word 2010."
• Press the Windows key and "R" on the keyboard at the same time to bring up the Run dialogue.
Type "WinWord.exe" without quotation marks into the box.
• Right-click on an empty area of the Windows 7 desktop. Hover the mouse pointer over "New" in
the menu that appears. Click "Shortcut." Type or copy and paste "C:\Program Files\Microsoft
Office\Office14\WINWORD.EXE" into the box. Click "Next." Type "Word" into the box and click
"Finish." Double-click the Word shortcut that appears on the desktop to launch Word.
• Open an MS Word file on your computer by double-clicking it. If you are asked to choose an
application to open the file with, select "Microsoft Word." You may close the file you have opened
if you do not want to use it now and open another one instead.
How to save MS excel file

1. Click File > Save As

2. Under Save As, pick the place where you want to save your workbook. For example, to save to your
desktop or in a folder on your computer, click Computer.

3. Click Browse to find the location you want in your Documents folder. To pick another location on
your computer, click Desktop, and then pick the exact place where you want to save your workbook.
4. In the File name box, enter a name for a new workbook. Enter a different name if you’re creating a
copy of an existing workbook

.
5. To save your workbook in a different file format (like .xls or .txt), in the Save as type list (under the File
name box), pick the format you want.

6. Click Save.

Practical 10
Perform the following Statistical Function in MS EXCEL:(perform min 5-5 functions for each formulas)
a) AVERAGE
b) COUNT
c) COUNT
d) COUNT A
e) COUNT IF
f) COUNT BLANK
g) MAX
h) MIN
i) IF

Note: Paste the screenshot and write the formula name ,definition and syntax

Practical 11
Perform the following Maths Function in MS-EXCEL:(perform min 5-5 functions for each formulas)
a) ABS
b) EXP
c) RAND
d) RAND BETWEEN
e) SQRT
f) SUM
g) SUMSQ
h) TRUNC

Note: Paste the screenshot and write the formula name ,definition and syntax

Practical 12
Perform the following Date and Time function in MS-Excel :(perform min 5-5 functions for each formulas)
a) TODAY
b) DAY
c) DAYS
d) TIME
e) NOW

Note: Paste the screenshot and write the formula name ,definition and syntax

Practical 13
Perform the following Text function in MS-Excel :(perform min 5-5 functions for each formulas)
a) CONCATENATE
b) LENGTH
c) FIND
d) LEFT
e)RIGHT
f) MID
g) SUBSTITUTE
h)EXACT
i) PROPER
j) UPPER
k) TRIM

Note: Paste the screenshot and write the formula name ,definition and syntax
Practical 14
Use the table created in question 10, prepare the BAR/COLUMN chart to compare the result of students on the basis of
marks obtained by the students.

Note: Create the data with student's name, subject's name, marks obtained and total marks obtained .

Practical 15
Use the table created in question 10, prepare the PIE/DONUT chart to compare the result of students on the basis of
marks obtained by the students.

Note: Create the data with student's name, subject's name, marks obtained and total marks ob tained.

You might also like