Basic IT Notes

CH # 1 – FUNDAMENTALS OF COMPUTER

SHORT DEFINITIONS 

1. Computer
It is an electronic device which accepts instructions in the form of input and after processing it gives us Information in the form of output.

2. Word Processor
Word processor is software that helps you to create any type of written communication like a letter, a report, a memo, or any other type of correspondence or text data. Microsoft Word, Word Pad, Word Star and Word Perfect are the common word processors. 

3.Excel
Microsoft Excel is an excellent program for organizing, formatting, and calculating numeric data. Excel displays data in a row-and-column format, with grid-lines between the rows and columns, similar to accounting ledger books or graph paper.

4.Function
A per-defined method of calculation is called function.

5.Presentation
A presentation is a collection of data and information that is to be delivered to a specific audience. 

Question No. 2 - Multiple Choice Question. 

1. Computer is an ______________

    a) Electronic Device

    b) Hardware

    c) Software

    d) Machine

 

2. The word computer comes from the word ______________

    a) Calculator

    b) Compute

    c) Components

    d) Counting

 

3. Information processing cycle (IPC) follow is ______________

    a) Input -> Output -> Processing

    b) Output -> Processing -> Input

    c) Input -> Processing -> Output

    d) Output -> Input -> Processing 

 

4. A computer consists of _______ components.

    a) 1

    b) 2

    c) 3

    d) 4

 

5. Computer gives us results based on ______________

    a) Input

    b) Output

    c) Windows

    d) Data & Instruction

 

6. Mouse is a ________________device.

    a) Pointing 

    b) Output

    c) Storage

    d) Both A & B

 

7. There are ______ types of monitor.

    a) 1

    b) 2

    c) 3

    d) 4

 

8. Speaker gives us result in form of ___________

    a) Text

    b) Animation

    c) Sound

    d) Video

 

9. Which Component used for storing instruction and data?

    a) Keyboard 

    b) Memory 

    c) Mouse

    d) Printer

 

10. C/C++ is ___________ Language

    a) Low level

    b) High level 

    c) Middle level

    d) All of them

Question No. 3 - Fill in the blanks.

1. Characteristics of a Computer (i)__Speed__ (ii) __No IQ__ (iii) __No Feeling__  
2. CPU consists of (i)__ Arithmetic & logical Unit__ (ii) __Memory Unit__ (iii) __Control Unit__
3. Name Input Devices (i) __Keyboard__ (ii) __Mouse__ (iii) __Mic__ (iv) __Scanner__
4. Name Output Devices (i) __Monitor__ (ii) __LCD__ (iii) __Speaker__ (iv)__ Printer__
5. Define System Software: It consists of the programs that control over all operations of the computer system.
6. Application Software: Software designed to do a specific task is called application software.

Question No.4 - Fill in the blanks.

1. [Windows] + [D] to _____ Display desktop _____
2. [Windows] + [M] to _____ Minimize all windows _____
3. [CTRL] + [Z] to _____ Undo Action _____
4. [CTRL] + [A] to _____ Select All items _____
5. [CTRL] + [V] to _____ Paste Selected Item _____
6. [F5] to _____ Refresh Window _____
7. [F2] to _____ Rename a selected item _____
8. [F1] to _____ Open the Help of the active program _____
9. [ALT] + [F4] to _____ Close the active program _____
10. [CTRL] + [W] to _____ Close an open document _____
11. SRAM stands for _____ Static Random Access Memory _____
12. LCD stands for _____ Liquid Crystal Display _____
13. LED stands for _____ Light emitting diode _____
14. CAD stands for _____ Computer Aided Design _____
15. PC stands for _____ Personal Computer ___

CH # 2 – MICROSOFT WINDOWS 7 

Question No.1 - MCQs Circle the correct option.

1. Windows 7 is the product of ________________

    a) Microsoft

    b) Apple

    c) Linux

    d) Unix

 

2. Windows 7 is an ______________ Software.

    a) Application

    b) Operating System

    c) Utility

    d) Typing

 

3. Windows Key + L is used for ______________ Computer.

    a) Shutdown

    b) Restart

    c) Lock

    d) Logoff 

 

