What is Microsoft Excel? Full Explain with Formulas - VS COMPUTER CLASSES (Part 2)

Excel Syntax

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign = typed in the cell, followed by your calculation.

Note: You claim the cell by selecting it and typing the equal sign (=)

Creating formulas, step by step

Select a cell

Type the equal sign (=)

Select a cell or type value

Enter an arithmetic operator

Select another cell or type value

Press enter

For example =1+1 is the formula to calculate 1+1=2

Note: The value of a cell is communicated by reference(value) for example A1(2)




Using Formulas with Cells

You can type values to cells and use them in your formulas.

Lets type some dummy values to get started. Double click the cells to type values into them. Go ahead and type:

• A1(309)
• A2(320)
• B1(39)
• B2(35)

Compare with the picture shown below:

Note: Type values by selecting a cell, claim it by entering the equal sign (=) and then type your value. For example =309.

Well done! You have successfully typed values to cells and now we can use them to create formulas.

Here is how to do it, step by step.

1. Select the cell C1
2. Type the equal sign (=)
3. Left click on A1, the cell that has the (309) value
4. Type the minus sign (-)
5. Left click on B2, the cell that has the (35) value
6. Hit enter

Tip: The formula can be typed directly without clicking the cells. The typed formula would be the same as the value in C1 (=A1-B2).

The result after hitting the enter button is C1(274). Did you make it?

Another Example

Let's try one more example, this time let's make the formula =A2-B1.

Here is how to do it, step by step.

1. Select the cell C2
2. Type the equal sign (=)
3. Left click A2, the cell that has the (320) value
4. Type the minus sign (-)
5. Left click B1, the cell that has the (39) value
6. Hit the enter button

You got the result C2(281), right? Way to go!

Note: You can make formulas with all four arithmetic operations, such as addition (+), subtraction (-), multiplication (*) and division (/).

Here are some examples:

• =2+4 gives you 6
• =4-2 gives you 2
• =2*4 gives you 8
• =2/4 gives you 0.5

Read More

What is Microsoft Excel? Full Explain with Formulas - VS COMPUTER CLASSES (Part 1)

What is Excel?

Excel is pronounced "Eks - sel"

It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS.

The first version was released in 1985 and has gone through several changes over the years. However, the main functionality mostly remains the same.

Excel is typically used for:

Analysis

Data entry

Data management

Accounting

Budgeting

Data analysis

Visuals and graphs

Programming

Financial modeling

And much, much more!

Why Use Excel?

It is the most popular spreadsheet program in the world

It is easy to learn and to get started.

The skill ceiling is high, which means that you can do more advanced things as you become better

It can be used with both work and in everyday life, such as to create a family budget

It has a huge community support

It is continuously supported by Microsoft

Templates and frameworks can be reused by yourself and others, lowering creation costs.

Get Started

It is not necessary to have any prior experience with spreadsheet programs or programming.

The Excel view has columns and rows, similar to a squared math exercise book.

Do not worry if the functionality looks overwhelming at first. You will get comfortable as you learn more in the chapters to come.

For now focus on the rows, columns, and the cells.

Ok. Let's make a function!

First, double click the cell A1, the one that is marked with the green rectangle in the picture.

Second, type =1+1.

Third, hit the enter button:

Congratulations! You have typed your first function, 1+1=2.

Overview

This chapter is about giving you an overview of Excel. Excel's structure is made of two pieces, the Ribbon and the Sheet.

Have a look at the picture below. The Ribbon is marked with a red rectangle and the Sheet is marked with a yellow rectangle:

The Ribbon explained

The Ribbon provides shortcuts to Excel commands. A command is an action that allows you to make something happen. This can for example be to: insert a table, change the font size, or to change the color of a cell.

The Ribbon may look crowded and hard to understand at first. Don't be scared, It will become easier to navigate and use as you learn more. Most of the time we tend to use the same functionalities over again.

The Ribbon is made up by the App launcher, Tabs, Groups and Commands. In this section we will explain the different parts of the Ribbon.

The Sheet explained

