Microsoft Office Specialist: Excel Exam Preparation: Manage charts

1. السؤال 1 من 15

   Which command suggests chart types that fit the data you selected?

   • AData > What-If Analysis
   • BHome > Conditional Formatting
   • CInsert > Sparklines
   • DInsert > Recommended Charts
   أظهر الإجابة

   الإجابة: D. Insert > Recommended Charts

   Recommended Charts on the Insert tab previews chart types that suit the selected data.

2. السؤال 2 من 15

   You want to show how one budget is split into five parts. Which chart type fits best?

   • APie
   • BLine
   • CStock
   • DScatter
   أظهر الإجابة

   الإجابة: A. Pie

   A pie chart shows the parts of one whole and uses a single data series.

3. السؤال 3 من 15

   You want to show how monthly incidents changed over 12 months. Which chart type fits best?

   • ADoughnut
   • BTreemap
   • CLine
   • DPie
   أظهر الإجابة

   الإجابة: C. Line

   Line charts are good for showing a trend over time.

4. السؤال 4 من 15

   What is a chart sheet?

   • AA table that lists chart settings
   • BA printed page of a chart
   • CA worksheet with a chart next to the data
   • DA sheet that holds only a chart
   أظهر الإجابة

   الإجابة: D. A sheet that holds only a chart

   A chart sheet is a separate sheet in the workbook that contains just the chart.

5. السؤال 5 من 15

   A chart sits on the worksheet. How do you move it to its own new chart sheet?

   • ACut the chart and paste it on a new worksheet
   • BView > New Window
   • CChart Design > Move Chart > New sheet
   • DInsert > New Sheet > Chart
   أظهر الإجابة

   الإجابة: C. Chart Design > Move Chart > New sheet

   Move Chart (in the Location group on Chart Design) lets you choose New sheet and type its name.

6. السؤال 6 من 15

   You select a data range and press F11. What happens?

   • AExcel shows formulas
   • BExcel inserts a sparkline
   • CExcel makes a chart on a new chart sheet
   • DExcel opens the Format Cells dialog for the range
   أظهر الإجابة

   الإجابة: C. Excel makes a chart on a new chart sheet

   F11 makes a chart of the selected data on its own chart sheet. Alt+F1 puts the chart on the current worksheet instead.

7. السؤال 7 من 15

   Where is the Switch Row/Column button?

   • AFormat tab, Shape Styles group
   • BChart Design tab, Data group
   • CHome tab, Alignment group
   • DData tab, Sort & Filter group
   أظهر الإجابة

   الإجابة: B. Chart Design tab, Data group

   Select the chart; the Chart Design tab appears, and Switch Row/Column is in its Data group.

8. السؤال 8 من 15

   What does Switch Row/Column change?

   • AHow the rows and columns are plotted
   • BThe chart type from column to bar
   • CThe colours of the chart
   • DThe order of the rows in the worksheet
   أظهر الإجابة

   الإجابة: A. How the rows and columns are plotted

   Switch Row/Column swaps how the rows and columns are plotted. The worksheet data does not change.

9. السؤال 9 من 15

   You select A1:G4 (3 regions down column A, 6 months across row 1) and insert a column chart. By default, what goes on the horizontal axis?

   	A	B	C	D	E	F	G
   1	المنطقة	Jan	Feb	Mar	Apr	May	Jun
   2	North	10	11	12	13	14	15
   3	South	13	14	15	16	17	18
   4	East	16	17	18	19	20	21

   • AThe 6 months, with one series per region
   • BThe totals for each region only
   • CNothing until you choose Switch Row/Column
   • DThe 3 regions, with one series per month
   أظهر الإجابة

   الإجابة: A. The 6 months, with one series per region

   Excel puts the larger group on the horizontal axis. There are more months (6) than regions (3), so the months go across and each region is a series.

10. السؤال 10 من 15

    Your chart shows 2025 sales. You want to add the 2026 column as a new series. What is one correct way?

    • AInsert > Recommended Charts again
    • BFormat > Shape Fill
    • CChart Design > Change Colors
    • DChart Design > Select Data > Add
    أظهر الإجابة

    الإجابة: D. Chart Design > Select Data > Add

    Select Data opens a dialog where Add creates a new series from the range you choose. You can also drag the data range outline to include the new column.

11. السؤال 11 من 15

    Which button beside a selected chart lets you quickly add data labels or axis titles?

    • AChart Filters (the funnel icon)
    • BChart Elements (the plus sign)
    • CThe Format Chart Area pane
    • DChart Styles (the paintbrush)
    أظهر الإجابة

    الإجابة: B. Chart Elements (the plus sign)

    Chart Elements (+) turns elements such as Axis Titles, Data Labels, Gridlines and Legend on or off.

12. السؤال 12 من 15

    A clustered column chart shows three sites in three colours. Which chart element tells the reader which colour is which site?

    • AThe gridlines
    • BThe axis title
    • CThe legend
    • DThe chart title
    أظهر الإجابة

    الإجابة: C. The legend

    The legend matches each series colour to its name.

13. السؤال 13 من 15

    You want to apply a ready-made arrangement of title, legend and labels in one click. What do you use?

    • APage Layout > Themes
    • BChart Design > Change Chart Type
    • CChart Design > Quick Layout
    • DFormat > Size
    أظهر الإجابة

    الإجابة: C. Chart Design > Quick Layout

    Quick Layout applies a predefined set of chart elements. Chart Styles changes the look (colours and effects).

14. السؤال 14 من 15

    Why do you add alternative text (alt text) to a chart?

    • ATo describe the chart for screen reader users
    • BSo the chart title appears in the legend
    • CSo the chart prints in colour
    • DSo the chart updates whenever the source data changes
    أظهر الإجابة

    الإجابة: A. To describe the chart for screen reader users

    Alt text is read aloud by screen readers. You add it by right-clicking the chart and choosing the Alt Text command.

15. السؤال 15 من 15

    Which alt text is most useful for a chart of monthly incidents?

    • AColumn chart: incidents per month in 2026; highest in July (14), lowest in February (3).
    • BA chart.
    • CChart 1
    • DPicture of an Excel chart with blue bars, a white background and a grey border around it.
    أظهر الإجابة

    الإجابة: A. Column chart: incidents per month in 2026; highest in July (14), lowest in February (3).

    Good alt text says what kind of chart it is and its key message, not just its colours or a default name.

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