MCQ questions on computer awareness

MCQ  questions on computer awareness
 Multiple Choice Question on Computers
Fundamentals Of Computers MCQ Questions

1.How are data organized in a spreadsheet?

(a) Lines and spaces

 (b) Layers and planes

(c) Height and width    

(d) Rows and columns

Ans : d

2.You can not link excel worksheet data to a word document

(a) with the right drag method

(b) with a hyperlink

(c) with the copy and paste special commands

(d) with the copy and paste buttons on the standard toolbar

Ans : d

3. The advantage of using a spreadsheet is

(a) calculations can be done automatically

(b) changing data automatically updates calculations

(c) more flexibility

(d) All of the above

Ans : d

4.Anything that is typed in a worksheet in MS-Excel  appears

(a) in the formula bar only        

(b) in the active cell only

(c) in both active cell and formula bar   

(d) None of these

Ans : c

5.Two common wildcard characters that Excel recognizes are

(a) * and?

(b) <and>        

(c) Aand /

(d) ÷ and —

Ans : a

6.Cell address $A$4 in a formula in MS-Excel means it is a

(a) mixed cell reference

(b) absolute cell reference

(c) relative cell reference          

(d) None of these

Ans : b

7. The address of the cell at 20th column and 30th row in MS-Excel

(a)T30 

(b)T20

(c)T1O

(d)T40

Ans : a

8.A chart placed in a worksheet in MS-Excel is called

(a) formatting chart

(b) embedded chart     

(c) aligning chart          

(d) None of these

Ans : b

9.The Extension of saved file in MS-Excel

(a) .XIS

(b) .XAS         

(c) .XLS          

(d) .XLL

Ans : c

10. General arrangement of data is known as

(a) arrangement

(b) overwriting 

(c) manipulating           

(d) formatting

Ans : d

11.Three types of data can be entered in a worksheet, number/characters, text and

(a) formulas

(b) functions    

(c) logic           

(d) None of these

Ans : c

12. Which of the following are actions you can assign to an action button or slide object in MS Power Point ?

(a) Run a macro

(b) Play a sound

 (c) Hyperlink

(d) All of these

Ans : d

13. Which of the following is not a feature of PowerPoint?

(a) Printing transparencies

(b) Printing the speaker’s notes along with slide images

(c) Linking a slide transition with a laser pointer

(d) Drawing with a pen

Ans : c

14. The following view is not present in PowerPoint.

(a) Normal

(b) Outline

(c) Slide Sorter

(d) Slide Show

Ans : b

15. In MS Power Point ,To edit the text within the boxes of an Organization chart, you

(a) select the box and text, then make changes

(b) select the box, then make the changes

 (c) highlight the text, them make the changes

(d) Both a and b

Ans : a

16. Which command brings you to the first slide in your presentation in MS Power Point?

(a) Next slide button

(b) Page up

(c) Ctrl + Home

(d) Ctrl + End

Ans : c

17. Want your logo in the same position on every slide, automatically in MS Power Point? Insert it on the

(a) handout master

(b) notes master

 (c) slide master

(d) All of these

Ans : c

18. Which of the following is not one of the process that a high level language program must go through before it is ready to be executed?

(a) Translation 

(b) Controlling 

(c) Lading        

(d) Linking

Ans : a

19. Which of the following was most oriented to scientific programming?

(a) FORTRAN

(b) COBOL    

(c) BASIC      

(d) PL/1

Ans : a

20.The two basic types of record access methods are

(a) sequential and random        

(b) direct and immediate

(c) sequential and indexed        

(d) on-line and real-time

Ans : a

21. When a key is pressed on the keyboard, which standard is used converting the keystroke into the corresponding bits?

(a) ANSI         

(b) ASCII       

(c) EBCDIC    

(d) ISO

Ans : a

22.1 kilobyte (KB) equal to

(a) 1000 bits

 (b) 1024 bits  

(c) 1020 bits    

(d) 1030 bits

Ans : b

23. These DOS commands are loaded in the primary memory of the computer

(a) internal       

(b) external      

(c) Both a and b          

(d) None of these

Ans : a

24.It allows only one user to work on a CPU at a time

(a) single user operating system

(b) multi user operating system

(c) multi level operating system 

(d) two level operating system

Ans : a

25.Which one of these is an operating system?

(a) MS-Office

(b) MS-DOS  

(c) MS- Word

(d) MS-Access

Ans : b