Nothing Special   »   [go: up one dir, main page]

Assignment

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 71

Q1. Define Computer and its block diagram.

A1- A computer is a programmable electronic device that accepts raw data as input and

processes it with a set of instructions (a program) to produce the result as output. It renders

output just after performing mathematical and logical operations and can save the output for

future use. It can process numerical as well as non-numerical calculations. The term

"computer" is derived from the Latin word "computare" which means to calculate.

A computer is designed to execute applications and provides a variety of solutions through

integrated hardware and software components. It works with the help of programs and

represents the decimal numbers through a string of binary digits. It also has a memory that

stores the data, programs, and result of processing. The components of a computer such as

machinery that includes wires, transistors, circuits, hard disk are called hardware. Whereas,

the programs and data are called software.

It is believed that the Analytical Engine was the first computer which was invented by

Charles Babbage in 1837. It used punch cards as read-only memory. Charles Babbage is also

known as the father of the computer.

1
Block Diagram of Computer.

2
Q2- Explain the term software and its categories.

A2- In a computer system, the software is basically a set of instructions or commands that

tell a computer what to do. In other words, the software is a computer program that

provides a set of instructions to execute a user’s commands and tell the computer what to

do. For example like MS-Word, MS-Excel, PowerPoint, etc.

Types of Software

It is a collection of data that is given to the computer to complete a particular task. The

chart below describes the types of software:

Above is the diagram of types of software. Now we will briefly describe each type and its

subtypes:

3
1. System Software

 Operating System

 Language Processor

 Device Driver

2. Application Software

 General Purpose Software

 Customize Software

 Utility Software

System Software

System software is software that directly operates the computer hardware and provides the

basic functionality to the users as well as to the other software to operate smoothly. Or in

other words, system software basically controls a computer’s internal functioning and also

controls hardware devices such as monitors, printers, and storage devices, etc. It is like an

interface between hardware and user applications, it helps them to communicate with each

other because hardware understands machine language(i.e. 1 or 0) whereas user

applications are work in human-readable languages like English, Hindi, German, etc. so

system software converts the human-readable language into machine language and vice

versa.

Types of System Software

It has two subtypes which are:

1. Operating System: It is the main program of a computer system. When the

computer system ON it is the first software that loads into the computer’s memory.

Basically, it manages all the resources such as computer memory, CPU, printer, hard

4
disk, etc., and provides an interface to the user, which helps the user to interact with the

computer system. It also provides various services to other computer software.

Examples of operating systems are Linux, Apple macOS, Microsoft Windows, etc.

2. Language Processor: As we know that system software converts the human-

readable language into a machine language and vice versa. So, the conversion is done

by the language processor. It converts programs written in high-level programming

languages like Java, C, C++, Python, etc(known as source code), into sets of

instructions that are easily readable by machines(known as object code or machine

code).

3. Device Driver: A device driver is a program or software that controls a device and

helps that device to perform its functions. Every device like a printer, mouse, modem,

etc. needs a driver to connect with the computer system eternally. So, when you connect

a new device with your computer system, first you need to install the driver of that

device so that your operating system knows how to control or manage that device.

Features of System Software

Let us discuss some of the features of System Software:

 System Software is closer to the computer system.

 System Software is written in a low-level language in general.

 System software is difficult to design and understand.

 System software is fast in speed(working speed).

 System software is less interactive for the users in comparison to application software.

Application Software

Software that performs special functions or provides functions that are much more than the

basic operation of the computer is known as application software . Or in other words,

5
application software is designed to perform a specific task for end-users. It is a product or a

program that is designed only to fulfill end-users’ requirements. It includes word

processors, spreadsheets, database management, inventory, payroll programs, etc.

Types of Application Software

There are different types of application software and those are:

1. General Purpose Software : This type of application software is used for a variety

of tasks and it is not limited to performing a specific task only. For example, MS-Word,

MS-Excel, PowerPoint, etc.

2. Customized Software : This type of application software is used or designed to

perform specific tasks or functions or designed for specific organizations. For

example, railway reservation system , airline reservation system, invoice management

system, etc.

3. Utility Software: This type of application software is used to support the computer

infrastructure. It is designed to analyze, configure, optimize and maintains the system,

and take care of its requirements as well. For example, antivirus, disk fragmenter,

memory tester, disk repair, disk cleaners, registry cleaners, disk space analyzer, etc.

Features of Application Software

Let us discuss some of the features of Application Software:

 An important feature of application software is it performs more specialized tasks like

