Multiple Choice Question for Microsoft Excel || 11
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
101 You can zoom a worksheet
A. With the mouse pointer in Print Preview
B. With the zoom button on the Print Preview toolbar
C. With the Zoom command
on the view menu
D. All of the above
102 You
can not link Excel worksheet data to a Word document
A. With the right drag
method
B. With a hyperlink
C. With the copy and paste special commands
D.
With the copy and paste buttons on the standard toolbar
103 This type of software is similar to an accountant?s
worksheet
A. Word processing
B. Database
C. Spreadsheets
D. Graphics
104 which function will calculate the number of
workdays between 6/9/2004 and 8/12/2004?
A. Workday
B. Date
C.
Networkdays
D. All of the above
105 Data
marker on a chart are linked to data points in a worksheet, therefore,
A. You
can automatically apply formatting to a data series
B. You can change the
position of a data marker and automatically change the data point value in the
worksheet
C. You can change a data print value and automatically are draw the
chart
D. a and b
106 When you group
worksheets
A. You can enter variable data on multiple worksheets at one
time
B. You can print more than one worksheet at a time
C. You can enter
common data, formats, and formulas on multiple worksheets at one time
D. b,
and c
107 You can use the format painter
multiple times before you turn it off by
A. You can use the format painter
button only one time when you click it
B. Double clicking the format painter
button
C. Pressing the Ctrl key and clicking the format painter button
D.
Pressing Alt key and clicking the format painter button
108 The default header for a worksheet is
A. Your name
B. The
date and time
C. None
D. The sheet tab name
109 To drag a selected range of data to another worksheet in the same
workbook, use the
A. Tab key
B. Alt key
C. Shift key
D. Ctrl key
110 When creating a vertical page break
A. The
active cell must be A1
B. The active cell can be anywhere in the worksheet
C.
The active cell must be in row 1
D. The active cell must be in column A