Holly Harper
Quiz von , erstellt am more than 1 year ago

Excel 3 final review

8
0
0
Holly Harper
Erstellt von Holly Harper vor fast 4 Jahre
Schließen

Excel 3

Frage 1 von 10

1

Which of the following is not a true statement when applying shape fill, outline, and effects?

Wähle eine der folgenden:

  • The outline for a shape is the border that surrounds or encircles it.

  • Not all chart elements are suited to an outline.

  • To remove a shape fill, select the object, and click the No Outline command.

  • When you add an outline to a chart element, you can select a weight for the line.

Erklärung

Frage 2 von 10

1

Which of the following chart types displays the magnitude of change over time and shows the rate of change?

Wähle eine der folgenden:

  • area

  • XY

  • stock

  • radar

Erklärung

Frage 3 von 10

1

Which of the following statements is not true for printing?

Wähle eine der folgenden:

  • A chart object can be printed on the page with worksheet data.

  • You can print a chart object on a separate sheet.

  • To 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.

  • By default, a chart sheet prints in portrait orientation.

Erklärung

Frage 4 von 10

1

Which of the following chart elements provides a vertical background for a 3D chart?

Wähle eine der folgenden:

  • Chart area

  • Chart floor

  • Chart wall

  • Gridline

Erklärung

Frage 5 von 10

1

Which of the following is a chart element that plots patterns using a moving average of the current data?

Wähle eine der folgenden:

  • trendline

  • data label

  • data table

  • source data

Erklärung

Frage 6 von 10

1

Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values?

Wähle eine der folgenden:

  • Histogram

  • Box & Whisker

  • Waterfall

  • Funnel

Erklärung

Frage 7 von 10

1

Which of the following is not true when working with the Format Task Pane?

Wähle eine der folgenden:

  • Every chart element has a Format task pane that consolidates shape, fill, and color options and provides custom commands for the element.

  • One way to open the Format task pane is to double-click the element.

  • Common buttons on the Format task pane include Fill & Line and Effects.

  • Formats are applied after you close the Format task pane.

Erklärung

Frage 8 von 10

1

Which of the following statements is not true for applying a chart style?

Wähle eine der folgenden:

  • The first step is to select the chart object or the chart sheet tab.

  • Each chart type has the same number of styles.

  • Point to a style thumbnail to see a Live Preview.

  • Chart styles may affect the chart layout.

Erklärung

Frage 9 von 10

1

Which of the following does not relate to a combination chart?

Wähle eine der folgenden:

  • A combination chart has at least two data series, each graphed in its own chart type.

  • The purpose of a combination chart is to compare unlike items.

  • In a combination chart, you can display values on two horizontal axes.

  • For the secondary axes, Excel builds the number scale based on the data.

Erklärung

Frage 10 von 10

1

Which of the following terms refers to a group of data points or values?

Wähle eine der folgenden:

  • source data

  • data point

  • data series

  • category label

Erklärung