SECTION A (MS WORD)

Q1. Introduction to MS Word and its features.

ANS. Microsoft Word is a widely used word processing software developed and
published by Microsoft. It enables users to create, edit and format text, paragraphs,
and documents. Word offers a wide range of tools and features that allow users to
customize the appearance and layout of their documents, including options for font,
size, style, and color. It also offers tools for inserting images, tables, and other media,
as well as creating and editing charts, graphs, and diagrams. Word also includes
advanced features such as mail merge, track changes, and collaboration tools that
allow multiple users to work on a document simultaneously. Additionally, it has the
ability to check grammar, spelling, and punctuation, and it also has support for
multiple languages. Word is available for Windows, Mac, iOS, and Android platforms.

Some of the key features of Microsoft Word include:

1. Text formatting: Allows users to customize the appearance of text, including
font, size, style, and colour.
2. Paragraph formatting: Allows users to control the layout of paragraphs,
including line spacing, indents, and alignment.
3. Styles: Enables users to quickly apply consistent formatting across a document.
4. Templates: Provides pre-designed document templates for various types of
documents, such as resumes, letters, and reports.
5. Tables and Charts: Allows users to insert tables and charts, and then edit and
format them as needed.
6. Images and Media: Enables users to insert and format images, videos, and
audio files in the document.
7. Collaboration: Includes tools for commenting, sharing and co-authoring
documents.
8. Spell Check and Grammar: Includes tools for checking spelling, grammar, and
punctuation.
9. Mail Merge: A feature that allows users to create a single document and then
use it to generate multiple personalized versions.
10.Track Changes: Allows users to track changes made to the document by
different authors.
11.Multiple languages: Support for multiple languages, which allows for the
creation and editing of documents in different languages.
12.File Export and Compatible: The ability to export and import files in different
formats such as PDF, RTF, HTML, and more.
Q2. Explain DBMS.

ANS. A database management system (DBMS) is software that allows users to

interact with a database. It provides a way to create, read, update, and delete data
stored in a database. The DBMS also controls access to the database and ensures the
integrity and consistency of the data.
The DBMS is responsible for managing the database's physical storage, including
creating, reading and writing data to disk or other storage media, as well as managing
concurrent access to the data by multiple users. It also provides a way for users to
query and retrieve data from the database using a query language, such as SQL
(Structured Query Language).
There are several types of DBMS, including:
1. Relational DBMS (RDBMS) which is based on the relational model.
2. Object-oriented DBMS (OODBMS) which is based on the object-oriented
model.
3. Hierarchical DBMS (HDBMS) which is based on the hierarchical model.
4. Network DBMS (NDBMS) which is based on the network model.
A DBMS allows for efficient and secure storage and retrieval of large amounts of
data. It enables organizations to manage and organize data in a structured way, and
supports the development of applications that use the data in the database.

Q3. Explain Cloud Computing & Prepare the Following:

1. Prepare Resume
2. Time –Table for BBA First semester
3. What is Mail Merge explain practically
4. Write complain letter
5. Prepare Calendar for 2023 Feb Month.
6. Write the Steps for A8B5 and X6+Y6 = 0
ANS. Cloud Computing can be defined as delivering computing power (CPU, RAM,
Network Speeds, Storage OS software) a service over a network (usually on the
internet) rather than physically having the computing resources at the customer
location.
Whenever you travel through a bus or train, you take a ticket for your destination
and hold back to your seat till you reach your destination. Likewise other passengers
also take ticket and travel in the same bus with you and it hardly bothers you where
they go. When your stop comes you get off the bus thanking the driver. Cloud
computing is just like that bus, carrying data and information for different users and
allows to use its service with minimal cost.
The term "Cloud" came from a network design that was used by network engineers
to represent the location of various network devices and their inter-connection. The
shape of this network design was like a cloud.
With increase in computer and Mobile user's, data storage has become a priority in
all fields. Large- and small-scale businesses today thrive on their data & they spent a
huge amount of money to maintain this data. It requires a strong IT support and a
storage hub. Not all businesses can afford high cost of in- house IT infrastructure and
back up support services. For them Cloud Computing is a cheaper solution. Perhaps
its efficiency in storing data, computation and less maintenance cost has succeeded
to attract even bigger businesses as well.
Cloud computing decreases the hardware and software demand from the user's side.
The only thing that user must be able to run is the cloud computing systems interface
software, which can be as simple as Web browser, and the Cloud network takes care
of the rest. We all have experienced cloud computing at some instant of time, some
of the popular cloud services we have used or we are still using are mail services like
Gmail, Hotmail or Yahoo etc.
PREPARE RESUME
TIME TABLE FOR BBA FIRST SEMESTER
9:30-10:20 10:20-11:10 11:10-12:00 12:00-12:50 12:50-1:40

