Important Computer MCQs For Competitive Exams part-1 | Set 19

1. Which function will you use to enter current time in a worksheet cell?

2. Special category of Number tab in Format cells dialog box can be used to apply formats like :

3. Merge cells option can be applied from :

A. Format Cells dialog box Alignment Tab

B. Formatting toolbar

C. Formatting Cells

D. All of these

E. None of these

Correct : A. Format Cells dialog box Alignment Tab

4. Pre-mde sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:

5. Which of the following format you can decide to apply or not in AutoFormat dialog box?

6. How can you remove borders applied in cells?

A. Choose None on Border tab of Format cells

B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)

C. Choose remove on Border tab of Format cells

D. Both (a) and (b)

E. None of these

Correct : D. Both (a) and (b)

7. Where can you set the shedding color for a range of cells in Excel?

A. Choose required color form Patterns tab of Format Cells dialog box

B. Choose required color on Fill color tool in Formatting toolbar

C. Choose required color on Fill Color tool in Drawing toolbar

D. All of these

E. None of these

Correct : D. All of these

8. You can set Page Border in Excel from:

A. From Border tab in Format Cells dialog box

B. From Border tool in Formatting toolbar

C. From Line Style tool in Drawing toolbar

D. You cannot set page border in Excel

E. None of these

Correct : D. You cannot set page border in Excel

9. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply :

A. use = if ( ) function to format the required numbers red

B. Apply Conditional Formatting Command on Format Menu

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D. All of these

E. None of these

Correct : B. Apply Conditional Formatting Command on Format Menu

10. You can check the conditions against…….. when applying conditional formatting :

11. Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

E. None of these

Correct : D. The width of a row and be specified manually or fit automatically

13. When you insert an Excel file into a word document, the data are :

14. Except for the……….function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result :

16. You can open the consolidate dialog box byt choosing consolidate from the…….menu.

17. Each excel file is called a workbook because :

A. It can contain text and data

B. It can be modified

C. It can contain many sheets including worksheets and chart sheets

D. You have to work hard to create it

E. None of these

Correct : C. It can contain many sheets including worksheets and chart sheets

18. Which types of charts can excel produce?

A. Line graphs and pie charts only

B. Only line graphs

C. Bar charts, line graphs and pie charts

D. Bar charts and line graphs only

E. None of these

Correct : C. Bar charts, line graphs and pie charts

19. How are data organized in a spreadsheet?

20. What does the VLOOKUP function do?

A. Looks up text that contain ‘v’

B. Checks whether text is the same in one cell as in the next

C. Finds related records

D. All of these

E. None of these

Correct : C. Finds related records

21. Gridlines :

A. May be turned off for display but turned on for printing

B. May be turned on or off or printing

C. The be turned off for display and printing

D. All of these

E. None of these

Correct : D. All of these

22. You can print only an embedded chart by

A. Moving the chart to a chart sheet before you print.

B. Formatting the chart before you print

C. Selecting the chart before you print

D. Both (a) and (c)

E. None of these

Correct : D. Both (a) and (c)

24. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

A. On the file menu, point to print area, and then click set print area.

B. On the file menu, click print, and then click selection under print what

C. On the view menu, click custom views, then click add

D. All of these

E. None of these

Correct : B. On the file menu, click print, and then click selection under print what

25. Your German supplier still invoices for parts in deutsche marks.

A. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.

B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

C. Apply a selected background color

D. All of these

E. None of these

Correct : B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

26. Which function calculates your monthly mortgage payment?

27. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

A. Point to speech on the tools menu, and then click show text to speech toolbar.

B. Click validation on the data menu

C. Point to speech on the tools menu, and then click speech recognition

D. All of these

E. None of these

Correct : A. Point to speech on the tools menu, and then click show text to speech toolbar.

28. Which of the following methods cannot be used to enter data in a cell?

A. Pressing an arrow key

B. Pressing the tab key

C. Pressing the Esc key

D. Clicking the enter button to the formula bar

E. None of these

Correct : C. Pressing the Esc key

29. Which of the following methods cannot be used to edit the content of cell?

30. To insert three columns between columns D and E you would :

31. To enter worksheet s across a range of cell, you must :

A. Select the cells containing the title text and use the fill handle to center the text across a range of cells

B. Widen the columns

C. Select the cells containing the title text and use the fill handle to center the text across a range of cells

D. Widen the column

E. None of these

Correct : A. Select the cells containing the title text and use the fill handle to center the text across a range of cells

33. Charts tips can :

A. Show the formatting of a data label

B. Show the name of a data series

C. Show the value of data point

D. Both (b) and (c)

E. None of these

