24/11/2015
Computer operator impotent questions
1.Which of the following is not an output device?
Flat Screen
Touch Screen
Printer
Scanner
What is a form in MS Access
It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All of above
______ temporarily stores the data and information while the processing is being undertaken by the CPU
RAM
ROM
Virtual Memory
None of above
Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
Apply a selected background color
All of the above
cascade update option
means do not change the value in the primary key field if that record has related records in another table
means change all the related records in child tables if the record in parent table is changed
Both of above
None of the above
Which of the following retains the information it’s storing when the power to the system is turned off?
CPU
ROM
DRAM
DIMM
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
. Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
The minimum number of rows and columns in MS Word document is
1 and 1
2 and 1
2 and 2
None of above
Which of the following is a term related with scanners?
Laser
TWAIN
Cartridge
Media
CAD stands for (Computer operator 2014)
Computer Application in Design
Computer Aided Design
Computer Algorithm for Design
All of above
Which of the following formula is true? (Computer operator 2014)
A6 + C6 =
A6 + C6
=A6 + C6
A6+B6
Which of the following pane is not available in Task Pane?
Getting started
Clip art
Word art
Search results
All of the following are examples of storage devices EXCEPT:
Hard Disk
CD
Floppy Disk
Printer
You can filter the display of different Access objects in navigation pane from
View tab in ribbon
Drop down menu at the top of navigation pane
Sort & Filter group in Home menu
Database tab
A Field or group of fields that uniquely identifies every row of a table is……. (Computer operator 2015)
Primary Key
Foreign Key
Hot Key
Access key
Which unit controls the movement of signals between CPU and IO? A
ALU
CU
MU
All of above
_____ is a temporary holding area for user data, operating system instructions, and program instructions.
ALU
Primary memory
RAM
Input device
What is the first step in creating a form or report with the form wizard or report wizard? (Computer operator 2014)
Selecting how the form or report should be formatted
Selecting the field that you want to appear in the form or report
Selecting the underlying table or query on which you want to base the form or report
Reading several screens of mostly useless information and clicking Next
What is the maximum number of lines you can set for a drop cap?
3
10
15
20
Which opf the following can you format using buttons on the formatting toolbar?
Your hard drive
Format Painting
Font color
Underlining
Which of the following is a file attribute?
Hidden
Archive
Read only
All of the above
A user can get files from another computer by using
File Transfer Protocol
TCP/IP
Internet Protocol
None of above
Numbers are stored and transmitted inside a computer in ….. (Computer operator 2015)
Binary form
ASCII Code form
Decimal form
Alphanumeric form
What is BIOS an acronym for?
Bootstrap initial operation system
Basic input output startup
Boot initial operating startup
Basic input output system
Cascade delete option
is used to delete all the records of all tables in a database
will repeat the recent delete operation to all the records of current table
is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent
None of above
When you link data maintained in an excel workbook to a word document
The word document can not be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
Multiple calculations can be made in a single formula using:
Standard Formula
Complex Formula
Smart Formula
Array Formula
Which tab is not available on left panel when you open a presentation?
Outline
Slides
Notes
All of the above available
Which of the following is graphics solution for word processors? (Computer operator 2015)
Clipart
WordArt
Drop Cap
All of the above
A central computer surrounded by one of more satellite computers is called a (Computer operator 2015)
bus network
ring network
star network
All of the above
A register organized to allow to move left or right operations is called a ___
Counter
Loader
Adder
Shift Register
What happens when you click on Insert » Picture » Clip Art? (Computer operator 2014)
It opens clip art task bar
It inserts a clip art picture into document
It lets you choose clip art to insert into document
None of above
What feature will you use to apply motion effects in between a slide exits and another enters?
Slide Transition
Slide Design
Animation Objects
Animation Schemes
What resides on the motherboard and connects the CPU to other components on the motherboard?
Input Unit
System Bus
ALU
Primary Memory
Long text can be broken into many lines within a cell, you can do this through (Computer operator 2014)
Wrap text in Format » Cells
Justify in Edit » Cells
Text wrapping in Format » Cells, Layout Tab
All of above
Which of the following is not a type of page margin?
Left
Right
Center
Top
Page numbering is inserted as…… (Computer operator 2015)
Footnote
Endnote
Footer
none of above
Which of the following statement is false?
If you choose to select from one of the pre-made slide layouts, you can change the positioning
If you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout.
Blank Slide is at the top of the ‘Content Layouts’ area in the Slide Layout panel.
All of above are false statements
Which of the following is not one of PowerPoint’s views?
Slide show view
slide view
presentation view
outline view
The _____ is used to transfer data from the memory to CPU
Serial Bus
Universal Bus
Data Bus
Control Bus
Short cut key for find and replace dialog box is :
Shift+F
Ctrl+F
Alt+R
Shift+R
What do you use to create a chart [ Computer Operator 2013]
Chart Wizard on toolbar
Insert-> chart on menubar
Insert -> Diagram on menubar
Both A & B
Ctrl + Shift + D (Computer operator 2015)
Double Paragraph Spacing
Delete Current word
Dotted Underline
Double Underline
Which of the following is hard output device?
Speaker
Monitors
Plotters
Projectors
Mostly which of the following device is used to carry user files?
Floppy Disk
Hard Disk
RAM
CDROM
In MS-Dos 6.22, which part identifies the product uniquely
MS
MS-Dos
DOS
6.22
You can set a controls border type to make the border invisible.
Transparent
Invisible
Do not display
No border
MS PowerPoint is a ______ software: (Computer operator 2014)
Database Management System
Word Processing
Electronic Spreadsheet
Presentation
What is the correct tag to add a hyperlink in html page? [ Computer Operator 2013]
< a name=’Target’ > link text < /a >
< a scr=’Target’ > link text < /a >
< link src=’Source’ > link text
< a href=’Target’ > link text < /a >
Which one is an example of absolute cell reference?
$D$7
$D$7
C5
None of the above
In Windows system, if the displayed system time and date system is wrong you can Reset it using (Computer operator 2015)
Write
Calendar
Card file
Control Panel
The first theory about software was proposed by
Charles Babbage
Lady Ada Augusta
Alan Turing ANS
None of above
____ tool helps to reduce file access time from disk (Computer operator 2014)
Format
Scandisk
Disk Defragmenter
Backup
From which menu you can insert header and footer?
Insert menu
View menu
Format menu
Tools menu
Which one is not an output device [Computer Operator 2013]
Printer
Keyboard
Monitor
None of above
Correct answers ...
1. Which of the following is not an output device? - Scanner
2. What is a form in MS Access - It is an input screen designed to make the viewing and entering data easier
3. ______ temporarily stores the data and information while the processing is being undertaken by the CPU - RAM
4. Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros? - On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
5. cascade update option - Both of above
6. Which of the following retains the information it’s storing when the power to the system is turned off? - ROM
7. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the - . Freeze panes command on the window menu
8. The minimum number of rows and columns in MS Word document is - 1 and 1
9. Which of the following is a term related with scanners? - TWAIN
10. CAD stands for (Computer operator 2014) - Computer Aided Design
11. Which of the following formula is true? (Computer operator 2014) - =A6 + C6
12. Which of the following pane is not available in Task Pane? - Getting started
13. All of the following are examples of storage devices EXCEPT: - Printer
14. You can filter the display of different Access objects in navigation pane from - Drop down menu at the top of navigation pane
15. A Field or group of fields that uniquely identifies every row of a table is……. (Computer operator 2015) - Primary Key
16. Which unit controls the movement of signals between CPU and IO? A - CU
17. _____ is a temporary holding area for user data, operating system instructions, and program instructions. - RAM
18. What is the first step in creating a form or report with the form wizard or report wizard? (Computer operator 2014) - Selecting the field that you want to appear in the form or report
19. What is the maximum number of lines you can set for a drop cap? - 10
20. Which opf the following can you format using buttons on the formatting toolbar? - Underlining
21. Which of the following is a file attribute? - All of the above
22. A user can get files from another computer by using - File Transfer Protocol
23. Numbers are stored and transmitted inside a computer in ….. (Computer operator 2015) - Binary form
24. What is BIOS an acronym for? - Basic input output system
25. Cascade delete option - is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent
26. When you link data maintained in an excel workbook to a word document - The word document contains a reference to the original source application
27. Multiple calculations can be made in a single formula using: - Array Formula
28. Which tab is not available on left panel when you open a presentation? - Outline
29. Which of the following is graphics solution for word processors? (Computer operator 2015) - Clipart
30. A central computer surrounded by one of more satellite computers is called a (Computer operator 2015) - star network
31. A register organized to allow to move left or right operations is called a ___ - Shift Register
32. What happens when you click on Insert » Picture » Clip Art? (Computer operator 2014) - It opens clip art task bar
33. What feature will you use to apply motion effects in between a slide exits and another enters? - Animation Schemes
34. What resides on the motherboard and connects the CPU to other components on the motherboard? - System Bus
35. Long text can be broken into many lines within a cell, you can do this through (Computer operator 2014) - Wrap text in Format » Cells
36. Which of the following is not a type of page margin? - Center
37. Page numbering is inserted as…… (Computer operator 2015) - Footer
38. Which of the following statement is false? - All of above are false statements
39. Which of the following is not one of PowerPoint’s views? - presentation view
40. The _____ is used to transfer data from the memory to CPU - Data Bus
41. Short cut key for find and replace dialog box is : - Ctrl+F
42. What do you use to create a chart [ Computer Operator 2013] - Both A & B
43. Ctrl + Shift + D (Computer operator 2015) - Double Underline
44. Which of the following is hard output device? - Plotters
45. Mostly which of the following device is used to carry user files? - Floppy Disk
46. In MS-Dos 6.22, which part identifies the product uniquely - 6.22
47. You can set a controls border type to make the border invisible. - Do not display
48. MS PowerPoint is a ______ software: (Computer operator 2014) - Presentation
49. What is the correct tag to add a hyperlink in html page? [ Computer Operator 2013] - < a href=’Target’ > link text < /a >
50. Which one is an example of absolute cell reference? - $D$7
51. In Windows system, if the displayed system time and date system is wrong you can Reset it using (Computer operator 2015) - Control Panel
52. The first theory about software was proposed by - Alan Turing ANS
53. ____ tool helps to reduce file access time from disk (Computer operator 2014) - Disk Defragmenter
54. From which menu you can insert header and footer? - View menu
55. Which one is not an output device [Computer Operator 2013] – Keyboard
