PassEveryTest
Tagalog

Excel for Beginners Course: Charts, printing and sharing

Quiz sa paksa na walang limitasyon sa oras: 16 tanong tungkol sa Charts, printing and sharing, may paliwanag pagkatapos ng bawat sagot. Binabago ang ayos ng mga tanong at sagot sa bawat pagkakataon.

  • Kurso
  • Canada
  • 100 tanong
  • Sinuri noong Oktubre 13, 2026
  • Na-fact-check noong Oktubre 13, 2026
Magsimula sa mga aralinExcel for Beginners Course: Lessons: mga 120 minutong pagbasa. Saklaw ng mga aralin ang bawat tanong sa pagsusulit.

Quiz sa paksa 6: Charts, printing and sharing

  1. Tanong 1 ng 16

    You have selected your data. Which command shows Excel's suggested charts for it?
    Ipakita ang sagot

    Sagot: A. Insert > Recommended Charts

    On the Insert tab, Recommended Charts previews charts that suit your data. All Charts shows every type.

  2. Tanong 2 ng 16

    Which chart type is best for showing how monthly sales went up and down over a year?
    Ipakita ang sagot

    Sagot: A. Line chart

    Line charts show continuous data over time at equal intervals, so they are ideal for trends.

  3. Tanong 3 ng 16

    When is a pie chart a good choice?
    Ipakita ang sagot

    Sagot: D. For one data series that shows parts of a whole

    Use a pie chart for one data series with no negative values and no more than seven categories that make up a whole.

  4. Tanong 4 ng 16

    Your category names are long, such as full job site addresses. Which chart type does Microsoft suggest considering?
    Ipakita ang sagot

    Sagot: C. Bar chart

    Bar charts put categories on the vertical axis, which leaves room for long labels.

  5. Tanong 5 ng 16

    In a column chart, where are the categories (such as months) usually shown?
    Ipakita ang sagot

    Sagot: C. Along the horizontal axis

    A column chart usually shows categories along the horizontal axis and values along the vertical axis.

  6. Tanong 6 ng 16

    You select A1:B7 in the sheet below and insert a basic column chart. How many columns (bars) does the chart show?
    AB
    1MonthSales
    2Jan12400
    3Feb11850
    4Mar13920
    5Apr15100
    6May14480
    7Jun16230
    Ipakita ang sagot

    Sagot: B. 6

    Row 1 holds headings. Rows 2 to 7 hold 6 months of data, so the chart shows 6 columns.

  7. Tanong 7 ng 16

    You chart the sheet below as a column chart. Which month has the tallest column?
    AB
    1MonthSales
    2Jan12400
    3Feb11850
    4Mar13920
    5Apr15100
    6May14480
    7Jun16230
    Ipakita ang sagot

    Sagot: A. Jun

    The tallest column shows the largest value. June has the highest sales (16,230).

  8. Tanong 8 ng 16

    You only want to print A1:F20. After you select A1:F20, what do you choose?
    Ipakita ang sagot

    Sagot: B. Page Layout > Print Area > Set Print Area

    Set Print Area on the Page Layout tab tells Excel to print only the selected cells.

  9. Tanong 9 ng 16

    You set a print area and save the workbook. What happens to the print area?
    Ipakita ang sagot

    Sagot: C. It is saved with the workbook

    The print area you set is saved when you save the workbook. Use Clear Print Area to remove it.

  10. Tanong 10 ng 16

    Your list prints on 4 pages. Which command lets you print the headings in row 1 at the top of every page?
    Ipakita ang sagot

    Sagot: D. Page Layout > Print Titles

    In Page Layout > Print Titles, enter $1:$1 in Rows to repeat at top. Those rows then print at the top of every page.

  11. Tanong 11 ng 16

    Your worksheet has many columns and they don't fit across the page. What does Microsoft suggest trying?
    Ipakita ang sagot

    Sagot: A. Change to landscape orientation

    If a worksheet has many columns, change the orientation from portrait to landscape.

  12. Tanong 12 ng 16

    On the Page Layout tab you set Scale to Fit: Width 1 page, Height Automatic. What is the result?
    Ipakita ang sagot

    Sagot: A. Columns fit on one page; rows may run onto more

    Width 1 page fits the columns across one page. With Height on Automatic, rows can still continue onto other pages.

  13. Tanong 13 ng 16

    What is a downside of using a scaling option such as Fit Sheet on One Page on a large sheet?
    Ipakita ang sagot

    Sagot: D. The text can become too small to read easily

    Excel shrinks the data to fit, so the printout may be hard to read.

  14. Tanong 14 ng 16

    You want a co-worker to see your workbook but not change it. What do you do when you share it?
    Ipakita ang sagot

    Sagot: B. Share it with editing turned off

    When you share a workbook you choose permissions: let people edit it or only view it.

  15. Tanong 15 ng 16

    Where must a workbook be stored for AutoSave to be on by default in Microsoft 365?
    Ipakita ang sagot

    Sagot: B. OneDrive or SharePoint Online

    AutoSave is on by default for files stored on OneDrive, OneDrive for work or school, or SharePoint Online. It saves every few seconds.

  16. Tanong 16 ng 16

    A teammate made unwanted changes to a shared workbook saved on OneDrive. What can you use to go back to an earlier copy?
    Ipakita ang sagot

    Sagot: A. Version History

    Version History lets you see and restore an earlier version of the file.

Mga kaugnay na pagsusulit