Correct : B. Show the name of a data series

34. The Name box :

A. Shows the location of the previously active cell

B. Appears the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

E. None of these

Correct : B. Appears the left of the formula bar

35. How do you change column width to fit the contents?

A. Single-click the boundary to the left to the column heading

B. Double click the boundary to the right of the column heading

C. Press Alt and single click anywhere in the column

D. All of these

E. None of these

Correct : B. Double click the boundary to the right of the column heading

36. Hyperlinks cannot be :

A. Special shapes like stars and banners

B. Drawing objects like rectangles ovals

C. Pictures

D. All can be hyperlinks

E. None of these

Correct : D. All can be hyperlinks

37. You can use the horizontal and vertical scroll bars to :

A. Split a worksheet into two panes

B. View different rows and columns

C. Edit the contents of a cell

D. View different worksheets

E. None of these

Correct : B. View different rows and columns

38. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

39. Which operation is not performed by computer

40. The computer that process both analog and digital is called

41. A rig t click on the desktop itself will ……………..

A. open the Display Properties dialog box

B. show a context-sensitive menu

C. open the Control Panel

D. minimize all open applications

E. None of these

Correct : A. open the Display Properties dialog box

42. The window which shows icons for things like the mouse, sound, and display is…….

43. ……….refers to a computer’s ability to configure and use a device without human interaction.

45. Today’s computer giant IBM was earlier known by different name which was changes in 1924. What was that name?

A. Tabulator Machine Co.

B. Computing Tabulating Recording Co.

C. The Tabulator Ltd.

D. International Computer Ltd.

E. None of these

Correct : B. Computing Tabulating Recording Co.

46. The process of starting a or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called

47. What does the disk drive of a computer do?

A. Rotate the disk

B. Read the disk

C. Load a program from the disk into the memory

D. Both (b) and (c)

E. All (a), (b) & (c)

Correct : D. Both (b) and (c)

48. IMB launched its first personal computer called IBM-PC in 1981. It had chips from Intel, disk drives from Tandon, operating system from Microsoft, the printer from Epson and the application software from everywhere. Can you name the country which contributed the video display?

49. In H2O the figure 2 is appeared lowered. Which effect has been applied?

54. To produce a high-quality graphics (hardcopy) in color, you would want to use a

55. What is Mail-Merge?

A. a web based e-mail service with no spam

B. a name of Yahoo! MINDSET search feature

C. a new virus-hoax which can delete data from mail-inbox

D. a feature of MS-Word used to create multiple documents like letters, mailing labels, name tags etc.

E. None of these

Correct : D. a feature of MS-Word used to create multiple documents like letters, mailing labels, name tags etc.

56. The process of checking the validity of information held in a transaction file is

57. A………….shares hardware, software, and data among authorized users.

58. Which of the following is not a function of the control unit?

59. Software for organizing storage and retrieval of information is a(n)………

60. Which of the following is not true about RAM?

A. RAM is a temporary storage area

B. RAM is the same as hard disk storage

C. RAM is volatile

D. Information stored in RAM is gone when you turn the computer off

E. None of these

Correct : B. RAM is the same as hard disk storage

63. The most common input devices include ………&………..

64. Holding the mouse button down while moving an object or text is known as :

65. A…………is a professionally designed document that can be adapted to the user’s needs.

67. …………are often delivered to a PC through an e-mail attachment and are often designed to do harm.

69. All are included in removable media except the following.

70. Straight and Uniform margins on both the sides indicate that there is……..in the document.

71. Which of the following terms is used for the form in which the word will appear on the page?

72. …………Key combination that lets you toggle between open windows.

73. The secondary storage memory is also called as

74. …………is known as unauthorized access into others system.

75. VIRUS stands for

A. Vital Information Recourse Under Siege

B. Vital Information Reason Under Siege

C. Vital Information Recourse Under System

D. Virus Information Recourse Under Siege

E. None of these

Correct : A. Vital Information Recourse Under Siege

77. A person needs to design invitation card. What type of computer program is suitable?

81. What is object of UPS?

82. CPU capacity can be measured in following I/O techniques have banks traditionally followed?

83. “Zipping” a file means

84. The instructions that tell a computer how to carry out the processing tasks are referred to as computer…………

85. An area of a computer that temporarily holds data waiting to be processed is……….

86. To select or unselect one word to the right.

A. CTRL + SHIFT

B. CTRL + SHIFT + Up Arrow

C. CTRL + SHIFT + Down Arrow

D. CTRL + SHIFT + Right Arrow

E. None of these

Correct : D. CTRL + SHIFT + Right Arrow

