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

1. Pytanie 1 z 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
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 2 z 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
   Pokaż odpowiedź

   Odpowiedź: D. 3

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

3. Pytanie 3 z 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
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 4 z 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
   Pokaż odpowiedź

   Odpowiedź: A. Label rolls

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

5. Pytanie 5 z 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
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 6 z 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
   Pokaż odpowiedź

   Odpowiedź: B. Click Add another sort column

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

7. Pytanie 7 z 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
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 8 z 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
   Pokaż odpowiedź

   Odpowiedź: 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. Pytanie 9 z 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
   Pokaż odpowiedź

   Odpowiedź: B. Insert, then Dropdown

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

10. Pytanie 10 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 11 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 12 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 13 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 14 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 15 z 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
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 16 z 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)
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 17 z 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
    Pokaż odpowiedź

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

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