4. Shortcut key for Show Desktop ______________ 

    a) Win+ L

    b) Ctrl + Esc

    c) Alt +F4

    d) Window Key + D 

 

5. Installed Programs can be access from ______________

    a) Start Menu

    b) Recycle Bin

    c) Control Panel

    d) Network

 

6. Small images which are available on the desktop are called.

    a) Programs

    b) Icons

    c) Pictures

    d) None of them

 

7. Which is compulsory drive in the computer for operating system ________________

    a) A:

    b) B:

    c) C:

    d) D: 

 

8. Run dialog box open using ______________ 

    a) Ctrl + R

    b) Alt + R

    c) Shift + R

    d) Windows Key + R

 

9. Window Media Player is used for playing _____________

    a) Audio

    b) Video

    c) Games

    d) Both A & B

 

10. ___________ Recorder software records our voice into the computer.

    a) Media

    b) Sound

    c) Voice

    d) None of them 

Question No.2 - Fill in the blanks.

1. Ctrl + Y used for _____Redo Action _____
2. F1 used for _____ Open Help of Current Application _____
3. Window Key used for _____Start Menu _____
4. F2 used for _____Rename File or Folder Name _____
5. F5 used for _____ Refresh Window _____

CH # 3 – MICROSOFT WORD 2010 

Question No.1 - MCQs Circle the right option.

1. MS Word 2010 has ______________ extension by default.

    a) Docx

    b) Doc

    c) Dos

    d) None of them  

 

2. The default alignment of text in MS Word 2010 is ______________

    a) Left

    b) Center

    c) Right

    d) Justify 

 

3. The Ctrl + S key is used to ______________ a document.

    a) Open

    b) Close

    c) Save

    d) Save As

 

4. MS Word 2010 has _________________ font by default.

    a) Arial

    b) Calibri

    c) Cambria

    d) Time New Roman

 

5. To delete one word to the left, ______________ key is used.

    a) Delete

    b) Page up

    c) Backspace

    d) End

6. The default page size in MS Word 2010 is ________________

    a) 8.27” x 11.69”

    b) 8.5” x 11”

    c) 8.5” x 14”

    d) 11.69” x 16.54”

 

7. To open existing document the _____________ key is used.

    a) Ctrl + A

    b) Ctrl +B

    c) Ctrl + N

    d) Ctrl + O

8. The F12 key is used to open __________________ dialog box.

    a) New

    b) Open

    c) Save

    d) Save As

 

9. The Ctrl + H key is used to open _______________ window 

    a) Find

    b) Replace 

    c) Find & Replace

    d) Font

 

10. MS Word 2010 has ______________minimum font size.

        a) 1

        b) 6

        c) 8

        d) 12

Q.No.2: Tick the correct box True/False.

1. By default the font style of MS Word 2010 is Times New Roman...............T / F
2. Ctrl + C is not the command for cut the text in MS Word...............T / F
3. Ctrl + U command is used to underline the text...............T / F
4. F12 command is used to Save As file in word...............T / F
5. Ctrl + J Command is used to justify the text...............T / F
6. Page setup from file menu is a way to insert page number in a document...............T / F
7. To get the ‘Symbol’ dialog box, click on the table menu and choose ‘Symbol’...............T / F
8. In Office button ‘QUIT’ is used to close a MS Word document...............T / F
9. Superscript, subscript, outline, emboss, engrave are known as font styles...............T / F
10. List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid are known as clip art...............T / F
11. The option “LOOSELY” is not available in Font Spacing...............T / F
12. Changing the appearance of a document is called Formatting...............T / F
13. You can detect spelling and grammar errors by press F7...............T / F
14. A feature of MS Word that saves the document automatically after certain interval is available on save tab on word Option dialog box...............T / F
15. There is no default font size of a new word document...............T / F
16. Left is a type of page margin...............T / F
17. Drop Cap means all caps...............T / F
18. Portrait and Landscape are Page Orientation...............T / F
19. Word Art is the option that is available in Mailings >> Label...............T / F
20. The key F12 opens a font dialog box...............T / F
21. Background color or effects applied on a document is not visible in print preview...............T / F
22. Thesaurus tool in Word Processor is used for synonyms and antonyms...............T / F
23. Superscript is not a font style...............T / F
24. Microsoft word is software that helps you to create written communication...............T / F
25. [CTRL] + [O] is used to open dialog box...............T / F