The Sheet is a set of rows and columns. It forms the same pattern as we have in math exercise books, the rectangle boxes formed by the pattern are called cells.

Values can be typed to cells.

Values can be both numbers and letters:

Multiple Sheets

You start with one Sheet by default when you create a new workbook. You can have many sheets in a workbook. New sheets can be added and removed. Sheets can be named to making it easier to work with data sets.

Are you up for the challenge? Let's create two new sheets and give them useful names.

First, click the plus icon, shown in the picture below, create two new sheets:

You can use the hotkey Shift + F11 to create new sheets. Try it!

Chapter Summary

The workbook has two main components: the Ribbon and the Sheet.

The Ribbon is used to navigate and access commands.

The Sheet is made up of columns and rows, which make cells.

Each cell has its unique reference. You can add new sheets to your workbook and name them.

In the next chapters you will learn more about the sheet, formulas, ranges and functions.

Read More

Shubman Gill Batting 200/Score : India Vs Newzealand

 Congratulations Shubman Gill

By VS COMPUTER CLASSES

Shubman Gill hits ODI double hundred: Here are 5 other Indian batsmen who have scored double ton.

On Wednesday, Shubman Gill scored his third ODI ton in his 19th match in the format to continue his phenomenal rise.He also completed 1000 ODI runs in record 19 innings.

Shubman Gill becomes the fifth Indian batsmen to hit a double hundred in ODIs. He also becomes the fastest Indian cricketer to score 1,000 ODI runs today. ​The 23-year old Shubman Gill scored 208 runs in 149 balls.

In his stroke-filled knock, he hit nine sixes and 19 fours in this innings. The right-hander batter overtook Virat Kohli and Shikhar Dhawan, who jointly held the previous record at 24 innings to become the fastest Indian and the joint-second fastest ever to 1,000 runs mark in ODIs. He equalled Pakistan opener Iman-ul-Haq for breaching the 1000-run mark in 19 innings while missing out on another Pakistan opener Fakhar Zaman's record of fastest to 1000 ODI runs in 18 innings.

"It's awesome to do the job for the team with the ball. If you bowl in the right areas, there's a little bit of hold and a little bit of extra-bounce, just need to build enough partnerships here to put the pressure on India."

In Short

1. Gill hit 208 runs off 149 deliveries in the first ODI
2. The 23-year-old said he was eager to get out to the middle
3. Gill said that he is feeling a sense of satisfaction after his knock

We All Pleasure for your Fantastic Inning.

Read More

Important 100 Question and Answer of Computer - VS COMPUTER CLASSES

TOP 100 Question & Answer

Que1:What is the full of Computer?

Ans:

C:Common

O:Operating

M:Maching

P:Particular

U:User

T:Transfer

E:Emiting

R:Research

Que2:What is Computer?

Ans: Computer is an Electronic Device which work very fast and give us Accurate result.

The father of Computer is Charles Babbage.

Que3: How many Devices in Computer?

Ans: There are many Devices in Computer but there are mast Computer.

Ex:

1. INPUT DEVICE

2.OUTPUT DEVICE

3.PROCESSING DEVICE

4.STORAGE DEVICE

Que4:What is an Input Device?

Ans:Input Device are used to inter the data into the Computer.

Exe: Keyboard, Mouse, Scanner, Light Pan, Joystick.

Que5: What is an Output Device?

Ans: Output Device are those Device which gives as the result as form of display as sound.

Exe: Monitor, Printer, Speaker, Projector, Plotter.

Que6: What is Processing Device?

Ans: Processing Device are those which is used to process the device of Computer.

Exe: C P U, Motherboard.

Que7: What is Storage Device?

Ans: Storage Device is used to store data into the Computer.

Exe: Hard Disk, Pen Drive, CD, DVD, BRD, floppy disk, memory card.

Que8: How many generations in Computer and uses?

Ans: There are 5 gen in Computer.

(1)First Generation Computers : Vacuum Tubes (1940 - 1956)

(2). Second Generation Computers : Transistor (1956 - 1964)

(3). Third Generation Computers : Integrated Circuits (1964 - 1971)

