Google Sheets Fundamentals Course: Sorting, filtering, validation and highlighting

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

   You selected your list. Which menu adds filter buttons to the header row?

   • AData, then Create a filter
   • BFormat, then Conditional formatting
   • CView, then Freeze
   • DInsert, then Dropdown
   أظهر الإجابة

   الإجابة: A. Data, then Create a filter

   Select the range, then select Data, then Create a filter. A Filter icon appears at the top of each column.

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

   In the inventory below, you filter the Category column to show only PPE. How many data rows are still visible?

   	A	B	C	D
   1	Item	Category	Qty	Reorder at
   2	Nitrile gloves	PPE	120	50
   3	Safety glasses	PPE	18	20
   4	Box cutters	Tools	9	10
   5	Packing tape	Supplies	64	24
   6	Hi-vis vests	PPE	30	15
   7	Label rolls	Supplies	6	12
   8	Tape guns	Tools	14	5

   • A7
   • B4
   • C2
   • D3
   أظهر الإجابة

   الإجابة: D. 3

   Three items are PPE: Nitrile gloves, Safety glasses and Hi-vis vests. The other rows are hidden.

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

   You use Data, then Sort range, then Advanced range sorting options. Your list has headings in row 1. What should you tick?

   • AData has header row
   • BShow a warning
   • CUse custom cell values
   • DAllow multiple selections
   أظهر الإجابة

   الإجابة: A. Data has header row

   Tick Data has header row so the headings stay at the top and are not sorted with the data.

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

   In the inventory below, you sort the data by Qty from smallest to largest. Which item ends up in row 2?

   	A	B	C	D
   1	Item	Category	Qty	Reorder at
   2	Nitrile gloves	PPE	120	50
   3	Safety glasses	PPE	18	20
   4	Box cutters	Tools	9	10
   5	Packing tape	Supplies	64	24
   6	Hi-vis vests	PPE	30	15
   7	Label rolls	Supplies	6	12
   8	Tape guns	Tools	14	5

   • ALabel rolls
   • BBox cutters
   • CNitrile gloves
   • DTape guns
   أظهر الإجابة

   الإجابة: A. Label rolls

   The smallest quantity is 6, for Label rolls, so it moves to the first data row.

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

   In the inventory below, you sort by Category (A to Z) and then by Qty (largest to smallest). Which item ends up in the last row (row 8)?

   	A	B	C	D
   1	Item	Category	Qty	Reorder at
   2	Nitrile gloves	PPE	120	50
   3	Safety glasses	PPE	18	20
   4	Box cutters	Tools	9	10
   5	Packing tape	Supplies	64	24
   6	Hi-vis vests	PPE	30	15
   7	Label rolls	Supplies	6	12
   8	Tape guns	Tools	14	5

   • ABox cutters
   • BPacking tape
   • CLabel rolls
   • DTape guns
   أظهر الإجابة

   الإجابة: A. Box cutters

   Tools comes last in A to Z order. Within Tools, the largest Qty comes first: Tape guns (14), then Box cutters (9).

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

   In the advanced sort options, how do you add a second rule, such as sorting by Last name within each Department?

   • ASort the sheet twice with Ctrl+Z in between
   • BClick Add another sort column
   • CClick Add rule under Data validation
   • DCreate a second filter view
   أظهر الإجابة

   الإجابة: B. Click Add another sort column

   Choose the first column and order, then click Add another sort column to add the next rule.

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

   Several people use the same shared sheet. You want to filter the data without changing what others see. What should you use?

   • AA filter
   • BA filter view
   • CConditional formatting
   • DA protected range
   أظهر الإجابة

   الإجابة: B. A filter view

   A filter is seen by everyone who has access. A filter view lets each person have their own sort and filter.

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

   You only have view access to a sheet. What happens if you create a filter view?

   • AIt is temporary, only you can use it and it is not saved
   • BIt is saved in the file and shared with the owner
   • CIt changes the view for everyone who opens the file
   • DSheets refuses, because viewers cannot sort or filter
   أظهر الإجابة

   الإجابة: A. It is temporary, only you can use it and it is not saved

   With view-only access you can still create a filter view, but it is temporary, only you can use it, and it isn't saved.

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

   You want a cell to offer a list such as Open, In progress and Closed. Which menu adds it?

   • AData, then Create a filter
   • BInsert, then Dropdown
   • CFormat, then Number
   • DInsert, then Chart
   أظهر الإجابة

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

   Insert, then Dropdown adds a dropdown list. You can also select Data, then Data validation, then Add rule.

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

    Someone types a value that is not in a dropdown list. What happens by default?

    • AThe entry is accepted and turned red
    • BThe entry is rejected
    • CThe list grows to include it
    • DThe whole row is deleted
    أظهر الإجابة

    الإجابة: B. The entry is rejected

    By default, entries that don't match the list are rejected. Under Advanced options you can choose Show a warning instead.

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

    Your list of department names is in Lists!A2:A8. Which dropdown criteria uses those cells for the choices?

    • ACustom formula is
    • BDropdown from a range
    • CDropdown
    • DColor scale
    أظهر الإجابة

    الإجابة: B. Dropdown from a range

    Dropdown from a range takes its choices from the cells you select. Dropdown lets you type the items yourself.

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

    You want Yes and No to be stored when a checkbox is ticked and unticked. Where do you set this?

    • AData validation: criteria Checkbox, then Use custom cell values
    • BInsert, then Checkbox, then Format, then Number, then Custom
    • CData, then Create a filter, then Filter by values
    • DFormat, then Conditional formatting, then Color scale
    أظهر الإجابة

    الإجابة: A. Data validation: criteria Checkbox, then Use custom cell values

    In Data validation, set the criteria to Checkbox, click Use custom cell values, and enter the Checked and Unchecked values.

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

    Which menu lets you colour cells automatically when a rule is true, such as stock below the reorder level?

    • AData, then Data validation
    • BInsert, then Dropdown
    • CView, then Show, then Protected ranges
    • DFormat, then Conditional formatting
    أظهر الإجابة

    الإجابة: D. Format, then Conditional formatting

    Select the cells, then select Format, then Conditional formatting. A panel opens on the right where you set the rule.

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

    In the inventory below, you apply the custom formula =$C2<$D2 to A2:D8. How many rows are highlighted?

    	A	B	C	D
    1	Item	Category	Qty	Reorder at
    2	Nitrile gloves	PPE	120	50
    3	Safety glasses	PPE	18	20
    4	Box cutters	Tools	9	10
    5	Packing tape	Supplies	64	24
    6	Hi-vis vests	PPE	30	15
    7	Label rolls	Supplies	6	12
    8	Tape guns	Tools	14	5

    • A4
    • B3
    • C2
    • D7
    أظهر الإجابة

    الإجابة: B. 3

    The rule is true when Qty is less than Reorder at: Safety glasses (18 < 20), Box cutters (9 < 10) and Label rolls (6 < 12).

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

    Two conditional formatting rules are true for the same cell. Which format does it get?

    • AA mix of both rules' formats
    • BThe newest rule that was added
    • CThe first rule found to be true
    • DNo format, because the rules conflict
    أظهر الإجابة

    الإجابة: C. The first rule found to be true

    The first rule found to be true defines the format. Drag the rules in the panel to change their order.

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

    Which custom formula highlights duplicate values in A1:A100?

    • A=COUNTIF($A$1:$A$100,A1)>1
    • B=COUNTA($A$1:$A$100)>1
    • C=COUNTIF(A1,$A$1:$A$100)>1
    • D=IF(A1=A1,TRUE)
    أظهر الإجابة

    الإجابة: A. =COUNTIF($A$1:$A$100,A1)>1

    COUNTIF counts how many times A1's value appears in the locked range $A$1:$A$100. More than 1 means it is a duplicate.

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

    You protect a range with Data, then Protect sheets and ranges. What does Google say about using this as a security measure?

    • AIt is safe for secrets, because the range is hidden from everyone but you
    • BIt is not a security measure: people can still copy, print or export
    • CIt is a full security measure, because viewers can no longer see the range
    • DIt is strong security, because the cells are locked with a password
    أظهر الإجابة

    الإجابة: B. It is not a security measure: people can still copy, print or export

    Google says protection shouldn't be used as a security measure. It limits editing only; people can still print, copy, paste, import and export, so share only with people you trust.

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