Q1. Write short notes on the following.

[Link] applications in business

Information Technology is used in many areas to make work easier and
faster.
Education: Using computers and the internet for learning and teaching.
Healthcare: Managing patient records and using medical devices.
Banking: Online transactions, ATMs, and digital payments.
Communication: Emails, video calls, and social media.
Business: Managing sales, inventory, and customer data.
Entertainment: Streaming videos, online games, and music apps.

Government: Managing records, e-governance services, and public information

systems.

Transportation: Online ticket booking, GPS tracking, and traffic control systems.

Retail: Online shopping, billing systems, and inventory management.

Manufacturing: Automated production lines and quality control.

Research: Data analysis, simulations, and sharing research information globally.

Agriculture: Weather forecasting, soil analysis, and market price information.

b. Draw Block Diagram of Computer.

c. features of MS-Word
some features of Microsoft Word:
1. User-Friendly Interface
Easy-to-navigate ribbon and toolbar with various options for formatting
and editing.
2. Text Formatting
Change fonts, sizes, colors, styles (bold, italic, underline), and paragraph
alignment.
3. Templates
pre-designed templates for resumes, letters, reports, flyers, and more.
4. Spell Check and Grammar Check
Automatic spelling and grammar corrections with suggestions.
5. Tables and Charts
Insert and customize tables, charts, and graphs to organize data visually.
6. Images and Graphics
Add pictures, shapes, icons, SmartArt, and other graphic elements.
7. Headers and Footers
Insert page numbers, date/time, and custom text in headers and footers.
8. Saving and Exporting
Save files in various formats including DOCX, PDF, and plain text.
9. Mail Merge
Create personalized letters, labels, or emails by merging data from
spreadsheets or databases.
[Link] Layout Options
Control margins, orientation (portrait/landscape), columns, and breaks.

d. Types of charts in excel

Column Chart: Displays data as vertical bars. Good for comparing values across
categories.
Bar Chart: Similar to column charts but with horizontal bars. Useful when
category names are long.
Line Chart: Shows trends over time or ordered categories by connecting data
points with lines.
Pie Chart: Displays data as slices of a circle, showing proportions of a whole.
Doughnut Chart: Like a pie chart but with a hole in the middle, allowing multiple
data series.
Area Chart: Similar to line charts but with the area under the line filled. Good for
showing volume over time.
Scatter (XY) Chart: Plots data points based on two variables to show relationships
or correlations.
Bubble Chart: Like a scatter chart but with bubble sizes representing a third
variable.
Stock Chart: Used mainly for financial data to show stock price changes (open,
high, low, close).
Surface Chart: Shows data across two dimensions, like a 3D landscape.
Radar Chart: Displays multivariate data in a circular layout with axes starting
from the centre.
Combo Chart: Combines two or more chart types (e.g., column + line) in a single
chart for comparison.
e. set background to slides
To set the background of slides in PowerPoint, here’s a quick guide:
1. Open your PowerPoint presentation.
2. Go to the slide where you want to change the background (or select
multiple slides).
3. Click on the "Design" tab in the ribbon.
4. Click on "Format Background" on the far right.
5. Choose the background type:
o Solid fill: Pick a color
o Gradient fill: Choose gradient colors and style
o Picture or texture fill: Insert an image or texture
o Pattern fill: Choose from preset patterns
6. Click "Apply" to change the selected slide(s), or "Apply to All" to change
every slide in the presentation.
Q2. Explain Micro Computer and Mainframe Computer.
A PC can be defined as a small, relatively inexpensive (low cost) computer
designed for an individual user. PCs are based on the microprocessor technology
that enables manufacturers to put an entire CPU on one chip. Businesses use
personal computers for word processing, accounting, desktop publishing, and for
running spreadsheet and database management applications. At home, the most
popular use for personal computers is playing games and surfing Internet.
Although personal computers are designed as single-user systems. Examples:
Desktop Laptop Smartphone Notebook Tablet
Features of Microcomputers:
Limited processing power: Microcomputers have limited processing power and
are generally not suitable for complex tasks.
Popular operating systems: Microcomputers typically run popular operating
systems such as Windows or macOS.
Mainframe Computer: Mainframe is very large in size and is an expensive
computer capable of supporting hundreds or even thousands of users
simultaneously. Mainframe executes many programs concurrently and supports
many simultaneous executions of programs. A data processing system employed
mainly in large organizations for various applications, including data processing,
process control, industry and consumer statistics, enterprise resource planning,
and financial transaction processing.
Features of Mainframe Computers
Mainframes have very high processing power to handle large amounts of data
quickly.
They offer huge storage capacity for storing vast records and information.
Designed to support many users at the same time without slowing down.
Known for their reliability and stability, running continuously without failure.
Q3. Write down the steps for opening MS-Word Screen with Diagram.
Steps for opening MS-Word:
1. First of all, start the system or computer from the main electric switch board &
after that switch on the power button from the CPU.
2. Press the window’s button from the keyboard which will be located at the
bottom left side second number key (windows key).
3. Then you will get a search box on the system.
4. Type in the search box as “Ms-Word”.
5. When you will click on Ms-Word, you will get a new opening screen of “Ms-
Word”.
Some of previous versions of Ms-Words are like Ms-Word 2007, Ms-Word 2010,
Ms-Word 2013, Ms-Word 2021 etc.
Following is the basic window which you get when you start word application.
Let us understand various important parts of this window.

