Computer aptitude questions with answers - Test Online

Computer aptitude questions with answers - Test Online

1. Which of the following short cut command is used to print the active document? 

a) Ctrl + P 

b) Alt + P 

c) Ctrl+Shift+P 

d) None of above 

2. Which of the following short cut command is used to underline words only? 

a) Ctrl+W 

b) Ctrl+Shift+W 

c) Shift+W 

d) a and b 

3. Why are headers and footers used in document? 

a) To allow page headers and footers to appear on document when it is printed 

b) To enhance the overall appearance of the document 

c) To make large document more readable 

d) All of the above 

4. Which of the following short cut key is used to display help document? 

a) F9 

b) F1 

c) F2 

d) F7 

5. Which is the Save As… command used to 

a) Change properties 

b) Save only 

c) Save as new filename 

d) All of the above 

6. When gutter margin is increased on page setup, the text area of the page will be… 

a) increased 

b) decreased 

c) neither increased or decreased 

d) the gutter margin can not be changed 

7. Which command is used to change the formatted text into the normal format? 

a) Alt+Enter 

b) Ctrl+Spacebar 

c) Ctrl+Enter 

d) Alt+Spacebar

8. What is the extension of Microsoft Word file? 

a) .ppt 

b) .doc 

c) .jpg 

d) .xls

9. .xls is the file extension for…

a) MS Word 

b) MS XLs 

c) MS Excel 

d) None of the above

10. The formula in MS Excel starts with …

a) / (divide) 

b) + (Plus) 

c) = (Equal) 

d) None of the above

11. The default row height in a MS Excel worksheet is … points

a) 15.75 

b) 10.75 

c) 12.75 

d) 13.75

12. Which of the following formula is true in MS Excel

a) A6 + C6 = 

b) B6 + C6 

c) = B6 + C6 

d) A6 + B6 =

13. Operator used to combine text from two cells into one cell

a) (space) 

b) & (ampersand) 

c) = (Equal sign) 

d) All of above

14. What symbol is used before a number to make it into a label in MS Excel

a) ’ (Apostrophe) 

b) “ (quote) 

c) = (Equal) 

d) _ (Underscore)

15. Which of the following is not a valid data type in MS Excel

a) Date/Time 

b) Number 

c) Character 

d) Label

16. In MS Excel, comments put in cells are called…

a) Soft tip 

b) Smart tip 

c) Cell tip 

d) Web tip

17. Workbook is collection of

a) Projects 

b) Cells 

c) Worksheets 

d) Workspaces

18. Short cut key to bring format cells dialog boxes

a) Ctrl+D 

b) Ctrl+F 

c) Ctrl+E 

d) Ctrl +I (This option had to be Ctrl+1, I guess it was a typing mistake)

19. The cell reference $A$5 is a …

a) Mixed cell reference 

b) Relative cell reference 

c) Absolute cell reference 

d) None of above

20. ‘OR’ operator shows ‘True’ value when …

a) All conditions are false 

b) Anyone condition is true 

c) Both conditions are true 

d) Both B & C