Hyperlinks can be:
- (A) Text
- (B) Drawing objects
- (C) Pictures
- (D) All of above
- (D) All of above
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
- (D) None of the above
Which button do you click to add up a series of numbers?
- (A) The auto sum button
- (B) The Formula button
- (C) The quick total button
- (D) The total button
- (A) The auto sum button
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
- (D) All of the above
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
- (D) The Format Painter button on the standard toolbar
In a worksheet you can select:
- (A) The entire worksheet
- (B) Rows
- (C) Columns
- (D) All of these
- (D) All of these
When you link data maintained in an excel workbook to a word document?
- (A) The word document cannot 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
- (B) The word document contains a reference to the original source application
Which area in an excel window allows entering values and formulas?
- (A) Title bar
- (B) Menu bar
- (C) Formula bar
- (D) Standard toolbar
- (C) Formula bar
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
- (B) Freeze panes command on the window menu
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
- (A) Use the excel menu bar and toolbars inside the word application