What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
- (A)Â F3
- (B)Â F5
- (C)Â F7
- (D)Â F11
- (D)Â F11
you can use the formula palette to:
- (A)Â format cells containing numbers
- (B)Â create and edit formulas containing functions
- (C)Â entered assumptions data
- (D)Â copy a range of cells
- (B)Â create and edit formulas containing functions
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed:
- (A)Â Format Report
- (B)Â Pivot Table
- (C)Â Refresh Data
- (D)Â Show Detail
- (C)Â Refresh Data
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
- (A)Â Formula
- (B)Â Field
- (C)Â Data
- (D)Â query
- (A)Â Formula
“tr 1, tr 2, tr 3” is an example of a:
- (A)Â Formula
- (B)Â Function
- (C)Â Series
- (D)Â Syntax
- (C)Â Series
When you see a cell with a red triangle in the top right corner, what does this signify?
- (A)Â There is an error in the cell
- (B)Â There is a comment associated with the cell
- (C)Â The font color for text in the cell is red
- (D)Â A formula cannot be entered into the cell
- (B)Â There is a comment associated with the cell
To hold row and column titles in places 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
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
- (A)Â Use Ctrl to select all three cells, then click the paste button on the standard toolbar
- (B)Â Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
- (C)Â Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
- (D)Â All of above
- (C)Â Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
To edit data 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
Status indicators are located on the:
- (A)Â Vertical scroll bar
- (B)Â Horizontal scroll bar
- (C)Â Formula bar
- (D)Â Formatting toolbar
- (C)Â Formula bar