Tabliczka mnożenia z adresem mieszanym

Adresowanie bezwzględne - Arkusz kalkulacyjny w szkole podstawowej (sheet)

W `B2` jest `=$A2*B$1`: kolumna A jest zablokowana (zawsze pierwszy czynnik z kolumny A), a wiersz 1 też (drugi czynnik z wiersza 1). Ta jedna formuła skopiowana na cały obszar tworzy tabliczkę mnożenia.

{"sheets":[{"name":"Arkusz1","cells":{"B1":"1","C1":"2","D1":"3","E1":"4","F1":"5","A2":"1","A3":"2","A4":"3","A5":"4","A6":"5","B2":"=$A2*B$1","C2":"=$A2*C$1","D2":"=$A2*D$1","E2":"=$A2*E$1","F2":"=$A2*F$1","B3":"=$A3*B$1","C3":"=$A3*C$1","D3":"=$A3*D$1","E3":"=$A3*E$1","F3":"=$A3*F$1","B4":"=$A4*B$1","C4":"=$A4*C$1","D4":"=$A4*D$1","E4":"=$A4*E$1","F4":"=$A4*F$1","B5":"=$A5*B$1","C5":"=$A5*C$1","D5":"=$A5*D$1","E5":"=$A5*E$1","F5":"=$A5*F$1","B6":"=$A6*B$1","C6":"=$A6*C$1","D6":"=$A6*D$1","E6":"=$A6*E$1","F6":"=$A6*F$1"},"formats":{"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"},"E1":{"bold":true,"fill":"#e0e7ff"},"F1":{"bold":true,"fill":"#e0e7ff"},"A2":{"bold":true,"fill":"#e0e7ff"},"A3":{"bold":true,"fill":"#e0e7ff"},"A4":{"bold":true,"fill":"#e0e7ff"},"A5":{"bold":true,"fill":"#e0e7ff"},"A6":{"bold":true,"fill":"#e0e7ff"}}}]}

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

Wszystkie lekcje kursu Arkusz kalkulacyjny w szkole podstawowej·Zaloguj się, aby zapisać postęp na koncie.