500 important mcqs of computer for preparation spsc, nts,pts,cts,uts,fpsc and other jobs


30. Which of the following will not advance the slides in a slide show view?
(a) Esc key
(b) The spacebar
(c) The Enter key
(d) The mouse button
31. In Microsoft PowerPoint in order to see all the slides on one screen use
(a) view, slide sorter
(b) view, slide
(c) view, master
(d) view, slide show
32. What's the best place to find animated
images for your PowerPoint 2002
presentation?
(a) Microsoft online
(b) Word clipart
(c) PowerPoint tools and ins
(d) All of above
33. Which of the following options in the printer dialog box would you select to prit slides 5 and 12 in a presentation?
(a) Slides
(b) Custom shows
(c) Current slide
(d) All
34. Which of the following toolbars provides different options in various master views?
(a) Common tasks toolbar
(b) Drawing toolbar
(c) Formatting toolbar
(d) Standard toolbar
35. You can tell when an object is active
because
(a) The object is highlighted
(b) Eight small sizing handles appear
surrounding the text
(c) A box frame appears surrounding the
text
(d) b and c
36. Which of the following is not an option when printing handouts?
(a) Six slides per page
(b) Five slides per page
(c) Three slides per page
(d) Two slides per page
37. Any and every command can be found on the
(a) Drawing toolbar
(b) Formatting toolbar
(c) Standard toolbar
(d) Menu bar
38. What are symbols used to identify items in list?
(a) Icons
(b) Markers
(c) Bullets
(d) Graphics
39. The toolbars that are displayed by deta the Power Point window includes
(a) Menu bar, standard toolbar, formatting
toolbar, drawing toolbar, status bar
(b) Menu bar, standard toolbar, formatting
toolbar, drawing toolbar, status bar
(c) Standard toolbar formatting toolbar.
drawing toolbar, status bar
(d) Menu bar, standard toolbar, status bar
drawing toolbar
40. Which of he following provides a means of printing out features notes with a miniature
slide on a printed page?
(a) Slides with animation
(b) Outline view
(c) Notes page
(d) Audience handout
41.Which command brings you to the first slide in your presentation?
(a) Next slide button
(b) Page up
(c) Ctrl + home
(d) Ctrl + end
42. Your presentation is ready to go, but you don't know if PowerPoint is installed on the computer, you will use to present with what's the safe way
(a) Save your presentation as a web page
(b) Set up your presentation to be "browse
as a kiosk"
(c) Use the Pack and Go wizard
(d) All of above
43. To adjust the width of table columns, you
(a) Click table menu. Column width, then
make adjustments
(b) Drag the vertical gridline between two
columns
(c) Drag the column markers on the table
ruler bar
(d) b and c
44. to add a new row to a table you would
(a) click the insert rows command on the
insert menu
(b) press the enter key
(c) click the insert rows button on the
standard toolbar
(d) none of the above
45. What is the term used to described the
separation of a clip art object into different parts so that it becomes a PowerPoint object?
(a) Embedding
(b) Regrouping
(c) Ungrouping
(d) Grouping
46. The auto shapes tool provides you with
(a) Fancy text to place on your slide
(b) Commonly found shapes
(c) Any shape you want to add on a slide
(d) Clip art that is related to your
Presentation
47. Which of the following format options should be used to display dollars on an axis?
(a) Normal
(b) Percentage
(c) Currency
(d) Comma
48. Which of the following options changes the fill color of an object back to the default color?
(a) Template
(b) Automatic
(c) Patterns
(d) Fill colors
49. Which of the following should you use to add shading to a drawing object on or an auto shape object?
(a) Text box tool
(b) Line tool
(c) Fill color
(d) B and c
50. Which of the following should be used with the mouse when you want to draw a perfect shape?
(a) The spacebar
(b) The alt key
(c) The ctrl key
(d) The shift key
51. On which part of the chart are the values entered in a data sheet displayed?
(a) The title area
(b) The legend
(c) The y-axis
(d) The x-axis
52.In order to edit a chart, you can
(a) triple click the chart object
(b) click and drag the chart object
(c) double click the chart object
(d) click the chart objects
53. When an image is selected, it displays which of the following?
(a) Two corner handles
(b) Six middle handles
(c) Eight sizing handles
(d) Six boxes
54. The maximum zoom percentage in Microsoft PowerPoint is
(a) 100%
(b) 200%
(c) 400%
(d) 500%
55. PowerPoint 2000 has....... Number of views
(a) 3
(b) 4
(c) 5
(d) 6
56. Press animation effects allows you to
(a) Add clip art images to your slides
(b) Create a custom transition to the next
slide
(c) Show bullet items as they are
discussed
(d) None
57. A file which contains readymade styles that can be used for a presentations is called
(a) Auto style
(b) Template
(c) Wizard
(d) Pre-formatting
58. Which key deletes text before, or the left of, the insertion point?
(a) Backspace
(b) Page up
(c) Delete
(d) Page down
59. Which of the following is not a transition effect?
(a) Blinks diagonal
(b) Dissolve
(c) Fade through black
(d) Blinds vertical
60. to save a presentation you
(a) click save on the windows start button
(b) press Ctrl + F5
(c) select File, Save from the menu
(d) click the saver button on the formatting toolbar
61. To change font size of a selected slide title, you?
(a) Click the toolbars font dropdown arrow and choose the font you prefer
(b) Click format, title and choose a font from the font tab
(c) Click the toolbar's increase font size
button
(d) Click title, new font, ok.
62. To insert a new slide in the current
presentation, we can choose
(a) Ctrl + M
(b) Ctrl + N
(c) Ctrl + O
(d) Ctrl + F
63. Microsoft PowerPoint is a
(a) Database program
(b) Spreadsheet program
(c) Presentation program
(d) Word processing program
64. What is the name of the form used to input chart values?
(a) Datasheet
(b) Microsoft Excel
(c) Microsoft graph
(d) Auto form
65. Right clicking something in PowerPoint
(a) Deletes the object
(b) Selects the object
(c) Opens a shortcut menu listing for the
Object
(d) Nothing he right mouse button for
operation
66. After choosing a predefine template,
change a option has to be chosen to
background color
(a) Design template
(b) Color scheme
(c) Animation scheme
(d) Color effects
67. Ellipse Motion is a predefined ....
(a) Design template
(b) Color scheme
(c) Animation scheme
(d) None
68. Block arrows, stars and banners, and
callouts are all examples of
(a) Different types of children's building
blocks
(b) Auto Shape categories
(c) Clip art categories located in the
Microsoft Clip Gallery
(d) More technical terms that I don't
understand
69. We can replace a font on all slides with another font using the .... option
(a) Edit, Fonts
(b) Tools, Fonts
(c) Tools, Replace Fonts
(d) Format, Replace Fonts
70. Special effects used to introduce slides in a presentation are called
(a) Effects
(b) Custom animations
(c) Transitions
(d) Preset animations
71.PowerPoint can display data from which of the following add-in software of MS-Office
(a) Equation editor
(b) Organization chart
(c) Photo album
(d) All of these
72. Which key on the keyboard can be used to view slide show
(a) F1
(b) F2
(c) F5
(d) F10
73. Which of the following fill effects can you use for the slide background?
(a) Gradient
(b) Texture
(c) Picture
(d) All of above
74. A chart can be put as a part of the
presentation using
(a) Insert -> Chart
(b) Insert -> Pictures -> Chart
(c) Edit -> Chart
(d) View -> Chart
75. The arrangement of elements such as Title and Subtitle text, pictures, tables etc. is called
(a) Layout
(b) Presentation
(c) Design
(d) Scheme
76. Which of the following are types of sound files?
(a) LOG files
(b) DAT files
(c) WAV files
(d) DRV files
77. Which of the following can you use to add times to the slides in a presentation?
(a) Microsoft graph
(b) Microsoft Table
(c) Microsoft Excel
(d) Microsoft Word
78. Which view in PowerPoint can be used to enter speaker comments?
(a) Normal
(b) Slide show
(c) Slide sorter
(d)Notes page view
79. The boxes that are displayed to indicate that the text, pictures or objects are placed in it is called ....
(a) Placeholder
(b) Auto text
(c) Text box
(d) Word art
80. In which menu can you find features like Slide Design, Slide Layout etc.?
(a) Insert Menu
(b) Format Menu
(c) Tools Menu
(d) Slide Show Menu
81. Which menu provides you options like
Animation Scheme, custom Animation, Slide Transition?
(a) Insert Menu
(b) Format Menu
(c) Tools Menu
(d) Slide Show Menu
82. Which tab is not available on left panel when you open a presentation?
(a) Outline
(b) Slides
(c) Notes
(d) All of above
MS ACCESS
1.What are the different views to display a
table?
(a) Datasheet view
(b) Design view
(c) Pivoted table & pivot chart view
(d) All of above
2. Which of the following creates a drop down list of values to choose from?
(a) Ole object
(b) Hyperlink
(c) Memo
(d) Lookup wizard
3. The command center of access file that
appears when you create or open the ms
access database file.
(a) Database window
(b) Query window
(c) Design view window
(d) Switchboard
4.The third stage in designing a database is when we analyze our tables more closely and create a__between tables
(a) Relationship
(b) Join
(c) Query
(d) None
5. In a database table, the category of
information is called
(a) Tuple
(b) Field
(c) Record
(d) All of Above
6. This key uniquely identifies each record
(a) Primary Key
(b) Key Record
(c) Unique Key
(d) Field Name
7. It is an association established between common
(a) Line
(b) Relationship
(c) Primary key
(d) Records
8.This is the stage in database design where one gathers and list all the necessary fields for the database project.
(a) Data Definition
(b) Data Refinement
(c) Establishing Relationship
(d) None
9. A database language concerned with the definition of the whole database structure and schema is
(a) DCL
(b) DML
(c) DDL
(d) All of Above
10. Which of the field has width 8 bytes?
(a) Memo
(b) Number
(c) Date/time
(d) Hyperlink
11. Following is not a database model
(a) Network Database Model
(b) Relational Database Model
(c) Object Oriented Database Model
(d) None
12. DCL provides commands to perform actions like
(a) Change the structure of tables
(b) Insert, update or delete records and data values
(c) Authorizing access and other control
over database
(d) None
13. Which of the following is not a database object?
(a) Tables
(b) Queries
(c) Relationships
(d) Reports
14. A enables you to view data from a table based on a specific criterion
(a) Form
(b) Query
(c) Macro
(d) Report
15. What are the columns in a Microsoft access table called?
(a) Rows
(b) Records
(c) Fields
(d) Columns
16. This form displays multiple records, one per row, in the Form window
(a) Datasheet
(b) Tabular
(c) Columnar
(d) Justified
17. What is the maximum length a text field can be?
a) 120
b) 255
c) 265
d) 75
18. Which of the following is not a database object?
a) Tables
b) queries
c) Relationships
d) Reports
19. Which of the following database object produces the final result to present?
a) Forms
b) Reports
c) queries
d) Tables
20. Which of the following is a method to create a new table in ms access?
a) Create table in design view
b) Create table using wizard
c) Create table by entering data
d) All of Above
21.To create a new table, in which method you don't need to specify the field type and size?
a) Create table in design view
b) Create table using wizard
c) Create table by entering data
d) All of above
22.When creating a new table which method can be used to choose fields from standard databases and tables?
a) Create table in design view
b) Create table using wizard
c) Create table by entering data
d) None
23.In table design view, which key can be
used to switch between the field names and properties panels?
a) F3
b) F4
c) F5
d) F6
24. table design view what are the first
column of buttons used for
a) Indicate primary key
b) Indicate current row
c) Both of above
d) None
25.The default and maximum size of text field access
a) 50 and 255 characters
b) 8 and 1 GB
c) 266 characters & 64000 characters
d) None
26.The size of yes no field is always
a) 1 Bit
b) 1 Byte
c) 1 Character
d) 1 GB
27.Which of the following is not a field type in access
a) Memo
b) Hyperlink
c) Ole Object
d) Lookup Wizard
28.The size of a field with number data type can not be
a) 2
b) 4
c) 8
d) 16
29.Which field type will you select when
creating a new table if you require to enter
long text in that field?
a) Text
b) Memo
c) Currency
d) Hyperlink
30.Which Of The Following Creates A Drop Down List Of Values To Choose from?
a) Ole Object
b) Hyperlink
c) Memo
d) Lookup Wizard
31.The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File.
a) Database Window
b) query Window
c) Design View Window
d) Switchboard
32 This key uniquely identifies each record
a) Primary key
b) Key Record
c) Unique Key
d) Field Name
33. It is an association established between common
a) Line
b) Relationship
c) Primary key
d) Records
34. Which of the field has width 8 bytes?
a) Memo
b) Number
c) Date/time
d) Hyperlink
35.Microsoft access is a
a) RDBMS
b) OODBMS
c) ORDBMS
d) Network Database Model
36.When entering field name, how many
characters you can type in maximum?
a) 60
b) 64
c) 68
d) Any number of character
37.A _ name must be unique within a
database
a) Table
b) Field
c) Record
d) Character
38.The expression builder is an access tool for entering that controls an expression an expression
a) Table
b) Box
c) Cell
d) Palette
39.Unlike text data type, this can store up to maximum of 65, 535 characters.
a) memo
b) data/time
c) number
d) All above
40.It is a sign or symbol that specifies,
operator, and values that produce a result
a) operator
b) query
c) expression
d) None of above
41.Which of the following database object is created first before any other created?
a) Table 
b) Form
c) Report
d) query
42.This type of database contains multiple tables that are connected to produce combined output from all tables.
a) Bound
b) Linked
c) Relational
d) Joined
43.The 'Filter by selection allows you to filter those records
a) That match the selected field
b) That match the criteria specified
c) That meet any of several criteria
specified
d) All of aboThe
44.The operation of checking input data
against specified criteria is known as?
a) Data Verification
b)Data Validation
c) Cross Check
d)Data Control
45.Database access levels are specified so as to define who can access what in a database. It is identified through
a) User ID
b) Password
c) Status
d) None
46.What it is called to present information in a  order based on numeric alphabetical value?
a) Sorting
b) Searching
c) Arranging
d) Cropping
47.A collection of related records in database known as a
a) Table
b) Database
c) File
d) None
48.A part of database that stores complete information about an entity such as sales, orders etc.
a) File
b) Record
c) Field
d) query
49.To create this, you enter an expression in the design grid that instructs Access to
perform a calculation using the current field values.
a) Formulated field
b)Numeric field
c) Formula field
d)Calculated field
50.The ascending order of data hierarchy is?
a) Bit - Byte - Field - Record - File -
Database
b) Bit - Byte - Record - Field - File -
Database
c) Byte - Bit - Field - Record - File -
Database
d) Bit - Byte - Field - Record - Database -
File
51.How can you define a field so that when entering data for that field it will display instead of actual typed text
a) Input Mask
b) Validation Rule
d) Indexed
c) IME Mode
52.Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command?
a) File menu
b) View Menu
c) Database Menu
d) Tools Menu
53.Which of the following is not a type of
relationship that can be applied in Access
database
a) One to One
b) One to Many
c) Many to Many
d) All of above
54.To create relationship between two tables
a) drag the primary key of a table into
foreign key of another table
b) drag the foreign key of a table into the
primary key of another table
c) drag any field from parent table and
drop on child table
d) Any of above can be done to create
relationship
MS EXCEL
1.MS Excel is an....... Software.Application software Ms Excel is used to create
(a) Calculation based files
(b) Create charts
(c) Format cells
(d) All of these
2.by default there are..... worksheets in Ms Excel
(a) Two
(b) Four
(c) Three
(d) Five
3. Number of rows in Ms Excel 2003
(a) 270
(b) 280
(c) 256
(d) 274
4.Number of columns in Ms Excel 2003
(a) 16,000
(b) 15,000
(c) 17,000
(d) 20,000
5........ bar identifies the file name and
application program
(a) Title bar
(b) Menu bar
(c) Toolbar
(d) Scroll bar
6.By default number of rows in Ms Excel 2007 are
(a) 60,000
(b) 65,536
(c) 70,000
(d) 10,000
7.By default number of columns in Ms Excel are
(a) 10,48,576
(b) 10,50,776
(c) 11,50,776
(d) 12,50,776

for more detail click on this link

https://techvarieties.com/

Post a Comment

0 Comments