88. To Copy a picture of the selected window to the clipboard.

89. ……….is the key to close a selected drop- down list; cancel a command and close a dialog box.

92. ………..is the combination of keys to switch between the last four places that you have edited.

94. Data becomes………when it is presented in a formats that people can understand and use.

95. The term………..designates equipment that might be added to a computer system to enhance its functionality.

96. A………..is a microprocessor-based com- puting device.

97. RAM can be thought of as the……..for the computer’s processor.

98. Which of the following are the functions of a operating system

99. To move a copy of file from one computer to another over a communication channel is called?

100. The primary function of the……..is to set up the hardware and load and start an operating system.

Quiznetik

Important Computer MCQs For Competitive Exams part-1 | Set 19

1. Which function will you use to enter current time in a worksheet cell?

2. Special category of Number tab in Format cells dialog box can be used to apply formats like :

3. Merge cells option can be applied from :

4. Pre-mde sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:

5. Which of the following format you can decide to apply or not in AutoFormat dialog box?

6. How can you remove borders applied in cells?

7. Where can you set the shedding color for a range of cells in Excel?

8. You can set Page Border in Excel from:

9. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply :

10. You can check the conditions against…….. when applying conditional formatting :

11. Which of the following is invalid statement?

12. What function displays row data in a column or column data in a row?

13. When you insert an Excel file into a word document, the data are :

14. Except for the……….function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result :

15. Macros are “run” or executed from the …………..menu.

16. You can open the consolidate dialog box byt choosing consolidate from the…….menu.

17. Each excel file is called a workbook because :

18. Which types of charts can excel produce?

19. How are data organized in a spreadsheet?

20. What does the VLOOKUP function do?

21. Gridlines :

22. You can print only an embedded chart by

23. A function inside another function is called a function

24. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

25. Your German supplier still invoices for parts in deutsche marks.

26. Which function calculates your monthly mortgage payment?

27. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

28. Which of the following methods cannot be used to enter data in a cell?

29. Which of the following methods cannot be used to edit the content of cell?

30. To insert three columns between columns D and E you would :

31. To enter worksheet s across a range of cell, you must :

32. When integrating MS-Word and Excel, Word is usually the :

33. Charts tips can :

34. The Name box :

35. How do you change column width to fit the contents?

36. Hyperlinks cannot be :

37. You can use the horizontal and vertical scroll bars to :

38. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

39. Which operation is not performed by computer

40. The computer that process both analog and digital is called

41. A rig t click on the desktop itself will ……………..

42. The window which shows icons for things like the mouse, sound, and display is…….

43. ……….refers to a computer’s ability to configure and use a device without human interaction.

44. When was the first windows operating system launched?

45. Today’s computer giant IBM was earlier known by different name which was changes in 1924. What was that name?

46. The process of starting a or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called

47. What does the disk drive of a computer do?

48. IMB launched its first personal computer called IBM-PC in 1981. It had chips from Intel, disk drives from Tandon, operating system from Microsoft, the printer from Epson and the application software from everywhere. Can you name the country which contributed the video display?

49. In H2O the figure 2 is appeared lowered. Which effect has been applied?

50. A Laptop or Notebook marked 802.11n in its feature, it means device support

51. You Tube service of streaming videos online in provided by

52. When using characters in Windows, what code does Windows use?

53. Which is the latest type of printer interface?

54. To produce a high-quality graphics (hardcopy) in color, you would want to use a

55. What is Mail-Merge?

56. The process of checking the validity of information held in a transaction file is

57. A………….shares hardware, software, and data among authorized users.

58. Which of the following is not a function of the control unit?

59. Software for organizing storage and retrieval of information is a(n)………

60. Which of the following is not true about RAM?

61. The main directory of a disk is called the…………directory.

62. SUM (B1:B8) is an example of a………..

63. The most common input devices include ………&………..

64. Holding the mouse button down while moving an object or text is known as :

65. A…………is a professionally designed document that can be adapted to the user’s needs.

66. What is the intersection of a column and a row on a worksheet called?

67. …………are often delivered to a PC through an e-mail attachment and are often designed to do harm.

68. Documents converted to………..can be published to the Web.

69. All are included in removable media except the following.

70. Straight and Uniform margins on both the sides indicate that there is……..in the document.

71. Which of the following terms is used for the form in which the word will appear on the page?

72. …………Key combination that lets you toggle between open windows.

73. The secondary storage memory is also called as

74. …………is known as unauthorized access into others system.

75. VIRUS stands for

76. Which of the following mode we use to deliver e-mail

77. A person needs to design invitation card. What type of computer program is suitable?

78. The term that we use to describe physical components of the system.