MONDAY Management Management Entrepreneurial Entrepreneuria Information

Process & Process & Mindset l Mindset & Technology
Organisational Organisational
Behaviour Behaviour

TUESDAY Management Business Financial Business Information

Process & Economics Accounting Mathematics & Technology
Organisational - Lab
Behaviour

WEDNESDAY Management Financial Financial Business Business

Process & Accounting Accounting Mathematics Economics
Organisational
Behaviour

THURSDAY Management Business Financial Information &

Process & Economics Accounting Technology
Organisational
Behaviour

FRIDAY Management Business Financial Business

Process & Economics Accounting Mathematics
Organisational
Behaviour

SATURDAY Information & Business Business Information &

Technology Economics Mathematics Technology -
Lab
WHAT IS MAIL MERGE AND EXPLAIN IT PRACTICALLY?

Mail merge is a feature in Microsoft Word that allows you to create personalized
letters, emails, or labels for mass mailings. It allows you to combine a standard
document (such as a letter template) with a data source (such as a spreadsheet) to
generate personalized copies of the document for each recipient. The data source is
typically an Excel spreadsheet, but it can also be a database, an Access file, or a list in
Word.
Mail merge can save a lot of time and effort when you need to send out a large
number of personalized letters, emails, or labels.

The process of mail merge typically involves the following steps:

1. Create a data source, such as an Excel spreadsheet, that contains the
information for each recipient, such as their name, address, and other details.
2. Create a template document, such as a letter or an email, that will be used as
the basis for the personalized copies.
3. In Word, go to the Mailings tab and select "Start Mail Merge."
4. Select the type of document you want to create (e.g., letters, emails, labels)
5. Select the data source to link to your mail merge document.
6. Use placeholders (for example, Mail formed citation <<Name>>) in your
document to represent the data from your data source that you want to be
included in the personalized copies.
7. Preview and edit the personalized copies as needed.
8. Finally, you can print or send the personalized copies to the recipients.
WRITE A COMPLAIN LETTER

63rd Street
Sai Avenue
Banglore-29

Date: 26th January, 2023

Customer Service Manager

XYZ Company
New Delhi, 11**89

Subject: Complaint Letter for Poor Service

Mr./ Ms. ABC

My name’s JKL. I am writing this letter to complain to you about the poor service provided by you
company. The network you have provided was not working properly and it always caused a
fluctuation, which resulted in dropping the network.

Since, I am a working person and most sf my work is done from home, I am not able to finish my
work because of this network issue. I have raised the complaint for the complaint a lot of times by
calling to your customer representative, but there has been no resolution provided till yet.

I hereby request to please my issue as soon as possible or else I have to stop using your service with
an unsatisfactory note. Also, for this month I an mot going to pay for your service unless the
problem is resolved.

Yours Faithfully,
MVN
PREPARE A CALENDER FOR 2023
FEBRUARY MONTH

2023 202
3
Monday Tuesday Wednesday Thursday Friday Saturday Sunday

1 2 3 4 5 6 7

8 9 10 11 12 13 14

15 16 17 18 19 20 21
WRITE THE STEPS FOR A8B5 and X6+Y6 = 0

In Microsoft Word, subscript and superscript are formatting options that allow you to
adjust the position of text relative to the baseline of the text. Subscript text appears
slightly below the baseline, while superscript text appears slightly above the baseline.
These formatting options are typically used to indicate mathematical or scientific
notation, such as in chemical formulas or mathematical equations. They can be
applied to individual characters or entire blocks of text. They can be access via the
font toolbar or through shortcut key (ctrl + = for superscript and ctrl + shift + = for
subscript)
As per the question:

Here A8B5 are in the normal punctuation,

To convert it into subscript form, we will select the “X2” in the ribbon in the home
option and select it to convert it to subscript.
A8B5 = A8B5

Similarly for the superscript,

We will select the “X2” option in the ribbon in the home option and select it to
convert it to superscript.
X6+Y6=0 => X6+Y6=0.
SECTION B (MS EXCEL)