word processing, spreadsheets, email, etc.

 Mostly, the size of the software is big, so it requires more storage space.

 Application software is more interactive for the users, so it is easy to use and design.

 The application software is easy to design and understand.

 Application software is written in a high-level language in general.

6
Q3- Write short notes regarding input and output devices.

A3- Input Devices

Input devices are the devices that are used to send signals to the computer for performing

tasks. The receiver at the end is the CPU (Central Processing Unit), which works to send

signals to the output devices. Some of the classifications of Input devices are:

 Keyboard Devices

 Pointing Devices

 Composite Devices

 Game Controller

 Visual Devices

 Audio Input Devices

OUTPUT DEVICES-

An output device is a computer device that displays the result of the inserted input data after

getting processed from the CPU. CPU of a computer converts received information from

machine language to a human-friendly language and then sends these signals to output

devices to execute the tasks as per entered data. The output devices display the visual

contents on the monitor screen while sound contents are delivered to the speaker connected to

a computer. Output devices include monitors, printers, speakers, headphones, projectors, GPS

devices, optical mark readers, and braille readers.

7
Q4- Explain the concepts of some storage devices.

A4- A storage device is a piece of hardware that can be used to store digital information and

programs, such as photographs, videos, audio, and other types of data. The hard disk is just

one example of this crucial part of a computer.

Types of Storage Devices

Magnetic Storage Units

These days, magnetic storage devices are the ones that are used the most. These are readily

available and reasonably priced. Through the use of magnetised materials, a significant

amount of data may be stored in them.

 Floppy Disk: Floppy disk, also referred to as a floppy diskette, is a square-shaped,

magnetically-contained detachable storage device. It spins while storing data when

inserted into the computer device's disk reader. Recently, CDs, DVDs, and USB

drives have taken the role of these floppy disks.

8
Floppy Disk

 Hard Drive: The disk controller on the motherboard is directly connected to the

hard drive, which serves as the main storage device. Since it is necessary to install any

new software or applications on the device, it is a crucial storage space. Hard drives

9
can be used to save software applications, photos, videos, and other types of media,

and they are now widely available and have storage space measured in terabytes.

10
Hard Drive

Optical Storage Devices

These gadgets detected and stored data using lasers and lights. They can hold more data and

are less expensive than USB drives. Several frequently used optical storage devices are

covered below.

 CD-ROM: An external device known as a CD-ROM, or Compact disk - Read-Only

Memory, may store and read the information in the form of audio or software.

11
CD-ROM.

 Blu-Ray disc: High-definition video can be viewed, and a lot of data can be stored

on Blu-Ray optical discs. The successor to DVD is Blu-Ray. A single-layer disc can

hold up to 25 GB of data, and a dual-layer disc can hold up to 50 GB of data.

12
Blu-Ray disk

13
Q5- Write the differences between compiler, assembler and interpreter.

A5-

COMPILER

A compiler is a computer program that changes source code written in programming language

into machine language and executes it. Ordinarily, Compilers can take time since they ought to

decipher high-level language to lower-level machine language at once and after that spare the

executable question code to the memory. Moreover in a compiler, after changing all the code

at once a mistake report for the total program is generated. Compilers can be classified based

on what work it performs or how it has been developed. Compilers can be classified as single-

pass, load-and-go, investigating, multi-pass and optimization. Compilation is performed in

stages: lexical analyzer, syntax analyzer, semantic analyzer, intermediate code generator, code

optimizer, symbol table and error handle.

14
ASSEMBLER

An assembler is a program that takes basic computer instructions and changes them into a

design of bits that the computer processor can utilize to perform its fundamental operations.

Moreover, language utilized to program the constructing agent is referred to as assembly

language. Assembler changes over source code to a protest code first at that point it changes

over the protest code to machine language with the assistance of the linker programs.

INTERPRETER

In computer science, an interpreter is a computer program that specifically executes,

informational composed in a programming or scripting language, without compiling them into

a machine language program.

An Interpreter is a program that takes input as a source program, together with information for

the program, and interprets the source program instruction by instruction.

Q6- What is operating system and explain its types.

A6- An Operating System performs all the basic tasks like managing files, processes, and

memory. Thus operating system acts as the manager of all the resources, i.e. resource

manager. Thus, the operating system becomes an interface between the user and the

machine. It is one of the most required software that is present in the device.

15
Operating System is a type of software that works as an interface between the system

program and the hardware. There are several types of Operating Systems in which many of

which are mentioned below.

Types of Operating Systems

