Jak podejść do zadania

Zadania w stylu maturalnym - Arkusz kalkulacyjny w liceum i technikum (sheet)

Pytanie: ile wypożyczeń trwało dłużej niż godzinę? Wystarczy jedna formuła `=LICZ.JEŻELI(C2:C21;">60")`. Pytanie trudniejsze: ile wypożyczeń było w weekend? Kolumna pomocnicza D liczy dzień tygodnia (`=DZIEŃ.TYG(A2;2)`), a odpowiedź to `=LICZ.JEŻELI(D2:D21;">5")`. Kolumny pomocnicze są w porządku: sprawdzana jest odpowiedź.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Data","B1":"Stacja","C1":"Czas (min)","D1":"Dzień tyg.","A2":"01.06.2026","B2":"Rynek","C2":"25","A3":"01.06.2026","B3":"Dworzec","C3":"48","A4":"02.06.2026","B4":"Park","C4":"95","A5":"02.06.2026","B5":"Rynek","C5":"12","A6":"03.06.2026","B6":"Dworzec","C6":"31","A7":"03.06.2026","B7":"Rynek","C7":"64","A8":"04.06.2026","B8":"Park","C8":"120","A9":"05.06.2026","B9":"Rynek","C9":"18","A10":"05.06.2026","B10":"Dworzec","C10":"75","A11":"06.06.2026","B11":"Park","C11":"140","A12":"06.06.2026","B12":"Park","C12":"55","A13":"06.06.2026","B13":"Rynek","C13":"33","A14":"07.06.2026","B14":"Park","C14":"180","A15":"07.06.2026","B15":"Dworzec","C15":"29","A16":"07.06.2026","B16":"Rynek","C16":"62","A17":"08.06.2026","B17":"Rynek","C17":"15","A18":"08.06.2026","B18":"Park","C18":"44","A19":"09.06.2026","B19":"Dworzec","C19":"90","A20":"10.06.2026","B20":"Rynek","C20":"37","A21":"10.06.2026","B21":"Park","C21":"66","D2":"=DZIEŃ.TYG(A2;2)","D3":"=DZIEŃ.TYG(A3;2)","D4":"=DZIEŃ.TYG(A4;2)","D5":"=DZIEŃ.TYG(A5;2)","D6":"=DZIEŃ.TYG(A6;2)","D7":"=DZIEŃ.TYG(A7;2)","D8":"=DZIEŃ.TYG(A8;2)","D9":"=DZIEŃ.TYG(A9;2)","D10":"=DZIEŃ.TYG(A10;2)","D11":"=DZIEŃ.TYG(A11;2)","D12":"=DZIEŃ.TYG(A12;2)","D13":"=DZIEŃ.TYG(A13;2)","D14":"=DZIEŃ.TYG(A14;2)","D15":"=DZIEŃ.TYG(A15;2)","D16":"=DZIEŃ.TYG(A16;2)","D17":"=DZIEŃ.TYG(A17;2)","D18":"=DZIEŃ.TYG(A18;2)","D19":"=DZIEŃ.TYG(A19;2)","D20":"=DZIEŃ.TYG(A20;2)","D21":"=DZIEŃ.TYG(A21;2)","F2":"Ponad godzinę","G2":"=LICZ.JEŻELI(C2:C21;\">60\")","F3":"W weekend","G3":"=LICZ.JEŻELI(D2:D21;\">5\")"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"},"F2":{"bold":true},"F3":{"bold":true}},"cols":{"A":100,"B":90,"C":90,"D":90,"F":120}}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.