(4). Fourth Generation Computers : Micro processer (1971 - Present)

(5). Fifth Generation Computers : Artificial Intelligence (Present and Beyond)

Que10: How to refresh a Computer?

Ans: 

(1). Right click on desktop

(2). Click on refresh

Qua11: How to make a Folder?

Ans: 

(1). Right click mouse

(2). Click on New

(3). Click on Folder

Que12: How to Rename a Folder?

Ans: 

(1). Right click on Folder

(2). Click on Rename

(3). Type name

Que13: How delete a Folder?

Ans:

(1). Right click on folder

(2). Click on Delete

Que14: How to set Desktop Background?

Ans:

(1). Right click on Desktop 

(2). Click on Personalize

(3). Click on background/ Desktop Background

(4). Click on Picture which you want to select

Que15: How to make a folder with shortcut key?

Ans: Ctrl + Shift + N

Que16: How to rename a folder with shortcut key?

Ans: Press f2 button

Que17: How to delete folder with shortcut key?

Ans: Press the Delete Button

Que18: How to Recover a folder if deleted?

Ans: 

(1). Right click Recycle Been

(2). Click open

(3). Double click on folder

(4). Restore

Que19: How to delete folder permanently?

Ans: Shift + Del - Click ok

Que20: How to make a folder by Command?

Ans: Click on search bar - type CMD - click on command prompt type CD Desktop - MD folder name.

Que21: How to delete multiple folder?

Ans: Click on left mouse button - select the folder area - then press delete button.

Que22: How to Delete folder by Command?

Ans: Rd space folder name

Que23: How to increase font size in Notepad ?

Ans: 

(1). Select the text

(2). Click on format 

(3). Click on font

(4). Select the size

(5). Click ok

Que24: How to arrange all files and folder in proper manner?

Ans: 

(1). Right click on mouse

(2). Click on View

(3). Click on auto Arrange

Que25: How to Delete a file?

Ans:

(1). Right click on file

(2). Click on Delete

Que26: How to save a text Document?

Ans: 

(1). Click on file 

(2). Click on Save 

(3). Choose the path

(4). Write the name of file

(5). Click on save

Que27: How to copy file one place to another?

Ans:

(1). Right click on file

(2). Click on copy

(3). Click the path

(4). Right click on blank space

(5). Click on paste

Que28: How to Move file from one place to another?

Ans: 

(1). Right click on the file 

(2). Click on cut

(3). Choose the path

(4). Right click on blank space

(5). Click on paste

Que29: What is the shortcut key to copy a file or Folder?

Ans: Ctrl + C then Ctrl + V

Que30:What Is the short cut key to move a file or Folder?

Ans: Ctrl + X then Ctrl + V

Que31:What Is the short cut key to paste a file or Folder?

Ans: Ctrl + V

Que32: Go to the next line?

Ans: Press Enter

Que33: How to copy a text?

Ans: 

(1). Select the word

(2). Ctrl + C

(3). Ctrl + V

Que34: How to cut a text?

Ans: 

(1). Select the word

(2). Ctrl + X

(3). Ctrl + V

Que35: How to increase font size in Notepad?

Ans:

(1). Select the text

(2). Click on format

(3). Click on font

(4). Select the size

(5). Click ok

Que36: How to arrange all files and folder in proper manner?

Ans:

(1). Right click on mouse

(2). Click on View

(3). Click on auto arrange

Que37: How to find taskbar?

Ans: The bottom of the system is called Taskbar.

Que38: How to find drives?

Ans:

(1). Click on My Computer/This P C

(2). You will get all the Drives

Que39: Shortcut key to go Drives?

Ans: Win + E

Que40: How to go folder files or any function via Shortcut if all are open?

Ans: Alt + Tab

Que41: How to Select all via Shortcut key?

Ans: Ctrl + A

Que42: How to save file via Shortcut key?

Ans: Ctrl + S

Que43: How to check Folder data?

Ans: 

(1). Rite click on folder

(2). Click on Properties

Que44: How can Check How many files or subfolder in Folder?

Ans:  

(1). Right click on Folder

(2). Click on Properties

