GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Excel 3

Holly Harper 10 questions

Take the quiz

Questions in this quiz (10)

  1. 1Which of the following is not a true statement when applying shape fill, outline, and effects?
    1. AThe outline for a shape is the border that surrounds or encircles it.
    2. BNot all chart elements are suited to an outline.
    3. CTo remove a shape fill, select the object, and click the No Outline command.
    4. DWhen you add an outline to a chart element, you can select a weight for the line.
  2. 2Which of the following chart types displays the magnitude of change over time and shows the rate of change?
    1. Aarea
    2. BXY
    3. Cstock
    4. Dradar
  3. 3Which of the following statements is not true for printing?
    1. AA chart object can be printed on the page with worksheet data.
    2. BYou can print a chart object on a separate sheet.
    3. CTo print a chart with the data, deselect the current object by clicking a worksheet cell, size and position the chart, and scale the sheet to fit a printed page.
    4. DBy default, a chart sheet prints in portrait orientation.
  4. 4Which of the following chart elements provides a vertical background for a 3D chart?
    1. AChart area
    2. BChart floor
    3. CChart wall
    4. DGridline
  5. 5Which of the following is a chart element that plots patterns using a moving average of the current data?
    1. Atrendline
    2. Bdata label
    3. Cdata table
    4. Dsource data
  6. 6Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values?
    1. AHistogram
    2. BBox & Whisker
    3. CWaterfall
    4. DFunnel
  7. 7Which of the following is not true when working with the Format Task Pane?
    1. AEvery chart element has a Format task pane that consolidates shape, fill, and color options and provides custom commands for the element.
    2. BOne way to open the Format task pane is to double-click the element.
    3. CCommon buttons on the Format task pane include Fill & Line and Effects.
    4. DFormats are applied after you close the Format task pane.
  8. 8Which of the following statements is not true for applying a chart style?
    1. AThe first step is to select the chart object or the chart sheet tab.
    2. BEach chart type has the same number of styles.
    3. CPoint to a style thumbnail to see a Live Preview.
    4. DChart styles may affect the chart layout.
  9. 9Which of the following does not relate to a combination chart?
    1. AA combination chart has at least two data series, each graphed in its own chart type.
    2. BThe purpose of a combination chart is to compare unlike items.
    3. CIn a combination chart, you can display values on two horizontal axes.
    4. DFor the secondary axes, Excel builds the number scale based on the data.
  10. 10Which of the following terms refers to a group of data points or values?
    1. Asource data
    2. Bdata point
    3. Cdata series
    4. Dcategory label

Information

Description
Excel 3 final review
Language
English
Views
10
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?