Q1. Introduction to MS Excel And its Features.

ANS. Microsoft Excel is a spreadsheet software application that allows users to

organize, analyze, and manipulate data in a tabular format. It is widely used for tasks
such as creating budgets, tracking expenses, and analyzing data.

Some of the key features of Microsoft Excel include:

1. Data organization: Excel allows users to organize data in rows and columns,
making it easy to sort and filter data.
2. Formulas and functions: Excel have a wide range of built-in formulas and
functions that can be used to perform calculations and analyze data.
3. Charts and graphs: Excel can create various types of charts and graphs, such as
bar charts, line charts, and pie charts, which help to visualize data.
4. Pivot tables: Excel allows users to create pivot tables, which allow users to
quickly summarize large amounts of data.
5. Macros: Excel allows users to record and save sequences of commands as
macros, which can be played back to automate repetitive tasks.
6. Data validation: Excel allows users to set data validation rules, which can be
used to ensure that data entered into a spreadsheet meets certain criteria.
7. Collaboration: Excel allows multiple users to collaborate on a spreadsheet in
real-time.
8. Data Import and Export: Excel can import data from a wide variety of sources
such as CSV, text, and other excel files, and can also export data to different
formats.
9. Conditional Formatting: Excel allows users to apply conditional formatting to
cells, based on the values of the cell or the value of a formula.
10. Smart Lookup: Excel allows users to perform research on the selected data
using Bing search engine.

These are just a few of the many features of Microsoft Excel, and there are many
more capabilities of this powerful software.
Q2. Explain different function of Excel.
ANS. There are many functions available in Microsoft Excel, which can be used to
perform a wide range of calculations and data analysis. Some of the most commonly
used functions include:

1. SUM: This function adds up a range of cells.

2. AVERAGE: This function calculates the average of a range of cells.
3. COUNT: This function counts the number of cells in a range that contain
numbers.
4. MIN and MAX: These functions find the smallest and largest values in a range
of cells.
5. IF: This function tests a condition and returns one value if the condition is true
and another value if the condition is false.
6. VLOOKUP: This function looks up a value in a table and returns a corresponding
value from a specified column.
7. INDEX and MATCH: These functions are used to look up values in a table,
similar to VLOOKUP, but can be more flexible.
8. CONCATENATE: This function combines text from multiple cells into one cell.
9. LEFT, RIGHT, and MID: These functions extract characters from a text string.
10.DATE and TIME: These functions can be used to work with dates and times in
Excel.
11.LEN: This function returns the number of characters in a text string.
12.CONCAT: This function combines the text from multiple ranges and/or strings.
13.INDEX and MATCH: These functions are used to look up values in a table,
similar to VLOOKUP, but can be more flexible.
14.COUNTIF and SUMIF: These functions are used to count or sum cells based on
a specified condition.
15.ROUND: This function rounds a number to a specified number of decimal
places.

These are just some examples of the many functions available in Excel. Each function
has a specific use and can be used to perform different types of calculations
depending on the data you have and the analysis you want to perform.
Q3. Explain Pivot Table with examples.

ANS. A pivot table is a powerful tool in Microsoft Excel that allows users to
summarize and analyze large amounts of data. It can be used to organize and present
data in a way that makes it easy to understand and analyze.
For example, let's say you have a spreadsheet with a list of sales transactions,
including the date, customer name, product name, and sale amount. A pivot table
can be used to summarize this data in a way that makes it easy to analyze the sales
by product, customer, or time period.

Here are the steps to create a pivot table in Excel:

1. Select the data range that you want to use for the pivot table.
2. Click the "Insert" tab in the ribbon, then click "Pivot Table"
3. In the "Create PivotTable" dialog box, choose the location for the pivot table
and press "OK"
4. In the PivotTable Fields pane, drag the fields that you want to use in the pivot
table to the "Values", "Rows", or "Columns" areas.
5. For example, you can drag the "Product Name" field to the "Rows" area, the
"Sale Amount" field to the "Values" area, and the "Date" field to the "Columns"
area.
6. The pivot table will be created and you will see the summary data organized by
the fields you selected in the Rows, Columns and values area.
7. You can also use filters and slicers to filter the data and create different views
of the data.
8. You can also use the pivot chart to represent all of this data.
Q4.

(a) Introduction of Excel (Rows, Columns and Functions)

