PassEveryTest
Polski

Excel Formulas and Data Analysis Course: Conditional formatting, data validation and duplicates

Quiz tematyczny bez limitu czasu: 17 pytań o Conditional formatting, data validation and duplicates, z wyjaśnieniem po każdej odpowiedzi. Pytania i odpowiedzi są za każdym razem mieszane.

  • Kurs
  • Kanada
  • Pytania: 96
  • Sprawdzono 13 października 2026
  • Fakty sprawdzone 13 października 2026
Zacznij od lekcjiExcel Formulas and Data Analysis Course: Lessons: ok. 240 min czytania. Każde pytanie testowe jest omówione w lekcjach.

Quiz tematyczny 5: Conditional formatting, data validation and duplicates

  1. Pytanie 1 z 17

    On which ribbon tab do you find the Conditional Formatting button?
    Pokaż odpowiedź

    Odpowiedź: C. Home

    Conditional Formatting is on the Home tab, in the Styles group.

  2. Pytanie 2 z 17

    You want each amount to show a coloured bar inside its cell, longer for larger numbers. Which conditional format do you pick?
    Pokaż odpowiedź

    Odpowiedź: D. Data Bars

    Data Bars show each value's size as a coloured bar in the cell.

  3. Pytanie 3 z 17

    Icon Sets split a range into groups of values, each with its own icon. How many groups can an icon set have?
    Pokaż odpowiedź

    Odpowiedź: B. 3 to 5

    An icon set sorts values into three to five groups, and each group has its own threshold.

  4. Pytanie 4 z 17

    You want to quickly highlight the 10 largest sales in a column. Which menu do you use?
    Pokaż odpowiedź

    Odpowiedź: C. Conditional Formatting > Top/Bottom Rules > Top 10 Items

    Top/Bottom Rules > Top 10 Items highlights the highest values in the range without changing the order of the data.

  5. Pytanie 5 z 17

    How do you highlight email addresses that appear more than once in a column?
    Pokaż odpowiedź

    Odpowiedź: C. Conditional Formatting > Highlight Cells Rules > Duplicate Values

    Duplicate Values highlights repeated entries so you can review them. Remove Duplicates deletes them instead.

  6. Pytanie 6 z 17

    You select B2:B20 (B2 is the active cell) and want to colour each cell when the value in column E of the same row is over 300. Which rule formula do you enter?
    Pokaż odpowiedź

    Odpowiedź: C. =E2>300

    Write the formula for the active cell with a relative reference (E2), so it adjusts for every row. $E$2 would check only row 2.

  7. Pytanie 7 z 17

    You type A2>B2 (with no equal sign) as a conditional formatting formula. What happens?
    Pokaż odpowiedź

    Odpowiedź: A. Excel adds quotes, so the rule is read as text and fails

    Microsoft warns that if you leave out =, Excel adds = and quotes, and you must remove the quotes before the formula works.

  8. Pytanie 8 z 17

    Two rules apply to B2:B10: "greater than 60,000: blue fill" is above "greater than 70,000: yellow fill" in the Rules Manager. B2 holds 75,000. What fill does B2 get?
    Pokaż odpowiedź

    Odpowiedź: C. Blue

    When conflicting rules apply, the rule higher in the list has precedence. 75,000 is over 60,000, so the blue rule wins. Use Move Up/Move Down to change the order.

  9. Pytanie 9 z 17

    In the Conditional Formatting Rules Manager, what does the Stop If True box do?
    Pokaż odpowiedź

    Odpowiedź: C. Lower rules are not checked when this rule is true

    Stop If True stops rule evaluation at that rule, so lower rules are not applied to those cells.

  10. Pytanie 10 z 17

    Which command lets you make a drop-down list in a cell?
    Pokaż odpowiedź

    Odpowiedź: A. Data > Data Validation, then Allow: List

    In the Data Validation box, choose List in Allow, then type the items separated by commas (for example Low,Average,High) in Source.

  11. Pytanie 11 z 17

    You want a cell to accept only whole numbers from 1 to 40. What do you choose in Data Validation?
    Pokaż odpowiedź

    Odpowiedź: A. Whole Number, between, minimum 1 and maximum 40

    Whole Number limits the cell to whole numbers, and "between" sets lower and upper limits.

  12. Pytanie 12 z 17

    Which Error Alert style stops people from entering a value that breaks the rule?
    Pokaż odpowiedź

    Odpowiedź: A. Stop

    Stop prevents invalid data; the user can only retry or cancel. Warning and Information let the user keep the value.

  13. Pytanie 13 z 17

    You added a validation rule to a column that already had data. How can you find old entries that break the rule?
    Pokaż odpowiedź

    Odpowiedź: B. Use Circle Invalid Data

    Excel does not warn you about existing invalid data. Circle Invalid Data draws circles around those cells.

  14. Pytanie 14 z 17

    A co-worker pastes values into a cell that has data validation. What happens?
    Pokaż odpowiedź

    Odpowiedź: C. It may get through, since validation checks typed entries

    Microsoft says data validation shows messages and blocks invalid entries only when users type directly in a cell. Copied or filled data can bypass it.

  15. Pytanie 15 z 17

    You select A1:C8 below and use Data > Remove Duplicates with all three columns checked. How many data rows are left?
    ABC
    1NameEmailShift
    2Ana Diazana@example.comDay
    3Ben Coleben@example.comNight
    4Ana Diazana@example.comDay
    5Chen Wuchen@example.comDay
    6Ben Coleben@example.comDay
    7Dina Roydina@example.comNight
    8Chen Wuchen@example.comDay
    Pokaż odpowiedź

    Odpowiedź: B. 5

    A row is removed only if all checked columns match an earlier row. Ana Diaz/Day and Chen Wu/Day repeat; Ben Cole has Night and Day, so both stay: 7 - 2 = 5.

  16. Pytanie 16 z 17

    You select A1:C8 below and use Remove Duplicates with only the Email column checked. How many data rows are left?
    ABC
    1NameEmailShift
    2Ana Diazana@example.comDay
    3Ben Coleben@example.comNight
    4Ana Diazana@example.comDay
    5Chen Wuchen@example.comDay
    6Ben Coleben@example.comDay
    7Dina Roydina@example.comNight
    8Chen Wuchen@example.comDay
    Pokaż odpowiedź

    Odpowiedź: B. 4

    Now only Email is compared, so each email address is kept once: ana, ben, chen and dina.

  17. Pytanie 17 z 17

    In the sheet below, what does =UNIQUE(B2:B8,FALSE,TRUE) return?
    ABC
    1NameEmailShift
    2Ana Diazana@example.comDay
    3Ben Coleben@example.comNight
    4Ana Diazana@example.comDay
    5Chen Wuchen@example.comDay
    6Ben Coleben@example.comDay
    7Dina Roydina@example.comNight
    8Chen Wuchen@example.comDay
    Pokaż odpowiedź

    Odpowiedź: D. dina@example.com

    With exactly_once set to TRUE, UNIQUE returns only values that appear exactly once. Only dina@example.com appears once.

Powiązane testy