PassEveryTest
Nederlands

Microsoft Office Specialist: Excel Exam Preparation: Manage charts

Themaquiz zonder tijdslimiet: 15 vragen over Manage charts, met een uitleg na elk antwoord. Vragen en antwoorden worden elke keer gehusseld.

  • Cursus
  • Canada
  • 90 vragen
  • Gecontroleerd op 13 oktober 2026
  • Feiten gecontroleerd op 13 oktober 2026
Begin met de lessenMicrosoft Office Specialist: Excel Exam Preparation: Lessons: ongeveer 300 minuten leestijd. Elke testvraag wordt in de lessen behandeld.

Themaquiz 5: Manage charts

  1. Vraag 1 van 15

    Which command suggests chart types that fit the data you selected?
    Toon antwoord

    Antwoord: D. Insert > Recommended Charts

    Recommended Charts on the Insert tab previews chart types that suit the selected data.

  2. Vraag 2 van 15

    You want to show how one budget is split into five parts. Which chart type fits best?
    Toon antwoord

    Antwoord: A. Pie

    A pie chart shows the parts of one whole and uses a single data series.

  3. Vraag 3 van 15

    You want to show how monthly incidents changed over 12 months. Which chart type fits best?
    Toon antwoord

    Antwoord: C. Line

    Line charts are good for showing a trend over time.

  4. Vraag 4 van 15

    What is a chart sheet?
    Toon antwoord

    Antwoord: D. A sheet that holds only a chart

    A chart sheet is a separate sheet in the workbook that contains just the chart.

  5. Vraag 5 van 15

    A chart sits on the worksheet. How do you move it to its own new chart sheet?
    Toon antwoord

    Antwoord: C. Chart Design > Move Chart > New sheet

    Move Chart (in the Location group on Chart Design) lets you choose New sheet and type its name.

  6. Vraag 6 van 15

    You select a data range and press F11. What happens?
    Toon antwoord

    Antwoord: C. Excel makes a chart on a new chart sheet

    F11 makes a chart of the selected data on its own chart sheet. Alt+F1 puts the chart on the current worksheet instead.

  7. Vraag 7 van 15

    Where is the Switch Row/Column button?
    Toon antwoord

    Antwoord: B. Chart Design tab, Data group

    Select the chart; the Chart Design tab appears, and Switch Row/Column is in its Data group.

  8. Vraag 8 van 15

    What does Switch Row/Column change?
    Toon antwoord

    Antwoord: A. How the rows and columns are plotted

    Switch Row/Column swaps how the rows and columns are plotted. The worksheet data does not change.

  9. Vraag 9 van 15

    You select A1:G4 (3 regions down column A, 6 months across row 1) and insert a column chart. By default, what goes on the horizontal axis?
    ABCDEFG
    1GewestJanFebMarAprMayJun
    2North101112131415
    3South131415161718
    4East161718192021
    Toon antwoord

    Antwoord: A. The 6 months, with one series per region

    Excel puts the larger group on the horizontal axis. There are more months (6) than regions (3), so the months go across and each region is a series.

  10. Vraag 10 van 15

    Your chart shows 2025 sales. You want to add the 2026 column as a new series. What is one correct way?
    Toon antwoord

    Antwoord: D. Chart Design > Select Data > Add

    Select Data opens a dialog where Add creates a new series from the range you choose. You can also drag the data range outline to include the new column.

  11. Vraag 11 van 15

    Which button beside a selected chart lets you quickly add data labels or axis titles?
    Toon antwoord

    Antwoord: B. Chart Elements (the plus sign)

    Chart Elements (+) turns elements such as Axis Titles, Data Labels, Gridlines and Legend on or off.

  12. Vraag 12 van 15

    A clustered column chart shows three sites in three colours. Which chart element tells the reader which colour is which site?
    Toon antwoord

    Antwoord: C. The legend

    The legend matches each series colour to its name.

  13. Vraag 13 van 15

    You want to apply a ready-made arrangement of title, legend and labels in one click. What do you use?
    Toon antwoord

    Antwoord: C. Chart Design > Quick Layout

    Quick Layout applies a predefined set of chart elements. Chart Styles changes the look (colours and effects).

  14. Vraag 14 van 15

    Why do you add alternative text (alt text) to a chart?
    Toon antwoord

    Antwoord: A. To describe the chart for screen reader users

    Alt text is read aloud by screen readers. You add it by right-clicking the chart and choosing the Alt Text command.

  15. Vraag 15 van 15

    Which alt text is most useful for a chart of monthly incidents?
    Toon antwoord

    Antwoord: A. Column chart: incidents per month in 2026; highest in July (14), lowest in February (3).

    Good alt text says what kind of chart it is and its key message, not just its colours or a default name.

Gerelateerde examens