Excel for Beginners Course: Charts, printing and sharing

1. Pytanie 1 z 16

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

   • AInsert > Recommended Charts
   • BHome > Format as Table
   • CData > Sort Largest to Smallest
   • DView > Freeze Panes
   Pokaż odpowiedź

   Odpowiedź: A. Insert > Recommended Charts

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

2. Pytanie 2 z 16

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

   • ALine chart
   • BRadar chart
   • CPie chart
   • DDoughnut chart
   Pokaż odpowiedź

   Odpowiedź: A. Line chart

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

3. Pytanie 3 z 16

   When is a pie chart a good choice?

   • AFor data that has negative values
   • BFor comparing 15 categories side by side
   • CFor several data series over a whole year
   • DFor one data series that shows parts of a whole
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 4 z 16

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

   • ALine chart
   • BScatter chart
   • CBar chart
   • DPie chart
   Pokaż odpowiedź

   Odpowiedź: C. Bar chart

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

5. Pytanie 5 z 16

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

   • AAlong the vertical axis
   • BIn a separate worksheet
   • CAlong the horizontal axis
   • DIn the chart title only
   Pokaż odpowiedź

   Odpowiedź: C. Along the horizontal axis

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

6. Pytanie 6 z 16

   You select A1:B7 in the sheet below and insert a basic column chart. How many columns (bars) does the chart show?

   	A	B
   1	Month	Sales
   2	Jan	12400
   3	Feb	11850
   4	Mar	13920
   5	Apr	15100
   6	May	14480
   7	Jun	16230

   • A7
   • B6
   • C12
   • D2
   Pokaż odpowiedź

   Odpowiedź: B. 6

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

7. Pytanie 7 z 16

   You chart the sheet below as a column chart. Which month has the tallest column?

   	A	B
   1	Month	Sales
   2	Jan	12400
   3	Feb	11850
   4	Mar	13920
   5	Apr	15100
   6	May	14480
   7	Jun	16230

   • AJun
   • BMay
   • CApr
   • DJan
   Pokaż odpowiedź

   Odpowiedź: A. Jun

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

8. Pytanie 8 z 16

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

   • AView > Freeze Panes > Freeze Panes
   • BPage Layout > Print Area > Set Print Area
   • CData > Filter > Number Filters
   • DInsert > Recommended Charts > All Charts
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 9 z 16

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

   • AIt applies to every worksheet
   • BIt is removed when you close the file
   • CIt is saved with the workbook
   • DIt turns into a table
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 10 z 16

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

    • AView > Freeze Panes > Freeze Top Row
    • BHome > Format as Table
    • CPage Layout > Print Area
    • DPage Layout > Print Titles
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 11 z 16

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

    • AChange to landscape orientation
    • BInsert a pie chart instead
    • CSort the data from A to Z first
    • DChange the cells to Text format
    Pokaż odpowiedź

    Odpowiedź: A. Change to landscape orientation

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

12. Pytanie 12 z 16

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

    • AColumns fit on one page; rows may run onto more
    • BOnly the first row of the sheet prints
    • CThe data is sorted before printing
    • DEverything prints on exactly one page
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 13 z 16

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

    • AThe workbook can no longer be saved
    • BFormulas stop calculating until you reprint
    • CThe data is deleted from the sheet
    • DThe text can become too small to read easily
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 14 z 16

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

    • AFreeze the top row before sharing
    • BShare it with editing turned off
    • CEmail a screenshot of cell A1
    • DSet a print area before sharing
    Pokaż odpowiedź

    Odpowiedź: B. Share it with editing turned off

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

15. Pytanie 15 z 16

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

    • AOn the computer's desktop
    • BOneDrive or SharePoint Online
    • COn a USB memory stick
    • DIn the Downloads folder on your PC
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 16 z 16

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

    • AVersion History
    • BFormat as Table
    • CFreeze Panes
    • DClear Print Area
    Pokaż odpowiedź

    Odpowiedź: A. Version History

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

Klawiatura: 1–4, aby odpowiedzieć, Enter – następne pytanie.