Excel for Beginners Course: Charts, printing and sharing

1. السؤال 1 من 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
   أظهر الإجابة

   الإجابة: 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?

   • ALine chart
   • BRadar chart
   • CPie chart
   • DDoughnut chart
   أظهر الإجابة

   الإجابة: 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?

   • 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
   أظهر الإجابة

   الإجابة: 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?

   • ALine chart
   • BScatter chart
   • CBar chart
   • DPie chart
   أظهر الإجابة

   الإجابة: 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?

   • AAlong the vertical axis
   • BIn a separate worksheet
   • CAlong the horizontal axis
   • DIn the chart title only
   أظهر الإجابة

   الإجابة: 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?

   	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
   أظهر الإجابة

   الإجابة: 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?

   	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
   أظهر الإجابة

   الإجابة: 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?

   • AView > Freeze Panes > Freeze Panes
   • BPage Layout > Print Area > Set Print Area
   • CData > Filter > Number Filters
   • DInsert > Recommended Charts > All Charts
   أظهر الإجابة

   الإجابة: 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?

   • AIt applies to every worksheet
   • BIt is removed when you close the file
   • CIt is saved with the workbook
   • DIt turns into a table
   أظهر الإجابة

   الإجابة: 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?

    • AView > Freeze Panes > Freeze Top Row
    • BHome > Format as Table
    • CPage Layout > Print Area
    • DPage Layout > Print Titles
    أظهر الإجابة

    الإجابة: 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?

    • AChange to landscape orientation
    • BInsert a pie chart instead
    • CSort the data from A to Z first
    • DChange the cells to Text format
    أظهر الإجابة

    الإجابة: 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?

    • 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
    أظهر الإجابة

    الإجابة: 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?

    • 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
    أظهر الإجابة

    الإجابة: 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?

    • AFreeze the top row before sharing
    • BShare it with editing turned off
    • CEmail a screenshot of cell A1
    • DSet a print area before sharing
    أظهر الإجابة

    الإجابة: 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?

    • AOn the computer's desktop
    • BOneDrive or SharePoint Online
    • COn a USB memory stick
    • DIn the Downloads folder on your PC
    أظهر الإجابة

    الإجابة: 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?

    • AVersion History
    • BFormat as Table
    • CFreeze Panes
    • DClear Print Area
    أظهر الإجابة

    الإجابة: A. Version History

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

لوحة المفاتيح: 1–4 للإجابة، وEnter للسؤال التالي.