CH # 4 – MICROSOFT EXCEL 2010

Question No.1 - Multiple Choice Questions.

1. MS Excel 2010 has ______________ extension by default.

    a) xlsx

    b) xls

    c) dos

    d) None of them

 

2. MS Excel software is used for ___________________

    a) Letters

    b) Calculating

    c) Presentation

    d) Email

 

3. MS Excel Consists of ______________

    a) Document

    b) Webpage

    c) Worksheets

    d) All of them

 

4. Total Number of Columns available in MS Excel is _________________

    a) 13,384

    b) 14,384

    c) 15,384

    d) 16,384

 

5. Total Number of Rows available in MS Excel is _________________

    a) 1,048,576

    b) 1,148,576

    c) 1,248,576

    d) 1,348,576

 

6. A vertical group of cells within a worksheet is called ________________ 

    a) Row

    b) Column

    c) Cell

    d) Function

 

7. A Horizontal group of cells within a worksheet is called ________________

    a) Cell

    b) Row

    c) Column

    d) Formula

 

8. A group of cells is called __________

    a) Column

    b) Row

    c) Range

    d) Group

 

9. A number that can be used in an excel calculation is known as ________________

    a) Currency

    b) formula

    c) alphabet

    d) value

 

10. <, >, =, >=, <=, <> is known as ________________ operators.

    a) Math

    b) Logical

    c) Accounting

    d) Currency

 

11. Spreadsheet is a ___________

    a) Computer Application

    b) Computer Software

    c) None of them

 

12. Microsoft Excel consist of _________

    a) Rows

    b) Columns

    c) Work Sheet

 

13. Merge cell converts cells in to ________

    a) Single cell

    b) Double cell

    c) Format cell

 

14. Intersection of a column and row is called a

    a) Value

    b) Cell

    c) Interface

 

15. Formula always begin with _________

    a) =

    b) \

    c) [

 

16. The address consisting of column & row ID is called _______________

    a) Cell email

    b) Cell Reference

    c) None of them

 

17. Vertical group of cells is called ________

    a) Row

    b) Column

    c) Cell

 

18. A predefined method of calculation is called a

    a) Formula

    b) Function

    c) Both of them

 

19. A self-made method of calculation is called

    a) Formula

    b) Function

    c) Both A & B them

20. Collection of worksheets contained within a single file is called _________

    a) Folder

    b) File

    c) Work book

Question No.2 - True/False Circle The Option

1. Charts can be access using home menu in Excel...............T / F
2. Smart Art is the part of Clipart in Excel...............T / F
3. Function is another name of a pre-programmed formula in Excel...............T / F
4. Excel is a program that is used to prepare a spreadsheet...............T / F
5. Merge is used to join the selected cells into one cell...............T / F

CH # 5 – MICROSOFT POWERPOINT 2010

Question No.1 - Multiple Choice of Questions

1. MS PowerPoint is ____________ Software.

    a) Presentation

    b) Spreadsheet

    c) Document

    d) All of them

 

2. Presentation includes _____________ narration, images etc.

    a) Database

    b) Animation

    c) Spreadsheet

    d) Radio

 

3. A presentation is collection of ____________ that is to be delivered to a specific audience.

    a) Images

    b) Videos

    c) Data & information

    d) Sound

 

4. MS PowerPoint 2010 has ______________ extension by default.

    a) PPT

    b) XLXS

    c) DOCX

    d) PPTX

 

5. What is the default PowerPoint standard layout?

    a) Title Slide

    b) Blank

    c) Title Only

    d) None of them

 

6. Which short cut key used for new presentation in PowerPoint __________________?

    a) Ctrl + N

    b) Ctrl + M

    c) Ctrl + S

    d) All of above

 

