Google Sheets Fundamentals Course: Charts, sharing, comments and version history

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

   You selected your data. Which menu adds a chart?

   • AFormat, then Number
   • BInsert, then Chart
   • CData, then Create a filter
   • DView, then Freeze
   أظهر الإجابة

   الإجابة: B. Insert, then Chart

   Select the cells you want to include, then select Insert, then Chart.

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

   You double-click a chart. What two tabs does the chart editor have?

   • AInsert and Format
   • BEdit and Share
   • CSetup and Customize
   • DData and Design
   أظهر الإجابة

   الإجابة: C. Setup and Customize

   The chart editor opens in a side panel with a Setup tab and a Customize tab.

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

   Which chart type does Google suggest for looking at trends over a period of time, such as monthly sales?

   • APie chart
   • BGeo chart
   • CLine chart
   • DOrganizational chart
   أظهر الإجابة

   الإجابة: C. Line chart

   A line chart is used to look at trends or data over a time period.

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

   When is a pie chart a good choice?

   • ATo show a trend over many years
   • BTo show the parts that make up a whole
   • CTo show a family tree
   • DTo compare two number variables on X and Y axes
   أظهر الإجابة

   الإجابة: B. To show the parts that make up a whole

   A pie chart shows data as proportions of a whole, such as each department's share of a budget.

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

   You want to see whether hours worked and units packed are related. Which chart type fits best?

   • ATable chart
   • BScatter chart
   • CGauge chart
   • DPie chart
   أظهر الإجابة

   الإجابة: B. Scatter chart

   A scatter chart plots two variables on the X and Y axes to find trends and patterns between them.

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

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

   	A	B
   1	Month	Sales
   2	Jan	8200
   3	Feb	7650
   4	Mar	9100
   5	Apr	9875
   6	May	8940

   • A12
   • B2
   • C6
   • D5
   أظهر الإجابة

   الإجابة: D. 5

   Row 1 holds the headings and is used as labels. Rows 2 to 6 hold five months of sales, so the chart shows 5 columns.

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

   You want a co-worker to read your spreadsheet and add comments, but not change any cells. Which role do you give?

   • ACommenter
   • BEditor
   • CViewer
   • DOwner
   أظهر الإجابة

   الإجابة: A. Commenter

   A Commenter can view and comment but can't edit. A Viewer can't comment, and an Editor can change the cells.

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

   Under General access, which setting means only the people you added can open the file?

   • ANotify people
   • BPublic
   • CRestricted
   • DAnyone with the link
   أظهر الإجابة

   الإجابة: C. Restricted

   Restricted means only people who were given access can open the file.

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

   What does the General access setting "Anyone with the link" mean?

   • AThe file appears in Google Search results for everyone
   • BOnly people saved in your Google contacts can open it
   • COnly the owner can open it, even when others have the link
   • DAnyone who has the link can use the file without signing in
   أظهر الإجابة

   الإجابة: D. Anyone who has the link can use the file without signing in

   With Anyone with the link, anyone who gets the link can use the file without signing in. Public files can also be found through Google Search.

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

    As the owner, you want to stop viewers and commenters from downloading, printing or copying the file. Where is this setting?

    • AFile, then Download
    • BFormat, then Conditional formatting
    • CShare, then Settings
    • DData, then Protect sheets and ranges
    أظهر الإجابة

    الإجابة: C. Share, then Settings

    Owners can open Share, then Settings, and uncheck the box that lets viewers and commenters download, print and copy.

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

    Which keyboard shortcut inserts a comment on the selected cell?

    • ACtrl+Shift+C
    • BCtrl+Alt+M
    • CCtrl+M
    • DCtrl+K
    أظهر الإجابة

    الإجابة: B. Ctrl+Alt+M

    Ctrl+Alt+M inserts or edits a comment. Ctrl+K inserts a link.

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

    In a comment, you type + followed by a co-worker's email address and tick Assign to. What happens?

    • AThe co-worker becomes the new owner of the file
    • BThe comment becomes an action item and they get an email
    • CThe cell is locked so that only they can edit it
    • DThe comment is deleted and the co-worker is told why
    أظهر الإجابة

    الإجابة: B. The comment becomes an action item and they get an email

    Adding an email with @ or + and ticking Assign to turns the comment into an action item assigned to that person, who receives an email.

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

    What happens when you click Resolve on a comment?

    • AIt closes, but you can still find and re-open it
    • BThe cell goes back to its value before the comment
    • CIt is deleted forever and can't be found
    • DIt is emailed to the file owner for approval
    أظهر الإجابة

    الإجابة: A. It closes, but you can still find and re-open it

    Resolved comments stay in the file. Click Comments at the top to see them, and Re-open to bring one back.

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

    Which keyboard shortcut opens the version history of a spreadsheet?

    • ACtrl+Shift+V
    • BCtrl+Alt+M
    • CCtrl+Alt+Shift+H
    • DCtrl+H
    أظهر الإجابة

    الإجابة: C. Ctrl+Alt+Shift+H

    Ctrl+Alt+Shift+H opens the revision (version) history. You can also click the Last edit link at the top.

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

    A co-worker shares a spreadsheet with you as a Viewer. Can you see its version history?

    • AYes, but viewers see only the named versions
    • BNo, you need edit permission to see version history
    • COnly if you open the file in the mobile app
    • DYes, every viewer can see and restore old versions
    أظهر الإجابة

    الإجابة: B. No, you need edit permission to see version history

    Google says that if you don't have permission to edit a file, you won't be able to see its version history.

16. السؤال 16 من 17

    You want to keep last month's version of a spreadsheet easy to find. What can you do in version history?

    • AResolve every comment that was added that month
    • BSet General access to Restricted for that month
    • CUse More, then Name this version
    • DDelete all the versions that are older than it
    أظهر الإجابة

    الإجابة: C. Use More, then Name this version

    Choose a version, click More and choose Name this version. A spreadsheet can have up to 15 named versions.

17. السؤال 17 من 17

    Who changed cell E14 last week? Which tool shows the past changes to one cell?

    • ASelect Format, then Conditional formatting
    • BSelect Data, then Create a filter on column E
    • CPress Ctrl+~ to show all the formulas
    • DRight-click it and select Show edit history
    أظهر الإجابة

    الإجابة: D. Right-click it and select Show edit history

    Right-click a cell and select Show edit history. Some changes, such as formatting changes or changes made by formulas, may not appear.

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