(3). Click on Contain

Que45: How can i Hide my folder?

Ans:

(1). Right click on folder

(2). Click on Properties

(3). Click on Hidden

(4). Click on 2nd option

Que46: How can i Change Folder icon?

Ans:

(1). Right click on Folder

(2). Click on Properties

(3). Click on Customize

(4). Click on Change Icon

(5). Select icon

(6). Click apply and then ok

Que47: How to select via shortcut key?

Ans: Shift + Arrow

Que48: How to type Capital letter only?

Ans: CAPS ON then type.

Que49: How to type Capital latter only?

Ans: Shift + Letter.

Que50: How to go Beginning of letter?

Ans: Press Home Button.

Que51: How to go ending of letter?

Ans: Press end Button.

Que52: Go to the next line?

Ans: Press Enter.

Que53: How to undo word or letter?

Ans: Ctrl + Z.

Que54: How unhide file and folder?

Ans:

(1). Press Wine + R

(2). Type Control

(3). Click on File explorer

(4). Click on View

(5). Click Style Hidden File and Folder

(6). Click on apply and ok

Que55: How to hidden file and folder remove from Hide Properly?

Ans:

(1). Right Click on Folder

(2). Click on Properties

(3). Click on Hidden

(4). Click on apply and ok

Que56: How to Change Font Style in Notepad?

Ans:

(1). Click on Format

(2). Click on Font

(3). Select Style which you want to apply

(4). Click on ok

Que57: How to see my folder and file with different view?

Ans:

(1). Right click on blank space

(2). Click on View

(3). Select the Views

Exe: Extra large, Large, Medium, List, Small icon.

Que58: What is tile?

Ans: Tile is an icon which show their details with name.

Que59: How to check my updated Folder or File?

Ans:

(1). Right click on Blank space

(2). Click on Short By

(3). Select the type details which you want and what details you want.

Que60: How to arrange data with name in Ascending Order or Descending Order?

Ans: 

(1). Right click on Blank Space

(2). Click on Sort By

(3). Select the Ascending Order or Descending Order. 

Que61: How to change desktop Resolution?

Ans: 

(1). Right click on Desktop

(2). Click on display setting

(3). Click on Display Resolution

(4). Select the Resolution which you want to apply.   

Que62: How to Change Desktop Layout?

Ans: Ctrl + Alt + Arrow.

Que63: How to set Name for User Account?

Ans: 

(1). Win + R

(2). Type Control 

(3). Go to the use Account

(4). Click on Change your Account name

(5). Type the Name Which you want

Que64P: How to Set Profile Pic for User Account?

Ans: 

(1). Win + R

(2). Type Control

(3). Go to the user Account

(4). Click on Make Changes to my Account

(5). Select the pic from Browse 

(6). Select the Picture

Que65: How to Set Password for User Account?

Ans: 

(1). Win + R

(2). Type Control 

(3). Go to the user Account

(4). Click on manage another Account

(5). Click on Account 

(6). Click on Change the password

(7). They your Current password then new password.

Que66: How to Make a file with CMD?

Ans:

(1). Win + R

(2). CMD

(3). CD Desktop

(4). Copy Con File name txt

(5) . Enter the Words which you want to write

(6). Ctrl + Z for save the file

(7). Exit

Que67: How to del file with CMD?

Ans: Del File name .

Que68: How to del blank folder with CMD?

Ans: RD folder name .

Que69: How to make a subfolder in folder via Command?

Ans:

(1). Win + R

(2). Type CMD

(3). CD Desktop

(4). MD folder name\ folder name

(5). Then enter

Que70: How to clear CMD screen?

Ans:

(1). Win + R

(2). Type CMD

(3). Whatever the matter you wrote of multiple time

(4). Just type CLS to Clear the Screen

Que71: How to get my Previous Command in CMD Prompt?

Ans:

(1). Win + R

(2). Type CMD

(3). Whatever the matter you wrote of multiple time

(4). Find to your previous command though Arrow Button Just use arrow button up and down to get your previous command.                                                                                              

Que72: How to open Microsoft Word Office?

Ans: 