There are several types of Operating Systems which are mentioned below.

 Batch Operating System

 Multi-Programming System

 Multi-Processing System

 Multi-Tasking Operating System

 Time-Sharing Operating System

 Distributed Operating System

 Network Operating System

 Real-Time Operating System

1. Batch Operating System

This type of operating system does not interact with the computer directly. There is an

operator which takes similar jobs having the same requirement and groups them into

batches. It is the responsibility of the operator to sort jobs with similar needs.

16
Batch Operating System

2. Multi-Programming Operating System

Multiprogramming Operating Systems can be simply illustrated as more than one program

is present in the main memory and any one of them can be kept in execution. This is

basically used for better execution of resources.

17
3. Multi-Processing Operating System

Multi-Processing Operating System is a type of Operating System in which more than one

CPU is used for the execution of resources. It betters the throughput of the System.

18
4. Multi-Tasking Operating System

Multitasking Operating System is simply a multiprogramming Operating System with

having facility of a Round-Robin Scheduling Algorithm. It can run multiple programs

simultaneously.

There are two types of Multi-Tasking Systems which are listed below.

 Preemptive Multi-Tasking

 Cooperative Multi-Tasking

19
5. Time-Sharing Operating Systems

Each task is given some time to execute so that all the tasks work smoothly. Each user gets

the time of the CPU as they use a single system. These systems are also known as

Multitasking Systems. The task can be from a single user or different users also. The time

that each task gets to execute is called quantum. After this time interval is over OS switches

over to the next task.

20
6. Distributed Operating System

These types of operating system is a recent advancement in the world of computer

technology and are being widely accepted all over the world and, that too, at a great pace.

Various autonomous interconnected computers communicate with each other using a shared

communication network. Independent systems possess their own memory unit and CPU.

These are referred to as loosely coupled systems or distributed systems . These systems’

processors differ in size and function. The major benefit of working with these types of the

operating system is that it is always possible that one user can access the files or software

which are not actually present on his system but some other system connected within this

network i.e., remote access is enabled within the devices connected in that network.

21
7. Network Operating System

These systems run on a server and provide the capability to manage data, users, groups,

security, applications, and other networking functions. These types of operating systems

allow shared access to files, printers, security, applications, and other networking functions

over a small private network. One more important aspect of Network Operating Systems is

that all the users are well aware of the underlying configuration, of all other users within

the network, their individual connections, etc. and that’s why these computers are popularly

known as tightly coupled systems .

22
8. Real-Time Operating System

These types of OSs serve real-time systems. The time interval required to process and

respond to inputs is very small. This time interval is called response time.

Real-time systems are used when there are time requirements that are very strict like

missile systems, air traffic control systems, robots, etc.

23
Q7- Explain the concept of computer network and its types.

A7- Computer Network Types

A computer network is a group of computers linked to each other that enables the computer

to communicate with another computer and share their resources, data, and applications.

A computer network can be categorized by their size. A computer network is mainly of four

types:

24
LAN (Local Area Network)

o Local Area Network is a group of computers connected to each other in a small area

such as building, office.

o LAN is used for connecting two or more personal computers through a

communication medium such as twisted pair, coaxial cable, etc.

o It is less costly as it is built with inexpensive hardware such as hubs, network

adapters, and ethernet cables.

o The data is transferred at an extremely faster rate in Local Area Network.

o Local Area Network provides higher security.

25
PAN (Personal Area Network)

o Personal Area Network is a network arranged within an individual person, typically

within a range of 10 meters.

o Personal Area Network is used for connecting the computer devices of personal use is

known as Personal Area Network.

o Thomas Zimmerman was the first research scientist to bring the idea of the Personal

Area Network.

o Personal Area Network covers an area of 30 feet.

o Personal computer devices that are used to develop the personal area network are the

laptop, mobile phones, media player and play stations.

26
PAN

MAN (Metropolitan Area Network)

o A metropolitan area network is a network that covers a larger geographic area by

interconnecting a different LAN to form a larger network.

o Government agencies use MAN to connect to the citizens and private industries.

o In MAN, various LANs are connected to each other through a telephone exchange

line.

27
o The most widely used protocols in MAN are RS-232, Frame Relay, ATM, ISDN, OC-

3, ADSL, etc.

o It has a higher range than Local Area Network (LAN).

WAN (Wide Area Network)

o A Wide Area Network is a network that extends over a large geographical area such

as states or countries.

28
o A Wide Area Network is quite bigger network than the LAN.

o A Wide Area Network is not limited to a single location, but it spans over a large

