Computer |Part 3

 Gutter Margin - Margin that is added to the binding side of the page when printing 

Ctrl + N (Create a new document) 

Collection of worksheet is called - Workbook 

Intersection of row and column in a worksheet is called cell 

In Insert tab of MS Excel Chart option are available 

SEARCH () function use to find the location of the text in a string in MS Excel 

TRIM () function is used to remove extra space from the text in MS Excel 

Auto Content Wizard help to make simple presentation quicker in PowerPoint 

Template consist of readymade style that we can easily use for power point presentation 

Ctrl + M (new slide insert in PowerPoint presentation) 

(Esc key ) used to stop the slide show 

Shift + F5 (presentation start from current slide)

F5 ( Presentation start from starting slide) 

Bug in computer - An error in program

ASP - Application Service Provider 

(Unix operating system) developed in 1970 by 

(Bell Labs) by Kem Thompson and Dennis Richite 

JAVA a programming language developed by SUN company by James Gosley in (1995)

Hypertext was invented by (Ted Nelson) 

Wikipedia is a free encyclopedia,Written collaboratively by people who use it

Wikipedia Contain 40 million article 

Two versions of Internet Protocol (IP) are use in (IP version 4  and IP version 6)

First computer language developed was - FORTRAN (Formula Translation)

FORTRAN (Formula Translation) and it is high level programming language Developed by IBM

( AND gate ) in computer is use for multiplication 

Processor's speed of a computer is measured in MIPS (Million Instruction Per Second) 

In operating system, Round  Robin Schduling means - A kind of Scheduling 

The Process of data arranging in sequence is called - Sorting 

GIGO related to (Accuracy )

(GIGO) - Garbage in Garbage out 

Network of a series of horizontal and vertical lines constructed perpendicular to each other known as - Grid System 

WLL - Wireless in Local Loop 

Nano technology dimensions range - 10^-9m

Different Computer are connected to a LAN by a ( Cable and a interface card ) 

Packet switching used in internet 

All form of ROM is known as Firmware 

USB is secondary type of storage 

Cache memory works on the principle of Locality of reference 

UDP is Connectionless Protocol 

UDP - User datagram Protocol 

Sending a frame to a group of stations is known as - Multicasting 

WEP - Wireless Equivalent Privacy 

Ray Tomlinson developed the concept of E-mail 

Tim Berber Lee developed the concept of WWW 

Netscape Navigator is a Web browser 

ISDN - Integrated Service Digital Network 

String is a collection of letters, digits, Punctuation Characters, and so on. 

Protocol used for receiving an email is (POP - 3) 

POP - Post Office Protocol 

 Protocol for sending an email is SMTP

SMTP - Simple mail transfer protocol 

Valid version of MS Office are - Office XP,  Office 2013, Office 2007 

Not a valid version of MS Office is - Office 

 Vista 

Winword.exe file starts MS Word 

MS Word extension is (•docx) 

Ctrl + F12 (Open dialog box) 

F12 (Save as dialog box) 

Ctrl + F2 (Print Preview) 

In 3 ways we can save a document in word 

* Ctrl + S, * F12, * File - Save 

Thesaurus tool in MS Word used to show (synonyms words) 

F7 (Spelling Checking) 

Default font size of a new word document is - 11pt

( 8 and 72 ) is the smallest and largest font size in formatting toolbar 

The word wrap feature is Automatically move text to next line when necessary 

Alt + Ctrl + C ( create a copyright symbol )

Minimum number of rows and columns  in MS Word Table is (1 and 1)

Maximum number of columns that can be inserted in MS Word table is - 63

Portrait and Landscape are (Page Orientation) 

(10 maximum number of lines) we can set for a ( drop cap )

(By default 3 lines )We can set for a 

(drop cap) 

2 different positions we can set for drop cap 

Ctrl + F4 key use to close active document in Microsoft Word 

Cannot close the MS Word application by moving to file menu then choose close submenu 

Click File, Save As / only click F12 to (save document in new name) 

Ctrl + D (Open font dialog box) 

(a +B) ^2 - here 2  is superscript (upper) 

H2O - Here, 2 is subscript (lower) 

(Ctrl + =) is shortcut key for ( Subscript )

(Ctrl + Shift + =) is shortcut key for (superscript)

Ctrl + N (new document) 

Ctrl + W (Close current window) 

Ctrl + M (Increase Indent) 

Ctrl + L (Left align) 

Ctrl + Q (remove Indent) 

Ctrl + T ( Hanging Indent) 

To start a new paragraph in MS Word you should press - Enter 

To break the current column and start a new column immediately we should press - 

Ctrl + Shift + Enter

Columns Dialog box can be opened from -

* Format menu columns sub menu 

* Double click on columns space in ruler 

* Alt + O + C Enter 

Part of standard office suite are -

Word Processor, Database, Image Editor, Microsoft Excel, Microsoft Word ,Microsoft PowerPoint 

File manager not a Part of standard office suite

Insert date, Format page Number ,Insert Auto text are found in (Header and Footer) in MS Word 

Font tab in - Font Dialogbox contain - Font Effect 

Font Style are - Bold, Italics,Regular,

Not a Font style - Superscript, Subscript 

Ctrl + I - Applies Italic format to selected text 

View buttons placed on the left of horizontal scroll bar 

Spelling and Grammar command you should allways use before submitting a document to other 

Alt + F9 is the shortcut key to (display field code )

Shift + Enter is the shortcut key for manual line break 

Enter is the shortcut key for new paragraph 

In word 2007 and above zoom percentage is placed on - View tab and Status bar 

Border can be apply on - Cell, Paragraph and text 

When three hypen,underscore, equal sign ,asterisks,number sign are type then the enter key is pressed ,Auto format feature --Placed a border above a paragraph 

