The Global Open University 2012-1st Year B.C.A Computer Application Global open University of Office Automation - Question Paper

c. hold down the Alt key
d. hold down Ctrl + Shift key
43. what is the AutoSummarize feature
used for in Word 2000
a. It creates a 250 word, 500 word or
1000 word summary of the document
b. It adds Automatic headwers, bold and
italic characters as well as automatic
formatting of the document to provide the
look of a well summarized document
c. It summarizes the statistics of the
document into a report such as total
words, total characters, total pages,
total paragraphs, file size ecs
d. It identifies the key points in a
document for your to share with others
or quickly scan
44. A certain spreadsheet indicates in Page
Break Preview that cells in Rows 1-25
have white background. The cells in
row 26 that contain data have a dark
grey background, when you click the
Print button…..
a. Nothing will print because a few cells
with data have been omitted
b. Only the cells with gray background will
print
c. The whole sheet will print
d. Only the cells with white background
will print
45. A constant is a different name for this
kind of data:
a. Number
b. formula
c. Formula
d. Description
46. The view that puts a blue a blue line
around every page that would be
printed is the …..
a. Print Preview
b. Normal View
c. Page Break Preview
d. Split View
47. AutoCalculate will quickly add
opted cells if you…..
a. Right click on the status bar and choose
Sum
b. Click the AutoCalculate button on the
toolbar
c. Use the key combination Ctrl+$
d. Double click the selection
48. The cell tagged 23. 54 the cell tagged
F5 refers to
a. Row F column 5
b. Column F row 5
c. F unction available in cells
d. function key F4
49. when you are typing an formula into
a cell the 1st thing that must be
entered is
a. The 1st cell referenced
b. Parenthesis
c. Quotation marks
d. An equal sign
50. Using the AutoSum button will
change in the opted cell….
a. The sum of values in the cell's column
b. Nothing until you choose a range of cells
c. The sum of the cell's row unless you
change the range
d. A formula which will add values in the
range Excel guesses you want to add
51. Book1 is an example of how … are
numbered and named during every
work session
a. Active cell
b. Formula bar
c. Menu bar
d. Name box
52. Which of the subsequent displays the
contents of the active cell?
a. Active cell
b. Formula bar
c. Menu bar
d. Name box
53. Graphics objects on a chart are used
to
a. Add emphasis to chart data
b. Add interest to a chart
c. Help discuss the chart data
d. a, b, and c
54. What does SUMIF function do?
a. Adds up cell values based on a
condition
b. Adds all the numbers in a range of cells
c. Returns a subtotal in a list or database
d. All of above
55. You can insert tags for
a. All the data markers on a chart
b. A data series
c. A opted data marker
d. All
56. Tab scrolling buttons
a. Allow you to view a various worksheet
b. Allow you to view additional worksheet
row down
c. Allow you to view additional worksheet
columns to the right
d. Allow you to view additional sheet tabs
57. All macro keyboard shortcuts include
the ….. key
a. Alt
b. Ctrl
c. F11
d. Shift
58. To open the Format Cells dialog box,
press
a. Alt + 1
b. Ctrl + 1
c. Ctrl + Shift + 1
d. F1
59. You can add a hyperlink to your
worksheet by pressing
a. Alt + K
b. Ctrl + H
c. Ctrl + K
d. Ctrl + Shift + K
60. To move to the previous worksheet,
press
a. Alt + PgUp
b. Ctrl + PgUp
c. Ctrl + PgDn
d. Shift + Tab
61. elaborate The various Views To
Display A Table
a. Datasheet View
b. Design View
c. Pivote Table & Pivot Chart View
d. All Of Above
62. Which Of The subsequent Creates A
Drop Down List Of Values To select
From?
a. Ole Object
b. Hyperlink
c. Memo
d. Lookup Wizard
63. 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
64. The 3rd Stage In Designing A
Database Is When We Analyze Our
Tables More Closely And Create A
___________ ranging from Tables
a. Relationship
b. Join
c. Query
d. None Of These
65. In A Database Table, The Category Of
info Is Called
a. Tuple
b. Field
c. Record
d. All Of Above
66. This Key Uniquely Identifies every
Record
a. Primary Key
b. Key Record
c. Unique Key
d. Field Name
67. It Is An Association Established
ranging from Common
a. Line
b. Relationship
c. Primary Key
d. Records
68. This Is The Stage In Database Design
Where 1 Gathers And List All The
Necessary Fields For The Database
Project.
a. Data Definition
b. Data Refinement
c. Establishing Relationship
d. None Of The Above
69. 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
70. Which Of The Field Has Width 8
Bytes?
a. Memo
b. Number
c. Date/time
d. Hyperlink

Earning:   Approval pending.