(1). Right click on Mouse

(2). Click on new

(3). Click on Microsoft Word

(4). Just give Name of the file

(5). Open the file

Que73: What is the extension of MS Word file?

Ans: .Doc or .Docx

Que74: What is the extension of Notepad file?

Ans: .TXT

Que75: How to Increase a Font with Short Cut Key?

Ans: Ctrl + ]

Que76: How to Change Style of text?

Ans: 

(1). Go to the home tab

(2). Just click on Style tab

(3). Select the Style

Que77: How to text Bold in MS office?

Ans:

(1). Select the text

(2). Click on B or ctrl + B

Que78: How to underline text in MS office?

Ans:

(1). Select the text

(2). Click on U or ctrl + U

Que79: How to text blend in MS office?

Ans:

(1). Select the text

(2). Click on I or ctrl + I

Que80: How to Align the text in MS office?

Ans:

(1). First go the text 

(2). Then go to the paragraph

(3). Click and Select the align where you to want to align

Que81: How to replace word from sentence?

Ans:

(1). Click on replace

(2). Find what :- you need to change

(3). Replace with : which you want to change.

Que82: How to change font style?

Ans:

(1). Go to the font tab

(2). Click on style

(3). Select any style.

Que83: How to change Case from lower to upper?

Ans:

(1). Go to the font tab/ Ctrl +H

(2).Click on change Case

(3). Click on upper case (if you want to change with upper)

(4). Click on lower case (if you want to change with lower)

Que84: How to find any particular word?

Ans:

(1). Click on find tab/ Ctrl +F

(2). Type the name which you want to find.

Que85: How to change effect of Text?

Ans:

(1). Go to the insert Tab

(2). Click on Word Art

(3). Type the word

(4). Click ok

Que86: How to insert Shapes in MS Word?

Ans:

(1). Go to the insert tab

(2). Click on shapes

(3). Select any of the shapes.

Que87: How to insert clip art in MS Word?

Ans:

(1). Go to the insert Tab

(2). Click on clip art

(3). Click on search bar

(4). Type the word which you want to find

(5). Then click ok

Que88: How to increase and decrease space between paragraph?

Ans:

(1). Select the paragraphs

(2). Go to the page layout tab

(3). Click on spacing

(4). Select spacing 

Que89: How to insert text box?

Ans:

(1). Go to the insert tab

(2). Click on text box

(3). Select any text box

Que90: How to insert bookmarks in any documents?

Ans:

(1). First create the page

(2). Click on insert tab

(3). Click on bookmark

(4). Select any page

(5). Given the page name of each document.

Que91: What is Paint?

Ans: Paint to used for painting it help us to make beautiful picture and scenary. Where in use can present our drawing to others.

Que92: How to open paint?

Ans:

(1). Go to the search bar

(2). Type paint

(3). Click on paint.

Que93: How many tools are there in Paint to make drawing?

Ans: There are many tools are in paint.

Like: Pencil tool, Bruse tool, Text tool, Fill with colar tool, Magnifier, Eraser tool.           

 Que94: How many Brush are there in Paint Wizard by default?

Ans: There are 9 brush are there in Paint Wizard by Default.

Que95: What is Shapes?

Ans: Shapes are predesigned shapes in paint for making drawing.

 Like: Line carve, Oval, Rectangle, Aerow, Star, up and down.

Que96: What is Snipping Tool?

Ans: Snipping tool is tool which is used to cut selected part of area or an image.

Que97: How to find Snipping Tool?

Ans: Go to search bar and type Snipping tool.

Que98: How to save file via snipping tool?

Ans: 

(1). Select the part of an area

(2). Go to file 

(3). Click on save as 

(4). Name of the file with location

(5). Save or click okay    

Que99: Shortcut key for undo?

Ans: ctrl+z

Que100: Full Form of CPU?

Ans: Central Processing Unit

Read More

What Is An Storage Device? Definition, and Examples - VS COMPUTER CLASSES

Storage Device Defination: -

Storage Device are those Device which is used to store data. Whenever we need to store any data at that time we used storage Device.

