To center worksheet titles across a range of cells, you must select the cells containing the title text plus the range:
- (A) Over which the title text is to be centered
- (B) Widen the columns
- (C) Select the cells containing the title text plus the range over which the title text is to be enfettered
- (D) Format the cells with the comma style
- (A) Over which the title text is to be centered
How do you delete a column?
- (A) Select the column heading you want to delete and select the Delete Row button on the standard toolbar
- (B) Select the column heading you want to delete and select Insert Delete from the menu
- (C) Select the row heading you want to delete and select Edit>Delete from the menu
- (D) Right click the column heading you want to delet and select delete from the shortcut menu
- (D) Right click the column heading you want to delet and select delete from the shortcut menu
How can you find specific information in a list?
- (A) Select Tools > Finder from the menu
- (B) Click the Find button on the standard toolbar
- (C) Select Insert > Find from the menu
- (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
- (B) Click the Find button on the standard toolbar
When integrating word and excel, word is usually the?
- (A) Server
- (B) Destination
- (C) Client
- (D) Both B and C
- (C) Client
When a label is too long to fit within a worksheet cell, you typically must:
- (A) Shorten the label
- (B) Increase the column width
- (C) Decrease the column width
- (D) Adjust the row height
- (B) Increase the column width
The name box:
- (A) Shows the location of the previously active cell
- (B) Appears to the left of the formula bar
- (C) Appears below the status bar
- (D) Appears below the menu bar
- (B) Appears to the left of the formula bar
Comments put in cells are called ________.
- (A) Smart tip
- (B) Cell tip
- (C) Web tip
- (D) Soft tip
- (B) Cell tip
Which is used to perform what if analysis?
- (A) Solver
- (B) Goal seek
- (C) Scenario Manager
- (D) All of above
- (D) All of above
You can use the horizontal and vertical scroll bars to:
- (A) Split a worksheet into two panes
- (B) View different rows and columns edit the contents of a cell
- (C) Edit the contents of a cell
- (D) view different worksheets
- (B) View different rows and columns edit the contents of a cell
Multiple calculations can be made in a single formula using:
- (A) Standard formulas
- (B) Array formula
- (C) Complex formulas
- (D) Smart formula
- (B) Array formula