Using find command in MS Word,We can search - Characters, Symbols, Formats 

3 steps for Mail Merge Helper are - 

Merge the two files , Create the Main Document , Create the data source 

Ctrl + J (Align Justify)

Ctrl + E  (Centre Align) 

Ctrl + R (Right Align) 

Ctrl + Z (Undo) 

Ctrl + Y (Redo) 

In MS Word ruler help to--

 * To set tabs

* To set Indents 

* To change page margin 

Theme is a collection of predefined design elements and color scheme 

Drop caps are used in document - To begin a paragraph with a large dropped initial letter 

Changing the appearance of a document is called formatting 

Home key used to moves the cursor to beginning of the line 

Ctrl + Home is used to Move the cursor to the beginning of the document 

Ctrl + End  is used to move the cursor to the end of document 

End - key used to move the cursor to the end of line 

Ctrl + K (Insert Hyper Link) 

A computer can't boot. If it doesn't have operating system 

Collection of Software is known as operating system 

Booting in computer -(2 type)

* Cold  Booting - switch off then again start the computer 

* Warm Booting - computer is on running mode and again we restart the computer 

Warm Boot - Ctrl + Alt + Del

Junk - e mail also called as Spam 

e-mail - electronically mail 

IP address refers to - A numerical network level 

Laser technology used in a compact disc 

(Laser) full form - Light Amplification by stimulated emission of Radiation 

Laser invented by - Theodorh(1960)

Laser technology use in eye surgery, Tattoo removal 

Linux - Open Operating system 

Storage device - iPod ,pendrives, Flash Disks 

Windows 10 - Operating System

McAfee - Anti-virus software 

Virus - I love you 

Firewalls perform (IP)Internet Protocol blocking to protect networks from unauthorized access 

The process when the computer is switched on and the operating system gets loaded from hard disk to main memory is called - Cold booting 

CMOS - Complementary Metal Oxide Semi Conductor - it is a battery powered memory chip 

UDP - User Datagram Protocol - It is a Connectionless Protocol 

VoIP - Voice over Internet protocol 

Ctrl + V (Pasting text) 

On the basis of memory size and performance Big Iron computer is - Main Frame 

Main Frame computer use in - Airport, bank, IT service 

Communication mode - 3 type of 

* Simplex communication mode - Unidirectional (communication take place from one side) 

ex - Radio station, Keyboard 

* Half Duplex (at same time communication can't take place from both side) 

ex- Walkie - Talkie 

Full Duplex (at same time communication take place from both the side) 

ex - Telephone communication 

Logical Errors identified by the Compiler

Compiler convert high level language to machine level language 

The size of yes no field is always - 1bit

ASP - Application Service Provider 

E-mail - here attachment file is 25mb more than that can't be attached 

Books in electronics format is called

(e-books)

The web uses the HTML (Hyper Text Markup Language to request and serve web pages and programs

The silicon chips used for data processing is called ( micro processor )

The computer which is assigned one and only one task is called dedicated computer 

System Software helps to run the computer hardware 

Mac OS/ Mac Operating System  introduced by Apple 

Penguin is the mascot of Linux Operating System 

More than one process is called Multitasking System 

GUI - Graphical User Interface 

Syntax error is determined by - Control Unit 

Internet is the largest network in terms of area 

MAN - Metropolitan area network 

WAN - Wide area network 

Cache memory is the high speed memory used in computer 

MAX () function return the largest value 

among the value passed as arguments in  Microsoft Excel 

Dr. Web is anti- virus 

Processed data is known as Information 

Firewall can be a combination of software and hardware 

Bug in computer is - An error in program 

A computer always has a CPU (central processing unit) 

In Windows start button is used to - Run application, Device Setting, Turn off the system 

The first programming language -FORTRAN

(formula translation) 

FORTRAN - High level programming language 

FORTRAN invented by - John 

In IT terminology failure in kernel is called - Crash 

Do no Evil is tagline of google

Ctrl + Shift + ! (Format number in comma format) 

Ctrl + Shift + $(Format number in currency format) 

Ctrl + Shift + # (Format number in date format) 

Ctrl + Shift +% (Format number in percentage format) 

1kb/kilobyte = 1024 bytes 

4kb /kilobyte = 1024*4 = 4096(ans)

Graphical file extension - JPG, GIF,BMP /JPEG, GIF,BMP

JPG - Joint photographic group 

JPEG - Joint photographic expert group 

GIF - Graphic Interchange format 

BMP - Bitmap image file 

Notepad extension is ( .txt) 

VDU - Visual Display Unit ( it is an output device) 

3 Color dot make up one color pixel on a screen and that are - (Red, Blue, Green) 

Computer understand - Assembly Language 

Ethernet uses in - Bus Topology 

A host on internet find another host by its IP Address 

VoIP (Voice over internet protocol)  allow telephone call to be made over computer network like internet 

HTML -Hyper text mark up language (a programming language) 

To join the internet the computer has to be connected to (internet service provider) 

Protocol is a set of rule that governs data communication 

Internet stand for - international network 

ISP - Internet Service Provider 

In Microsoft Excel  MIN () function is returned the smallest value among the value passed arguments 

ISDN - Integrated Service Digital Network 

Related to Computer Wetware is - Human Brain 

The system board is also known as Mother board, Main circuit board, Baseboard 

A hard copy of a document is printed on printer 

MS Word

Type of Break Shortcut Key Effect

Manual Line Break Shift + Enter Starts a new line within the same paragraph.

Paragraph Break Enter Starts a entirely new paragraph with standard spacing.

Page Break Ctrl + Enter Forces the subsequent text to start on a new page.

Column Break Ctrl + Shift + Enter

Forces text to the top of the next column.