7. From which menu you can access Picture, Text Box, Chart etc?

    a) File

    b) Edit

    c) Insert

    d) View

 

8. Which short key is used to run slide show from current slide?

    a) F5

    b) Shift + F5

    c) F6

    d) Shift + F6

 

9. Using PowerPoint we can also create ___________ of slides.

    a) PDF

    b) Video

    c) Image

    d) All of them

 

10. Which key is used to stop the presentation?

    a) Enter

    b) Esc

    c) Home

    d) Backspace

 

11. Which short cut key inserts a new slide in current presentation _______________

    a) Ctrl + N

    b) Ctrl + M

    c) Ctrl + S

    d) All of above

 

12. Which of the following is not a part of Slide Design?

    a) Design Template

    b) Color Scheme

    c) Animation Scheme

    d) Slide Layout

 

13. From which menu you can access Picture, Text Box, Chart, etc.

    a) File

    b) Edit

    c) Insert

    d) View

 

14. The effect applied to displayed when slides changes in slide show view is

    a) Slide Animation

    b) Custom Animation

    c) Custom Transition

    d) Slide Transition

 

15. In a PowerPoint presentation

    a) Sound clips can be inserted but not movie clips

    c) Both cannot be inserted

    b) Movie clips can be inserted but not sound clips

    d) Both can be inserted 

Q.No.2: Tick the correct box True/False

1. Ctrl + M add a new slide to the presentation...............T / F
2. We cannot add videos in presentation...............T / F
3. Themes can be access from the insert tab...............T / F
4. “Wipe” is available in transition...............T / F
5. There are 3 types of Presentation views in PowerPoint...............T / F

Question No.3 - Write the details of the following shortcut keys.

1. Ctrl + W _____ Close a Presentation _____
2. Ctrl + M _____ Add New Slide _____
3. Ctrl + O _____ Open and existing presentation _____
4. Ctrl + ] _____ Increase Font size _____
5. Ctrl + H _____ Open Find and Replace Dialog box _____

CH # 6 – INTERNET & E-MAIL

Question No.1 - Multiple Choice Questions

1. A Web page is a _____________ on the web.

    a) Document

    b) Presentation

    c) Internet

    d) All of them

 

2. Web pages can include text, pictures, ___________ and video.

    a) Keyboard

    b) Sound

    c) E-mail

    d) None of them

 

3. Which is not a web browser?

    a) Chrome

    b) Safari

    c) Apple

    d) Firefox

 

4. COM means ____________________

    a) Company

    b) Content

    c) Common

    d) Commercial

 

5. Which website is used to send e-mail?

    a) gmail.com

    b) google.com

    c) olx.com

    d) daraz.pk

 

6. WWW Stands for ________________________

    a) Wide World Web

    b) World Wide Web

    c) Web Wide World

    d) None of them

 

7. Which key is used to refresh the website?

    a) F1

    b) F2

    c) F5

    d) F11

 

8. Address separates the user name from the ISP using the __________ symbol.

    a) &

    b) @

    c) %

    d) *

 

9. Internet is a collection of computer _______________

    a) Network

    b) Software

    c) Programs

    d) Hardware

 

10. ________ is a company that gives you access to the internet.

    a) URL

    b) ISP

    c) HTTP

    d) Email

 

11. When sending an e-mail, the ___________________ line describes the contents of the message.

    a) To

    b) Subject

    c) Contents

    d) CC

Question No.2 - True/ False Circle the correct Option.

i). WWW stands for World Wide Web...............T / F

ii). URL stands for Uniform Resource Locator...............T / F

iii). NET stands for Network...............T / F

iv). Google.com is not a search engine...............T / F

v). Internet is run on Windows Explorer...............T / F

Question No. 3 - Place the correct word.

1. Write any names of two websites (i) __ google.com __ (ii) __ youtube.com __

2. WWW stands for _____ World Wide Web ____

3. URL stands for ___ Uniform Resource Locator _____

4. HTTP stands for ___ Hyper Text Transfer Protocol ____

5. .com is used for ___ Commercial _____

6. .org is used for ____ Organization _____

7. .edu is used for _____ Education _____