ANS. In Microsoft Excel, rows and columns are the building blocks of a
spreadsheet. Each row is identified by a number and contains a series of
cells, while each column is identified by a letter and contains a series of
cells. The intersection of a row and a column is called a cell, and each cell
can contain data or a formula.

Functions are pre-built formulas in Excel that perform a specific calculation

or operation. They are used to perform a wide range of calculations and
data analysis, such as summing a range of numbers, finding the average of
a range of cells, or counting the number of cells in a range that contain a
specific value.

Some of the most commonly used functions in Excel include:

1. SUM: This function adds up a range of cells.

2. AVERAGE: This function calculates the average of a range of cells.
3. COUNT: This function counts the number of cells in a range that
contain numbers.
4. MIN and MAX: These functions find the smallest and largest values in
a range of cells.
5. IF: This function tests a condition and returns one value if the
condition is true and another value if the condition is false.
6. VLOOKUP: This function looks up a value in a table and returns a
corresponding value from a specified column.
7. INDEX and MATCH: These functions are used to look up values in a
table, similar to VLOOKUP, but can be more flexible, and etc.
S.N Emplo Joini Designa Departm Basi HR T D CC P I Tot Sala
O. yee ng tion ent c A A A A F T al ry in
name Date Sala Sala han
ry ry d

(b) Prepare a Marks list for 40 students and find percentage, grade through
nested ‘if condition’?
Conditions are given below:

I. Grade Condition
II. A 85%
III. B less than 85%
IV. Count no of students A & B Grade through Count IF Condition?
S. Emplo Dat designat Dep Basi HRA TA DA CC PF IT Total Salary
N yee e of ion t. c A salary
o. Name Join Sala In
ing ry Hand

(c) Find The net salary on the basis of Following data

Deductions PF& IT From basic salary

Addition on Basic salary HRA=70.25%, TA=27.85%, DA=17.65%, CCA=29.7%,
PF=12.75%,
Income tax =10% (all the allowances are applicable on basic salary)
(d) Prepare a sales report of the following automobile companies.

Company name Segment Product Cost leadership Sales volume

differentiation

Hyundai

Small 5 3 35000

Medium 3 5 26000

large 2 7 20000

Honda

Small 4 2 27000

Medium 1 9 20000

large 3 1 15000

Maruti

Small 2 4 42000

Medium 5 6 35000

large 3 8 22000

Draw a column chart between:

 Company & product differentiation
 Company & cost leadership.
Draw a Bar chart between:
 Company & sales volume.
SALES VOLUME

LARGE
MARUTI

MEDIUM

SMALL

LARGE
HONDA

MEDIUM

SMALL

LARGE
HYUNDAI

MEDIUM

SMALL

0 5000 10000 15000 20000 25000 30000 35000 40000 45000

PRODUCT DIFFERENTIATION
6

0
SMALL MEDIUM LARGE SMALL MEDIUM LARGE SMALL MEDIUM LARGE
HYUNDAI HONDA MARUTI
COST LEADERSHIP
10

0
SMALL MEDIUM LARGE SMALL MEDIUM LARGE SMALL MEDIUM LARGE
HYUNDAI HONDA MARUTI

SECTION C (MS POWER POINT)

Q1. Introduction to MS Power Point and its features, Explain.

ANS. Microsoft PowerPoint is a presentation software that allows users to create,

edit, and deliver presentations. It is a part of the Microsoft Office Suite and is
commonly used for creating slideshows for business, educational, and personal use.

Some key features of PowerPoint include:

1. Slideshow creation: Users can create slides with text, images, videos, and
other multimedia elements to create engaging presentations.
2. Templates: PowerPoint comes with a wide variety of templates, including
themes, layouts, and designs, that users can use to quickly create professional-
looking presentations.
3. Animation and transition effects: Users can add animations and transition
effects to elements on their slides to make their presentations more dynamic.
4. Collaboration: PowerPoint allows multiple users to work on the same
presentation simultaneously, making it easy for teams to collaborate and make
revisions.
5. Compatibility: PowerPoint presentations can be saved in a variety of formats,
including PowerPoint, PDF, and video, making it easy to share and view on
different devices.
6. Other features include:

I. Customizable shapes and diagrams

II. Text formatting tools
III. Charts and tables
IV. Audio and video insertion
V. Note and outline view
VI. Time-saving tools like paste and undo.
POWER POINT ON
“INTRODUCTION OF NETWORK
TOPOLOGY”