Multiple Choice Question for Microsoft Excel || 3
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
21 Hyperlinks can be
A. Text
B.
Drawing objects
C. Pictures
D. All of above
22 To activate the previous cell in a pre-selected range, press
A. The
Alt key
B. The Tab key
C. The Enter key
D. None of the above
23 Which button do you click to add up a series of
numbers?
A. The autosum button
B. The Formula button
C. The quicktotal
button
D. The total button
24 When the
formula bar is active, you can see
A. The edit formula button
B. The cancel
button
C. The enter button
D. All of the above
25 To copy formatting from one area in a worksheet and apply it
to another area you would use:
A. The Edit>Copy Format and Edit>Paste Format
commands form the menu.
B. The Copy and Apply Formatting dialog box, located
under the Format>Copy and Apply menu.
C. There is no way to copy and apply
formatting in Excel ? You have to do it manually
D. The Format Painter button
on the standard toolbar
26 In a worksheet you
can select
A. The entire worksheet
B. Rows
C. Columns
D. All of the
above
27 When you link data maintained in an
excel workbook to a word document
A. The word document can not be edit
B.
The word document contains a reference to the original source application
C.
The word document must contain a hyperlink
D. The word document contains a
copy of the actual data
28 Which area in an
excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
29 To hold
row and column titles in place so that they do not scroll when you scroll a
worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze
panes command on the window menu
C. Hold titles command on the edit menu
D.
Split command on the window menu
30 To edit
in an embedded excel worksheet object in a word document
A. Use the excel
menu bar and toolbars inside the word application
B. Edit the hyperlink
C.
Edit the data in a excel source application
D. Use the word menu bar and
toolbars