geographical area through a telephone line, fibre optic cable or satellite links.

o The internet is one of the biggest WAN in the world.

o A Wide Area Network is widely used in the field of Business, government, and

education.

29
Q8- Why multimedia is important (advantages) in nowadays.

A8- Advantages of Multimedia

1. Improved Learning and Retention

One of the main advantages of multimedia is its ability to improve learning and retention.

Research has shown that multimedia presentations are more effective at engaging students

and helping them to retain information than traditional methods such as lectures or textbooks.

Multimedia helps in learning because multimedia presentations use a combination of

different media, which can appeal to different learning styles and make the material more

interesting and engaging.

2. Enhanced Communication

Multimedia can also be used to enhance communication and make it more effective. It allows

people to convey complex ideas and concepts through various media, such as text, audio, and

video. Multimedia can also make it easier for people to understand the message and can help

to engage the audience more effectively. Multimedia can be an effective tool for

communication, as it allows for the integration of various forms of media, such as text, audio,

and video. Multimedia can help make complex concepts easier to understand and add a visual

element to a presentation, which can be more engaging for the audience.

3. Increased Accessibility

30
Multimedia can also increase accessibility, particularly for people with disabilities. For

example, multimedia presentations can be made more accessible for people with hearing or

vision impairments through closed captions, audio descriptions, and other features.

4. Increased Interactivity

Multimedia can also increase interactivity and engage the audience more effectively. For

example, multimedia presentations can include interactive elements such as polls, quizzes,

and games, making the material more engaging and encouraging people to participate.

5. Improved learning outcomes

Multimedia has improved learning outcomes, especially compared to traditional instruction

methods. It allows learners to engage with content more interactively and engagingly.

Multimedia also allows learners to learn at their own pace, which can be especially beneficial

for visual or auditory learners.

6. Increased efficiency

Multimedia can save time and improve efficiency in a variety of contexts. For example, in

business, multimedia presentations can be used to communicate complex ideas or products to

clients more efficiently. In education, multimedia can be used to deliver course materials,

allowing students to access information at their own pace and on their own time.

7. Greater Flexibility

31
Multimedia offers greater flexibility than traditional media, as it can be accessed on various

devices and platforms. The flexibility means that people can access multimedia content at a

convenient time and place for them, which can be particularly useful for those who are busy

or have limited time.

8. Greater impact

Multimedia can impact the audience more, as it can appeal to multiple senses and engage the

viewer in a more immersive way. Multimedia can be especially useful in marketing and

advertising, as it can help to create a more memorable and effective message.

Q9- How can we change the name of folder with the help of mouse and explain

its shortcut key.

A9- Rename files or folders

1. Click File Explorer icon.

2. Go to the location where stores your file or folder.

3. Right click the name of the file or folder you wish to rename.

4. Click Rename (on the menu that opens up).

32
5. Type a new name for the file and press Enter.

Q10- Explain the use of control panel in computer system.

A10- The control panel acts as the initial interface to your server. You can use the control

panel to manage and process key system functions. You can control the power system or

perform initial load program to determine the load on your server. Control panel is also the

resource to read status or error codes of the system. It gives an in-depth analysis of problems

and helps determine processor activity. If you want to troubleshoot problems associated with

your server system, your control panel will be able to help you do it efficiently. You can do

data backup, add or remove programs and customize settings according to your requirements.

Q11- How can we use finding and replace command in MS word file?

A11- If you’re working with a lot of text and need to search and replace a word or a phrase,

use Find and Replace in your Word app.

1. Select Replace or press Ctrl + H.

33
2. In the Find what box, type the text you want to search for.

3. Select Find Next to see where the text appears in your file.

4. In the Replace with box, type the text you want.

5. Select Replace to change the text or select Replace All to change all instances of this

text in your file.

Q12- How can we use bullet and numbering in MS word file?

A12-

o Select the text you want to convert to bulleted or numbered list

o Select the Home tab

o In Paragraph group click the Bullets or Numbering command

o It displays Bullets or Numbering menu

o With a left click select the desired Bullet or Numbering style

o To increase the list place the cursor at the end of list and press Enter key

34
Q13- How can we create a table and also perform formatting in MS word file?

A13- The basic steps for creating a standard table in Microsoft Word (2013) are:

1. Open a blank Word document

2. In the top ribbon, press Insert

3. Click on the Table button

35
4. Either use the diagram to select the number of columns and rows you need, or click Insert

Table and a dialog box will appear where you can specify the number of columns and rows.

