DCSA---Office Automation--1302(MCQ)
Page 01-18
Unit 1 Lesson 1
MCQ Answer: A-ii, B-ii, C-i (Page-05)
MCQ Answer: A-ii, B-ii, C-i (Page-05)
Unit 1 Lesson 2
MCQ Answer: A-i, B-iii, C-ii, D-iii, E-I, F-i, G-iv (Page-11, 12)
MCQ Answer: A-i, B-iii, C-ii, D-iii, E-I, F-i, G-iv (Page-11, 12)
Unit 1 Lesson 3
MCQ Answer: A-i, B-ii, C-ii (Page-18)
MCQ Answer: A-i, B-ii, C-ii (Page-18)
Computer Programming (1303);
Page 01-23
Page 01-23
Unit 1 Lesson 1
MCQ Answer: 1-D, 2-A, 3-A (Page-04)
MCQ Answer: 1-D, 2-A, 3-A (Page-04)
Unit 1 Lesson 2
MCQ Answer: 1-C, 2-A, 3-C, 4-C, 5-A (Page-07)
MCQ Answer: 1-C, 2-A, 3-C, 4-C, 5-A (Page-07)
Unit 2 Lesson 3
MCQ Answer: 1-A, 2-D, 3-A (Page-16)
MCQ Answer: 1-A, 2-D, 3-A (Page-16)
Unit 2 Lesson 4
MCQ Answer: 1-D, 2-B, 3-A (Page-23).
MCQ Answer: 1-D, 2-B, 3-A (Page-23).
Automation -MCQ -By
Mahfuzur Rahman
Unit-1
Leson-1
a. The use of office automation technology made prices lower
by
i) 10 to 20 percent
ii) 10 to 30 percent
iii) 30 to 40 percent
iv) 45 to 65 percent.
b. Office automation
facilitates the task of
i) officers
ii) managers
iii) clerks
iv) peons.
c. Operating cost per hour of work declines with the use
of
i) office automation technology
ii) computer
controlled robot
iii) hand-made tools
iv) electronic-mail
system.
Leson-2
a. An office is primarily concerned with
i) the records of the
organization
ii) the files of the organization
iii) the letters of the organization
iv) the memos of the organization.
b. The secondary functions may be divided into
i) 3 categories
ii) 4 categories
iii) 5 categories
iv) 7
categories.
c. Office automation is a process that involves
i) people, paper and procedure
ii) people, procedure
and technology
iii) man, machine and management
iv) people, procedure
and production.
d. Increased productivity, greater accuracy, lower clerical
cost and ease of operations are the benefits of
i) offices
ii) organization
iii) office
automation
iv) planning.
e. Monotonous job specialization can lead to
i) boredom, frequent errors, high personnel turnover and high training cost
ii) boredom, frequent
errors, low personnel turnover and high training cost
iii) boredom, non
frequent errors, high personnel turnover and low training cost
iv) boredom, frequent errors, high personnel
turnover and low training cost.
f. Clerical employees have often been
i) displaced by computers
ii) honored by
computers
iii) rewarded by
computers
iv) dishonored by
computers.
g. Overvalued representation could be used in
i) data manipulation
ii) criminal manipulation
iii) file
manipulation
iv) record
manipulation.
Leson-3
a. An office is primarily concerned with
i) the records of the
organization
ii) the files of the organization
iii) the letters of
the organization
iv) the memos of the organization.
b. The secondary functions may be divided into
i) 3 categories
ii) 4 categories
iii) 5 categories
iv) 7
categories.
c. Office automation is a process that involves
i) people, paper and procedure
ii) people, procedure
and technology
iii) man, machine and
management
iv) people, procedure and production.
d. Increased productivity, greater accuracy, lower clerical
cost and ease of operations are the benefits of
i) offices
ii) organization
iii) office
automation
iv) planning.
e. Monotonous job specialization can lead to
i) boredom, frequent errors, high personnel turnover and high training cost
ii) boredom, frequent errors, low personnel turnover and
high training cost
iii) boredom, non frequent errors, high personnel
turnover and low training cost
iv) boredom, frequent errors, high personnel
turnover and low training cost.
f. Clerical employees have often been
i) displaced by computers
ii) honored by
computers
iii) rewarded by
computers
iv) dishonored by computers.
g. Overvalued representation could be used in
i) data manipulation
ii) criminal
manipulation
iii) file
manipulation
iv) record
manipulation.
Unit-2
Leson- 1
a. Data processing is done mostly on
i) words
ii) numerical data
iii) letters
iv) logical data.
b. Errors are relatively easy to locate in
i) data processing
ii) word processing
iii) centralized
processing
iv) decentralized
processing.
c. A local Area
Network (LAN) is a communication system that links together the devices located
in a
i) large area
ii) very large area
iii) small area
iv) wide large
area.
d. Optical character readers (OCRs) scan the text
optically
i) word by word
ii) page by page
iii) character by
character
iv) sentence by
sentence.
e. OCRs can read at a rate up to
i) 400 characters per second
ii) 1400 characters
per second
iii) 2400 characters per second
iv) 2400 characters
per minutes.
f. Automatic paper feeding and copy counter are the features
of
i) Photocopiers
ii) OCRs
iii) Electronic printer
iv) Duplicators.
g. An electronic typewriter can store
i) 100 or fewer pages in its main memory
ii) 200 or fewer pages in its main memory
iii) 300 or fewer pages in its main memory
iv) 400 or fewer
pages in its main memory.
Leson-2
a. A word processor consist of
i) 2 hardware components
ii) 3 hardware
components
iii) 4 hardware
components
iv) 5 hardware components.
b. Which of the
following hardware configurations are
relatively easy to implement in the office environment.
i) shared-logic systems
ii) stand-alone
systems
iii) shared-resource systems
iv) time-sharing systems.
c. Better response time and higher reliability of operations
are provided by
i) shared-resource
systems
ii) shared-logic systems
iii) distributed-logic system
iv) time-sharing
system.
d. A terminal containing own processor and memory is
called
i) dumb terminal
ii) intelligenttermina
l iii) virtual
terminal
iv) CRT
terminal.
Leson-3
a. Creating documents
for reproduction by means of photographic characters onto film is called
i) phototypesetting
ii) photo-composition
iii) electronic printing
iv) electronic filing.
b. Phototypesetting was invented in the
i) 1900s
ii) 1905s
iii) 1910s
iv) 1920s.
c. An electronic printer usually copy and print
i) 5 to 15 pages per minute
ii) 15 to 20 pages per minute
iii) 35 to 50 pages per minute
iv) 35 to 50 pages per second
Leson-4
a. Electronic mail is a system that delivers massages
at
i) typing speed
ii) printing speed
iii) electronic speed
iv) processing
speed.
b. One major advantage of e-mail over telephone is that
i) sending party does not have to be present
ii) receiving party
does not have to be present
iii) receiving and sending party does not have to
be present
iv) both party have to be present.
c. Registered mail is an idea to allow the originator to
know that
i) his message has not arrived
ii) his message has
arrived
iii) his message has
been received
iv) his message has
been sent.
d. What do you mean by CMS ?
i) Central Message System
ii) Computerized
Message Switching
iii) Central Message Switching
iv) Computerized
multi-tasking Syste
Leson-5
a. Exact and high resolution reproduction are provided
by
i) e-mail
ii) micro-graphics
iii) facsimile
iv) e-filing.
b. Digital facsimiles are
i) much faster than analog systems
ii) slower than
analog systems
iii) same as analog systems
iv) none of the above.
c. The facsimile equipment may be divided into
i) 2 types
ii 3 types
iii) 4 types
iv) 5 types.
d. Central unit of
facsimile equipment is capable of transmitting a business letter in
i) less than one
minute
ii) less than 20 seconds
iii) less than 30
seconds
iv) more than 30 seconds.
e. Microforms are the
i) processed input
ii) processed output
iii) printed output
iv) incomplete output.
f. CAR stands
for
i) Computer Address
Register
ii) Computer Assisted
Retrieval
iii) Computer Aided Retrieval
iv) Central Address
Register.
g. COM stands
for
i) Computer Output
Microfilm
ii) Computer Output Microfiche
iii) Computer Oriented Microfilm
iv) Computer
Originated Mail.
Leson-6
a. Digital voice is the recording of voice messages in
i) analog form
ii) digital form
iii) written form
iv) printed
form.
b. Centralized dictation is a system that can
simultaneously
i) send dictation
ii) receive dictation
iii) transform dictation
iv) change dictation.
c. Which of the following has a database containing a large
number of text messages?
i) Teleconferencing
ii) Computerized
teleconferencing
iii) Digital voice
iv)
Micrographics.
d. Which of the following two languages are supported by
COM developed by Stockholm
university?
i) French and English
ii) Swedish and English
iii) Arabic and English
iv) English and
Bengali.
e. The COM system of Stockholm university using English
language has about
i) 500 members from
a dozen countries
ii) 1000 members
from a dozen countries
iii) 1500 members
from a dozen countries
iv) 2500 members from
a dozen countries
UNIT-7
Leson-1
a. Which spreadsheet program was developed first?
i) Lotus 1-2-3
ii) PeachCalc
iii) VisiCalc
iv) Microsoft Excel.
b. Which pair of individuals is most closely associated with
the development of the first spreadsheet ?
i) Woznick and Jobs
ii) Bricklin and Frankston
iii) Burns and Allen
iv) Boole and Babbage.
c. An electronic spreadsheet is superior to manual
calculations because:
i) The spreadsheet computes faster
ii) The spreadsheet
computes its results more accurately
iii) The spreadsheet
automatically recalculates whenever any data are changed
iv) all of the above
Leson2
a. Which of the
following is not a part of the Excel window?
i) Toolbar
ii) Chart
iii) Worksheet
iv) Cell.
b. The Excel
worksheet size is
i) 256 row × 8192 column
ii) 256 column × 8192 row
iii) 256 row × 16384
column
iv) 256 column × 16384 row.
c. The column number
of the 35th column is
i) Z9
ii) A35
iii) AI
iv) None of the above
Leson-3
a. A formula begins
with
i) =
ii) ×
iii) +
iv) -.
b. Arithmetic operators perform basic
i) mathematical
operations
ii) logical operation
iii) boolean
operation
iv) none of the
above
Leson-7
a. The Custom
Header/Footer window contains
i) 2 sections
ii) 3 sections
iii) 4 sections
iv) none of the above.
b. Which of the
following are shown when a numeric entry do not fit in the cell?
i) a series of $ $ $
ii) a series of # # #
iii) a series of % % %
iv) none of the above
Leson-9
a. A chart is
a
i) Graphic
representation of worksheet data.
ii) Bitmap representation of worksheet data.
iii) Character representation of worksheet data.
iv) None of the
above.
b. How many types of chart are there in
Excel?
i) 6
ii) 9
iii) 15
iv) 25.
UNIT-8
Leson-8.1
a. Pieces of
information called
i) data
ii) database
iii) DBMS
iv) none of the
above.
b. Accuracy of the
data ensures.
i) data integrity
ii) data definition
iii) data manipulation
iv) data
maintenance.
c. Which one is a
free database system?
i) Oracle
ii) Microsoft SQL server
iii) Sybase
iv) MySQL
Leson-8.2
a. Table is a
set
i) columns
ii) rows
iii) columns and
rows
iv) field.
b. File extension of Microsoft Access
database
i) .mdb
ii) .dbf
iii) .txt
iv) .exe
c. The core
component of database is
i) table
ii) form
iii) report
iv) query.
Leson-8.3
a. Which one is the
foundation of an Access Database?
i) tables
ii) forms
iii) queries
iv) none of the
above.
b. Memo data type can
store
i) up to 64,000
characters
ii) up to 44,000 characters
iii) up to
60,000 characters
iv) up to 6,000 characters
UNIT-9
Leson-9.1
a. Each time you
apply a filter to a column.
i) it replaces any
previous filter you applied to that column.
ii) it does not replaces any previous filter you
applied to that column.
iii) it replaces
record.
iv) none of the above.
b. You can apply a filter to see.
i) only records which you want to view.
ii) only field which you want to view.
iii) only table which you want to view.
iv) none of the
above.
c. When sorting
records you can view.
i) a column of information.
ii) one record of
information.
iii) all record of information.
iv) a column of
information in order
Leson 9.2
a. An index helps to
find and sort records.
i) faster
ii) slower
iii) similar
iv) none of the above.
b. Which one is the
most common type of relationship?
i) one to many
relationship
ii) one to one
relationship
iii) many to many relationship
iv) two to one
relationship.
c. You can create
indexes based on.
i) a single field
ii) on multiple fields
iii) bothi and ii
iv) none of the above
UNIT-10
Leson 10.1
a. How many types of
queries have in Microsoft Access?
i) 4
ii) 5
iii) 6
iv) 3.
b. Which query allow
many records to be changed at one time instead of single record
i) action query
ii) select query
iii) parameter query
iv) crosstab query.
Leson 10.2
a. Which format
returns all records that end with the value you enter?
i) like
"*" & [Prompt] & "*"
ii) like
"*" & [Prompt]
iii) like [Prompt] & "*"
iv) > [Prompt].
b. How you can create a parameter query?
i) by enclosing a
question in []
ii) by enclosing a question in ()
iii) by enclosing a question in {}
iv) none of the above
Leson 10.3
a. Selection
criteria are
i) case sensitive
ii) not case
sensitive
iii) any one of the
above.
iv) none of the above.
b. Like
"J?m" finds which three character
i) Jim
ii) jam
iii) joy
iv) bothi and ii.
Unit -11
Leson-11.1
a. Navigation button
is visible
i) design time
ii) form view
iii) bothi and ii
iv) none of the above.
b. Which control
display a list of items from which you can select one?
i) list Box
ii) check box
iii) picturebix
iv) shape control.
c. Field in each
record appear in row and column format with one record in each row and one
field in each column
i) autoform columnar
ii) autoform tabular
iii) autoform
datasheet
iv) autoform PivotTable
Leson 11.2
a. Each field
appears on a separate line with a label to its left
i) autoReport:
Columnar
ii) autoReport:
Tabular
iii) autoReport: Datasheet
iv) none of the
above.
b. Report must have a
i) detail section
ii) page header section
iii) page footer section
iv) report header.
Leson 11.3
a. Generally which
control is used for separating different types of data?
i) line
ii) rectangle
iii) list box
iv) bothi and
ii
b. To calculate a
grand total for all records in a report add text box to the
i) header of a report
ii) footer of a report
iii) header or
footer of a report
iv) page header of a
report
Comments
Post a Comment