PassEveryTest
Tagalog

Microsoft Office Specialist: Excel Exam Preparation: Manage charts

Quiz sa paksa na walang limitasyon sa oras: 15 tanong tungkol sa Manage charts, may paliwanag pagkatapos ng bawat sagot. Binabago ang ayos ng mga tanong at sagot sa bawat pagkakataon.

  • Kurso
  • Canada
  • 90 tanong
  • Sinuri noong Oktubre 13, 2026
  • Na-fact-check noong Oktubre 13, 2026
Magsimula sa mga aralinMicrosoft Office Specialist: Excel Exam Preparation: Lessons: mga 300 minutong pagbasa. Saklaw ng mga aralin ang bawat tanong sa pagsusulit.

Quiz sa paksa 5: Manage charts

  1. Tanong 1 ng 15

    Which command suggests chart types that fit the data you selected?
    Ipakita ang sagot

    Sagot: D. Insert > Recommended Charts

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

  2. Tanong 2 ng 15

    You want to show how one budget is split into five parts. Which chart type fits best?
    Ipakita ang sagot

    Sagot: A. Pie

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

  3. Tanong 3 ng 15

    You want to show how monthly incidents changed over 12 months. Which chart type fits best?
    Ipakita ang sagot

    Sagot: C. Line

    Line charts are good for showing a trend over time.

  4. Tanong 4 ng 15

    What is a chart sheet?
    Ipakita ang sagot

    Sagot: D. A sheet that holds only a chart

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

  5. Tanong 5 ng 15

    A chart sits on the worksheet. How do you move it to its own new chart sheet?
    Ipakita ang sagot

    Sagot: 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. Tanong 6 ng 15

    You select a data range and press F11. What happens?
    Ipakita ang sagot

    Sagot: 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. Tanong 7 ng 15

    Where is the Switch Row/Column button?
    Ipakita ang sagot

    Sagot: B. Chart Design tab, Data group

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

  8. Tanong 8 ng 15

    What does Switch Row/Column change?
    Ipakita ang sagot

    Sagot: 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. Tanong 9 ng 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
    1RehiyonJanFebMarAprMayJun
    2North101112131415
    3South131415161718
    4East161718192021
    Ipakita ang sagot

    Sagot: 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. Tanong 10 ng 15

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

    Sagot: 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. Tanong 11 ng 15

    Which button beside a selected chart lets you quickly add data labels or axis titles?
    Ipakita ang sagot

    Sagot: B. Chart Elements (the plus sign)

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

  12. Tanong 12 ng 15

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

    Sagot: C. The legend

    The legend matches each series colour to its name.

  13. Tanong 13 ng 15

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

    Sagot: C. Chart Design > Quick Layout

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

  14. Tanong 14 ng 15

    Why do you add alternative text (alt text) to a chart?
    Ipakita ang sagot

    Sagot: 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. Tanong 15 ng 15

    Which alt text is most useful for a chart of monthly incidents?
    Ipakita ang sagot

    Sagot: 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.

Mga kaugnay na pagsusulit