A storage device is among the essential components of any computer system, and it comes in a variety of shapes and sizes depending on the requirements and functionality. It holds almost all of the large datasets in a computer, except the exception of hardware-software. A storage device comes in a variety of shapes and sizes; for example, a computer has numerous file systems such as a hard drive, RAM, and cache. These have also optical disc drives and USB drives that may be linked outside. There are two sorts of storage systems that store data: main and secondary.

There are Many Storage Devices are Available in the Market. Example :-

Types of computer storage

Primary storage devices: primary storage is also referred to as internal memory. This is a component that is present inside the CPU which is used to store the temporary files and process them to get immediate results. The best examples for primary storage devices are RAM (Random access memory) and ROM (Read-only memory).

Secondary storage devices: From the name itself this can be known that this is a type of secondary storage which is external to the computer system. It is not as primary storage as here the data is being stored for the long term or we can say it’s permanent storage.

Primary storage devices

RAM

RAM means random access memory which is used to access any temporary data and to get intermediate results for the usage of that information. It is also known as temporary memory because the data will be stored only till the computer system is on, if it’s turned off the data will be lost.

ROM

ROM means read-only memory. This is also known as non-volatile memory as the information here is stored permanently until and unless it’s deleted by the user.

Secondary Storage Devices

Floppy Disks.

Magnetic Tapes.

Hard Disks.

Optical Disks.

Flash Memory Devices

Floppy disk: - The floppy disks are one of the oldest types of portable storage devices still in use. The floppy disks enable one to transfer small files between computers and also to start data/information as a backup. A standard floppy disk can store up to 1.44 Mb of data which is approximately equivalent to 300 A4 pages of text. However, if you have included graphics or pictures in it, your work will not fit in the floppy disk as graphics/pictures take up more space than text.

Megnetic Tapes :- Magnetic tape is a secondary storage device that can hold large volumes of data on it. The tape is a sequential access media and data on it can be accessed sequentially. Large files are stored on them. It is one of the most popular storage media because of its lower cost. These are similar to the tapes used in music cassettes or videotapes, in which data can be erased and reused.

Hard Disk :- The hard disk memories store information on one or more circular platters (or disks) which are continually spinning. These rotating disks are coated with a magnetic material and stacked with space between them. Information is recorded on the surface of rotating disks by magnetic heads as tiny magnetic spots. These Heads are mounted on access arms. Information is recorded in bands. Each band of information on a given disk is called a track.

Optical Disks: - Optical disks offer a higher density and reliability than magnetic disks. These disks are produced using laser beams. They are made of plastic or metal with a highly reflective coating, usually aluminum. In an optical disc, two laser beams are used one for reading data and another for writing data. The most commonly used optical disks are CDs, DVDs, and Blu-ray.

Flash Drives :- Flash memory is an electronic (solid-state) non-volatile computer storage medium that can be electrically erased and reprogrammed. They are either EEPROM or EPROM. Examples of Flash memories are pen drives, memory cards, etc. Flash memory offers fast access times. The time taken to read or write a character in memory is called access time. The capacity of the flash memories varies from 1 Gigabyte (GB) to 2 Terabytes (TB).

Note :- Some Basic Storage Device examples are -

Solid-state drives (SSDs).

Hard disk drives (HDDs).

Cloud storage.

CD-ROM drives.

DVD drives.

Blu-ray drives.

USB flash drives.

SD cards.

Floppy diskette.

Tape drives.

Zip and Jaz drives.

(Frequently Asked Questions)

Q1. What are computer storage devices?

Answer. A storage device enables its user to store and securely access data and applications on a computer device.

Q2. What are secondary storage devices?

Answer: Secondary storage devices are non-volatile in nature, which means that data is not deleted when the storage is turned off, and it has a much higher storage capacity than primary storage devices.

Q3. What are examples of storage devices?

Answer: Some of the widely used storage devices are CDs, DVDs, Pen drives, Memory Cards, SSD, and HDDs.

Q4. What is a magnetic storage device?

Ans. Magnetic storage devices are non-volatile storage in nature, and data are stored using magnetic medium and such data is stored in binary form as 0 and 1.