5. The blank table will now appear on the page. Alter it as necessary. Standard features

like bold, italics, and underline are still available! These items may be helpful for creating

headings or calling out certain items in the table.

6. Follow these instructions for ensuring your table meets APA formatting guidelines.

36
Q14- How can we use following concepts of Page Layout Menu of MS Word:

a. Orientation.

b. Columns

c. Explorer watermark

d. Page Border

A14-

A) Page orientation

Word offers two page orientation options: landscape and portrait. Compare our example

below to see how orientation can affect the appearance and spacing of text and images.

 Landscape means the page is oriented horizontally.

37
 Portrait means the page is oriented vertically.

38
To change page orientation:

1. Select the Layout tab.

2. Click the Orientation command in the Page Setup group.

39
3. A drop-down menu will appear. Click either Portrait or Landscape to

change the page orientation.

4. The page orientation of the document will be changed.

B)-

1. Select the text you want to format.

40
2. Select the Layout tab, then click the Columns command. A drop-down menu

will appear.

3. Select the number of columns you want to create.

41
4. The text will format into columns.

Your column choices aren't limited to the drop-down menu that appears. Select More

Columns at the bottom of the menu to access the Columns dialog box. Click the arrows next

to Number of columns: to adjust the number of columns.

42
C)- Steps to Add Watermark in our Document

Step 1: On the navigation menu click on the Design option.

Step 2: On the right side of the navigation menu click on the watermark option as shown:

43
Step 3: A menu will open where you can select different types of watermarks, or also you

can create your own watermark.

44
Step 4: There the three sections in watermark:

Confidential Section

45
Disclaimers Section

46
Urgent Section

47
Step 5: Select the watermark of your choice or requirement according to your document.

Some different types of watermark are:

48
1. CONFIDENTIAL

2. DO NOT COPY

3. DRAFT

4. ASAP

5. URGENT

6. SAMPLE

Finally, the watermark is set in our document as shown

49
D)- Steps to Apply Page Border

Step 1: On the navigation menu click on the Design option.

Step 2: On the right side of the menu click on the Page Border option.

Step 3: A Border and Shading dialog box will open.

50
Step 4: Then Click on the Page Border option.

51
There are many options to choose page border style. Select option according to you.

Step 5: Select on box option as shown:

52
You can also choose a different border style, color by simply clicking on the style option

and select your style as shown:

53
Step 6: Click on Apply to option as shown here:

There are 4 options:

1. Whole Document – By selecting this option page border will apply to all the pages of

your document.

54
2. This section – Page border will apply only on one page that is the current page of the

document.

3. This section – first page only – Page border will apply only in the first page, remaining

page remains without border

4. This section – all except first page – Page border will apply in all the pages except the

front or first page of your document.

Step 7: Then click on OK option.

55
Finally, page border will apply to your documents.

56
57
Q15- Explain the use of MS Excel in current industry.

A15- MS Excel or Microsoft Excel is an essential software program of Microsoft Office

Suite developed by Microsoft. It is one of the most powerful spreadsheet software that uses

rows and columns to organize the data.

Excel seems like an essential number-crunching software primarily used for managing

household expenses or generating some basic reports. However, excel is more than just a

simple reporting program. Excel is powerful software and can help perform a wide range of

jobs for personal or business purposes. Therefore, there are plenty of uses of MS excel, and

the list goes on.

In this article, we are discussing some of the major uses of Microsoft Excel that will help us

understand the potential of this powerful software and how different people or organizations

are using it for their needs. They are as follows:

o Data Entry and Storage

o Performing Calculations

o Data Analysis and Interpretation

o Reporting and Visualizations

o Accounting and Budgeting

o Collection and Verification of Business Data

o Calendars and Schedules

o Administrative and Managerial Duties

o Forecasting

o Automating Repetitive Tasks

58
Q16- How can we insert chart or graph in MS Excel?

A16- Inserting charts into Excel is an easy-to-use process. For instance, we take the

following sheet as an example and insert a chart for it.

59
To create a chart for the above data in Excel, we need to follow the steps mentioned below:

o First, we must select all the cells we want to record in a chart, including the

corresponding row labels and column titles. The selected cells are used as source data

for the chart to be created. In our example, we need to select cells from cell A1 to cell

G6.

60
o Next, we need to navigate to the Insert tab and select the desired chart to insert from

the Charts group.

If there are more charts under the selected chart type, Excel displays all the available

options. For example, when we select Insert Column or Bar Chart, we get the

following chart options:

61
In the above image, we only need to click on the desired chart type. As soon as we

