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