Q5. What are examples of an Optic storage device?

Ans. Examples of common optical storage devices are CD-ROM, Blu-Disc, DVD, CD-R.

For More Videos : Click On This Link

What is Computer? 

Computer का जन्म? Hindi Explanation.

What is An Output Device?

What is an Input Device?

If you have any experience, tips, tricks, or query ?You can drop a comment!

Happy Learning!!

Vishal Sir

Read More

What Is An Output Device? Definition, and Examples - VS COMPUTER CLASSES

 

What Is an Output Device?

An output device is a piece of computer hardware that receives data from a computer and then translates that data into another form. That form may be audio, visual, textual, or hard copy such as a printed document.

The key distinction between an input device and an output device is that an input device sends data to the computer, whereas an output device receives data from the computer.

For example, using a microphone to record a podcast is an example of using an input device. Listening to the recorded podcast through a connected speaker is an example of using an output device. Both output and input devices are examples of auxiliary, or peripheral, devices.

There are four different categories of output device:

• visual
• data
• print
• sound

Visual Output Devices

When output devices let uses to view the result or output as image or video format on the screen, then these output devices are known as ‘Visual Output Devices’. For examples are video card, projector, monitor and so on.

Data Output Devices

As the name suggests, when user are capable to read and understand. But it can’t get to access otherwise. These types of result are usually produced in textual format. For example – GPS and more.

Print Output Devices

These types of output devices let you to produce a printed hard copy of electronic data processed by computer system are known as print output devices. For example are plotter, printer, braille reader, and more.

Sound Output Devices

These kinds of output devices receive the information from the computer in audio formats is known as sound output devices. For examples are sound card, headphones, speakers, etc.

Examples of Output Devices

1. Monitor
2. Printer
3. headphones
4. Speakers
5. Projector
6. GPS
7. Sound card
8. Video Card
9. Plotter

1. Monitor

Mode: Visual

Function: A monitor consists of a screen, circuitry, a power supply, buttons to adjust screen settings, and a casing that contains all of these components. A monitor displays data from a computer onto a screen so the user can interact with the data via a digital interface.

Monitor is also called as the “Video Display Terminal (VDT)” and “Visual Display Unit (VDU)“.

Types of Monitor Are:

TFT Monitors: TFT stands for “Thin Film Transistor”, and these transistors are used for making high quality flat panel liquid-crystal displays (LCDs). It allows to display has transistor for every pixel on the screen.

LED Monitors:  LED stands for “Light Emitting Diodes”, and LED monitor is a flat screen flat-panel computer monitor. It can run at the lower temperature as well as consuming less power.

CRT Monitors: CRT stands for “Cathode Ray Tube”, and it is based on the cathode ray tubes. They are similar to vacuum tubes which produce images into form of video signals.

LCD Monitors: LCD stands for “Liquid Crystal Display”, and it is worked as the technology of liquid crystal display that is getting light weight than CRT monitor.

Plasma Screen Monitors: Plasma monitor also like as a flat panel display, and it totally based on the plasma display technology.

OLED Monitors: OLED stands for “Organic Light Emitting Diode”, and they are flat displays which are made with pixels from OLEDs rather than liquid crystal filled units.

2. Printer

Mode: Print

Function: The function of a printer is to create a copy of whatever is sent from the computer to the printer. Printers take electronic data sent from a computer and generate a hard copy.

Printers are divided into two categories, like as

• Impact Printers
  • Character Printer
  • Line Printer
• Non Impact Printers
  • Laser Printers
  • Inkjet Printers

3. Headphones

Mode: Sound

Function: Headphones output audio from a computer through two individual headphones for a single listener. Also known as earphones, headphones allow you to listen to audio without disrupting other people in the vicinity.

Types of Headphones

• Over-Ear Headphones
• In-Ear Headphones
• Ear buds
• Bluetooth Headphones
• Noise-Cancelling Headphones
• Closed-Back Headphones
• Open-Back Headphones
• On-Ear Headphones

4. Computer Speakers

Mode: Sound