Q4. How to Enter and Edit data into worksheet.

A worksheet in Excel is made up of rows and columns. The intersection of a row
and a column is called a cell. Each cell can hold data like text, numbers, dates, or
formulas.
1. Entering Data into a Worksheet
Step-by-Step Process:
1. Open Excel (or any spreadsheet program).
2. Click on a cell where you want to enter data.
For example, click on cell A1 (top-left cell).
3. Start typing your data.
You can enter text, numbers, dates, or formulas.
4. Press Enter to move to the cell below, or Tab to move to the next cell on the
right.
5. Repeat the process for other cells.
Types of Data You Can Enter:
  Text: Names, labels, titles (e.g., “Total Marks”)
 Numbers: 120, 500.75, etc.
 Dates & Time: 10/10/2025, 3:30 PM
 Formulas: =A1+B1, =SUM(A1:A5)
2. Editing Data in a Worksheet
Method 1: Direct Editing in the Cell
1. Double-click the cell you want to edit.
2. The cursor appears inside the cell.
3. Make changes to the content.
4. Press Enter to save changes.
Method 2: Editing from the Formula Bar
1. Click on the cell you want to edit.
2. Go to the Formula Bar (just above the worksheet).
3. Make your changes there.
4. Press Enter to apply the change.
3. Deleting Data
 To delete content from a cell:
o Click the cell and press Delete on your keyboard.
 To delete multiple cells:
o Select the range of cells and press Delete.

Q5. What does a slide transition do?

A slide transition is a visual effect that happens when you move from one slide to
the next during a PowerPoint presentation.
1. To Add Visual Appeal
Transitions make your presentation look more attractive and smoother.
Instead of jumping directly from one slide to another, the screen changes in a
visually engaging way.
2. To Show a Change in Topic or Section
You can use a special transition (like a fade or wipe) to signal that a new idea or
section is starting.
This helps the audience follow the flow of the presentation.
3. To Control the Pace of the Presentation
You can set slide transitions to happen automatically after a set time, or on click.
This helps in timing your presentation or maintaining a smooth slide show flow.
4. To Keep the Audience Engaged
When used correctly, transitions can hold the viewer’s interest and avoid a boring
or flat presentation.
Ex: Fade – the current slide fades into the next one.
Push – the next slide pushes the current one off the screen.
Wipe – the new slide wipes over the old one from one direction.
split – the slide splits into parts to reveal the next slide.