PassEveryTest
中文

Excel for Beginners Course：Charts, printing and sharing

不限时专题测验：关于Charts, printing and sharing的16道题，每道题作答后都有解释。每次题目和选项都会重新打乱。

  • 课程
  • 加拿大
  • 100道题
  • 核对于2026年10月13日
  • 事实核查：2026年10月13日
从课文开始Excel for Beginners Course: Lessons：阅读时间约120分钟。测试中的每道题在课文中都有讲解。

专题测验6：Charts, printing and sharing

  1. 第1题，共16题

    You have selected your data. Which command shows Excel's suggested charts for it?
    显示答案

    答案: A. Insert > Recommended Charts

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

  2. 第2题，共16题

    Which chart type is best for showing how monthly sales went up and down over a year?
    显示答案

    答案: A. Line chart

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

  3. 第3题，共16题

    When is a pie chart a good choice?
    显示答案

    答案: 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. 第4题，共16题

    Your category names are long, such as full job site addresses. Which chart type does Microsoft suggest considering?
    显示答案

    答案: C. Bar chart

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

  5. 第5题，共16题

    In a column chart, where are the categories (such as months) usually shown?
    显示答案

    答案: C. Along the horizontal axis

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

  6. 第6题，共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
    显示答案

    答案: B. 6

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

  7. 第7题，共16题

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

    答案: A. Jun

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

  8. 第8题，共16题

    You only want to print A1:F20. After you select A1:F20, what do you choose?
    显示答案

    答案: 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. 第9题，共16题

    You set a print area and save the workbook. What happens to the print area?
    显示答案

    答案: 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. 第10题，共16题

    Your list prints on 4 pages. Which command lets you print the headings in row 1 at the top of every page?
    显示答案

    答案: 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. 第11题，共16题

    Your worksheet has many columns and they don't fit across the page. What does Microsoft suggest trying?
    显示答案

    答案: A. Change to landscape orientation

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

  12. 第12题，共16题

    On the Page Layout tab you set Scale to Fit: Width 1 page, Height Automatic. What is the result?
    显示答案

    答案: 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. 第13题，共16题

    What is a downside of using a scaling option such as Fit Sheet on One Page on a large sheet?
    显示答案

    答案: 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. 第14题，共16题

    You want a co-worker to see your workbook but not change it. What do you do when you share it?
    显示答案

    答案: B. Share it with editing turned off

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

  15. 第15题，共16题

    Where must a workbook be stored for AutoSave to be on by default in Microsoft 365?
    显示答案

    答案: 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. 第16题，共16题

    A teammate made unwanted changes to a shared workbook saved on OneDrive. What can you use to go back to an earlier copy?
    显示答案

    答案: A. Version History

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

相关测试