Multiple Choice Question for Microsoft Excel || 10
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
91 The Chart wizard term data categories refers to;
A. A chart plot area
B. A horizontal axis
C. The organization of individual
values with a chart?s data series
D. The data range that supply chart data
92 A worksheet range is a
A. A command used
for data modeling
B. A range of values such as from 23 to 234
C. A group of
cells
D. A group of worksheets
93 Getting
data from a cell located in a different sheet is called
A. Accessing
B.
Referencing
C. Updating
D. Functioning
94
Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you
to view additional worksheet rows down
C. Allow you to view additional
worksheet columns to the right
D. Allow you to view additional sheets tabs
95 A numeric value can be treated as a label
value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash
(#)
D. Ampersand (&
96 Concatenation of text
can be done using
A. Apostrophe (?)
B. Exclamation (!)
C. Hash (#)
D.
Ampersand (&)
97 Data can be arranged in a
worksheet in a easy to understand manner using
A. auto formatting
B.
applying styles
C. changing fonts
D. all of above
98 You can use drag-and-drop to embed excel worksheet data in a
word document
A. By dragging a range of excel data to the word button on the
taskbar while pressing the Ctrl key
B. By dragging a range of excel data to
the word button on the taskbar while pressing Shift key
C. By dragging a range
of excel data to the word button on the taskbar while pressing Alt key
D. None
of above
99 The auto calculate feature
A.
Can only add values in a range of cells
B. Provides a quick way to view the
result of an arithmetic operation on a range of cells
C. Automatically creates
formulas and adds them to a worksheet
D. A and c
100 Excel uniquely identifies cells within a worksheet with a
cell name
A. Cell names
B. Column numbers and row letters
C. Column letters
and row numbers
D. Cell locator coordinates