Function: Computer speakers are hardware devices that transform the signal from the computer's sound card into audio. Speakers create sound using internal amplifiers that vibrate at different frequencies according to data from the computer. This produces sound.

Function of Speakers

The primary function of speaker is to transform the signals from the sound card of computer into audio. Computer speakers produce the sound with using of internal amplifiers which allow to vibrate at various frequencies according to data from the computer.

5. Projector

Mode: Visual

Function: As its name suggests, this output device "projects" computer images or video onto a wall or screen.

Types of Projectors

DLP Projector: DLP stands for “Digital Light Processing”, and it is getting more popularity because it is lightweight, as well as produces the crisp output.

LCD Projector: LCD stands for “Digital Light Processing”, and it is able to produce the ultra quality video output, so it is mostly used in the theaters.

CRT Projector: CRT stands for “Cathode Ray Tube”, and it uses a small, high-brightness cathode ray tube as the image generating element.

6. GPS (Global Positioning System)

Mode: Data

Function: GPS stands for “Global Positioning System“, and it is a space-based satellite navigation output hardware device that helps to calculate the location of your device. The aim of GPS is to produce the result related to providing location, weather conditions, and also tracking.

GPS (Global Positioning System) consists 24 satellites, and it scaled in space about 12000 miles about the earth’ surface

7. Sound Card

Mode: Sound

Function: The sound card controls the output of sound signals, enabling devices like speakers and headphones to work. The sound card is known as an expansion card, which means it can be added to the motherboard. Although a sound card is not essential to a computer's basic functionality, you need one if you wish to play games, watch movies, listen to music, and use audio and video conferencing.

Types of Sound Card

• USB Sound Cards
• PCMCIA / PC Cardbus
• On-Board Sound Cards

8. Video Card

Mode: Visual

Function: As with the sound card, the video card is an expansion card that slots into the motherboard. The video card processes images and video, enabling visuals to be seen on a display. Most computers have basic video and graphics capabilities built into the computer's motherboard, but for faster, more detailed graphics, a video card is required.

9. Plotter

Mode: Visual

Plotter is also hardware output device that is similar to printer but it allows to print wide format materials such as banners, brochures, pamphlets, etc.

Mostly, plotters are used in the engineering and basically draw a certain image on a number of straight lines.

Other Output Device Examples

• Computer Output Microfilm (COM, or Microfiche): COM is used to create a film image of the page sent from a computer.
• Plotter: A plotter interprets vector graphics files and draws lines between points.
• Television: A television (TV) is fed video and sound data which is output to the user in the form of synchronized sound and pictures.

Devices That Both Output and Input Data

• Modem: A modem sends and receives information over a telephone line or cables.
• Touch Screen: Touch screens accept input in the form of touch and display the output from the computer.
• Network Card (NIC): A network card is an expansion card for a computer that allows the device to connect to the network or internet.

FAQs (frequently Asked Questions)

What are 5 Example output devices?

Already, we have explained 10 examples with their function; but most common 5 output devices examples are Monitor, Printer, Speakers, Headphone, Multimedia and Screen Projector, etc.

How many output devices are there?

As per output devices’ ability about making audible, visible, interpretable or physically accessible result; they are divided into four categories like as Visual Output Devices, Data Output Devices, Print Output Devices, and Sound Output Devices.

What are the popular output devices?

Some of the popular output devices are: Monitor, Printer, Plotter, Projector and more.

What is the main function of output devices?

The main functions of output devices are to translate the machine’s response to a readable form for the computer user.

What are 10 output devices and their functions?

Through this article, already we have been explored above 10 output devices with their functions; you can read them.

What is the importance of output devices in computer?

Output devices have most importance because; they help to receive information from the computer system and processed this carried data by system then provide the output to user.

What are output devices name with its picture?

You can read this article is carefully, and then you will get answer of your question.

For More Videos : Click On This Link

What is Computer? 

Computer का जन्म? Hindi Explanation.

What is An Output Device?

What is an Input Device?

If you have any experience, tips, tricks, or query ?You can drop a comment!

Happy Learning!!

Vishal Sir

Read More