click on the desired chart type, the corresponding chart is immediately inserted into

the active datasheet.

62
Q17- Explain the use of filter in MS Excel with proper examples.

A17- Steps to Follow:

Step 1: In order for filtering to work correctly, your worksheet should include a header

row, which is used to identify the name of each column.

63
Step 2: Select the Data tab, and then click the Filter command.

Step 3: A drop-down arrow will appear in the header cell for each column.

Step 4: Click the drop-down arrow for the column you want to filter. In our example, we

will filter column C to view only certain types of equipment.

Step 5: The Filter menu will appear.

Step 6: Uncheck the box next to Select All to quickly deselect all data.

64
Step 7: Check the boxes next to the data you want to filter, and then click OK. In this

example, we will check Laptop and Tablet to view only those types of equipment.

65
Step 8: The data will be filtered, temporarily hiding any content that doesn’t match the

criteria. In our example, only humanities stream are visible.

Filtering options can also be accessed from the Sort & Filter command on the Home tab.

66
Q18- Explain some operations in MS excel: SUM(),COUNT(),AVERAGE(),

MAX(),MIN(), SUMIF(),LOWER(), UPPER(),PROPER(),REPLACE().

A18-

SUM()-The SUM formula in Excel is one of the most fundamental formulas you can use

in a spreadsheet, allowing you to calculate the sum (or total) of two or more values. To use

the SUM formula, enter the values you want to add together in the following format:

=SUM(value 1, value 2,…..).

COUNT()-The COUNT function counts the number of cells that contain numbers, and

counts numbers within the list of arguments.

=Count(Value1, Value2, ...)

AVERAGE()-The Microsoft Excel MAX function returns the average value from the

numbers provided.

=Average(Number1, Number2, ...)

67
MAX()-The Microsoft Excel MAX function returns the largest value from the numbers

provided.

=Max(Number1, Number2, .....)

MIN()-The Microsoft Excel MAX function returns the smallest value from the numbers

provided.

=Min(Number1, Number2, ....)

SUMIF()-The SUMIF function is a worksheet function that adds all numbers in a range of

cells based on one criteria

=Sumif(Range, Criteria, Sum_Range)

LOWER()-The lower() function in excel converts the string of characters into the

lowercase. If the string of characters is already in lowercase, there will be no conversion. If

the string of characters is in uppercase (capital), it will be converted to lowercase.

UPPER()-The Excel UPPER function converts a text string to all uppercase letters.

Numbers, punctuation, and spaces are not affected.

PROPER()-The PROPER Function is categorized under Excel Text functions. PROPER

will capitalize the first letter in a text string and any other letters in text that follow any

character other than a letter.

In financial analysis, we often import data from external sources. The PROPER function will

help us convert text into the proper case, if required. We can use it to capitalize each word in

a given string. Using the function will not affect numbers and punctuations. It will convert all

other letters to lowercase.

68
REPLACE()-The REPLACE Function[ 1 ] is categorized under Excel TEXT functions. The

function will replace part of a text string, based on the number of characters you specify, with

a different text string.

In financial analysis, the REPLACE function can be useful if we wish to remove text from a

cell when the text is in a variable position.

Formula

=REPLACE(old_text, start_num, num_chars, new_text)

Q19- How can we insert audio, video and image in presentation file (ppt).

A19- 1. To insert a sound or video, go to the Insert Ribbon and click on the Video or Audio

icon and choose Video or Audio from File….

2. Navigate to the correct clip, and click the OK button.

69
3. Once audio is inserted, an audio button will appear, allowing sound to play when it is

clicked on.

Q20- What is the role of animation and transition in power point? Explain with

examples.

A20- Animations control how objects move onto, off of, and around your slides. Transitions

control how your presentation moves from one slide to the next.

You can animate the objects on your PowerPoint slides. PowerPoint provides four types of

animations: Entrance, Emphasis, Exit, and Motion Paths. An Entrance animation determines

the manner in which an object appears on a slide; for example, an object can move onto a

70
slide. An Emphasis animation does something to draw attention to an object; for example, the

object can become larger. An Exit animation determines the manner in which an object

leaves a slide.

Transitions determine how your presentations move from one slide to the next. For example,

a slide can move up onto the screen and replace the previous slide. PowerPoint provides

several transition methods. You can add sound to a transition and you can control its speed.

You can apply a transition to selected slides or to all of the slides in your presentation.

A transition can occur when the presenter clicks the mouse or after the amount of time you

specify.

71

You might also like