Microsoft Excel 9

81. Hyperlinks can be

a. Text                                                     b. Drawing objects

c. Pictures                                                              d. All of above

82. 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

83. 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

84. 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

85. 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

 86. In a worksheet you can select

a. The entire worksheet                   b. Rows

c. Columns                                                             d. All of the above

87. 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

88. Which area in an excel window allows entering values and formulas

a. Title bar                                                             b. Menu bar

c. Formula bar                                    d. Standard toolbar

89. 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

90. 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