PassEveryTest
Svenska

Excel for Beginners Course: Charts, printing and sharing

Temaquiz utan tidsgräns: 16 frågor om Charts, printing and sharing, med en förklaring efter varje svar. Frågor och svar blandas varje gång.

  • Kurs
  • Kanada
  • 100 frågor
  • Kontrollerad 13 oktober 2026
  • Faktagranskad 13 oktober 2026
Börja med lektionernaExcel for Beginners Course: Lessons: cirka 120 minuters läsning. Alla provfrågor tas upp i lektionerna.

Temaquiz 6: Charts, printing and sharing

  1. Fråga 1 av 16

    You have selected your data. Which command shows Excel's suggested charts for it?
    Visa svar

    Svar: A. Insert > Recommended Charts

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

  2. Fråga 2 av 16

    Which chart type is best for showing how monthly sales went up and down over a year?
    Visa svar

    Svar: A. Line chart

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

  3. Fråga 3 av 16

    When is a pie chart a good choice?
    Visa svar

    Svar: 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. Fråga 4 av 16

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

    Svar: C. Bar chart

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

  5. Fråga 5 av 16

    In a column chart, where are the categories (such as months) usually shown?
    Visa svar

    Svar: C. Along the horizontal axis

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

  6. Fråga 6 av 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
    Visa svar

    Svar: B. 6

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

  7. Fråga 7 av 16

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

    Svar: A. Jun

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

  8. Fråga 8 av 16

    You only want to print A1:F20. After you select A1:F20, what do you choose?
    Visa svar

    Svar: 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. Fråga 9 av 16

    You set a print area and save the workbook. What happens to the print area?
    Visa svar

    Svar: 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. Fråga 10 av 16

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

    Svar: 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. Fråga 11 av 16

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

    Svar: A. Change to landscape orientation

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

  12. Fråga 12 av 16

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

    Svar: 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. Fråga 13 av 16

    What is a downside of using a scaling option such as Fit Sheet on One Page on a large sheet?
    Visa svar

    Svar: 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. Fråga 14 av 16

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

    Svar: B. Share it with editing turned off

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

  15. Fråga 15 av 16

    Where must a workbook be stored for AutoSave to be on by default in Microsoft 365?
    Visa svar

    Svar: 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. Fråga 16 av 16

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

    Svar: A. Version History

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

Relaterade prov