Çıkarma

WEBVTT 00:00:00.109 --> 00:00:05.811 Hallo Freunde, in diesem Abschnitt werden wir uns mit dem Subtraktionsabschnitt unseres Excel-Übungsblatts 1B befassen. 00:00:06.031 --> 00:00:08.651 Wenn ihr bereit seid, lasst uns gemeinsam Übung 1 betrachten. 00:00:09.773 --> 00:00:13.554 Hier geht es darum, eine Formel zu erstellen, die Zelle C5 von Zelle A5 und Zelle B5 subtrahiert. 00:00:13.634 --> 00:00:16.535 Das heißt, wir sollen das Einkommen von den Ausgaben abziehen. 00:00:17.155 --> 00:00:19.736 Zusammenfassend schreibe ich zunächst ein Gleichheitszeichen. 00:00:19.956 --> 00:00:21.277 Dann das Einkommen. 00:00:22.823 --> 00:00:24.604 Ich habe auf die Zelle geklickt, die es enthält. 00:00:25.143 --> 00:00:27.946 Dann habe ich ein "X" von meiner Tastatur eingegeben. 00:00:28.247 --> 00:00:29.808 Dann habe ich B5 eingegeben. 00:00:30.808 --> 00:00:32.570 Und dann Enter gedrückt. 00:00:32.630 --> 00:00:36.453 Wie ihr sehen könnt, hat es das Einkommen von den Ausgaben abgezogen und uns das Ergebnis gegeben. 00:00:37.453 --> 00:00:41.557 Unser nächster Schritt ist es, Zelle C5 in den Bereich C6 bis C10 zu kopieren. 00:00:41.637 --> 00:00:43.298 Das heißt, wir sollen die gleichen Aktionen auch in anderen... 00:00:44.909 --> 00:00:46.491 Zeilen durchführen. 00:00:46.551 --> 00:00:57.235 Wie ihr sehen könnt, haben wir dies, indem wir die Artikulation, die unten rechts in der Ecke erscheint, greifen und sie auf die darunter liegenden Zeilen angewendet haben. 00:00:58.395 --> 00:01:03.597 Zuletzt wurde gesagt, dass der Bereich A5-C10 im Währungsformat formatiert werden soll. 00:01:04.298 --> 00:01:08.261 Hier habe ich erneut den Bereich A5 bis C10 ausgewählt. 00:01:08.441 --> 00:01:15.785 Dann habe ich im Dropdown-Menü des Eingabefelds für Zahlen auf das Währungssymbol geklickt. 00:01:16.846 --> 00:01:18.407 Dann wählte ich die türkische Lira aus. 00:01:19.087 --> 00:01:22.509 Wie Sie sehen, haben wir Ihre Transaktion erfolgreich abgeschlossen. 00:01:22.770 --> 00:01:23.490 Ich wünsche Ihnen viel Erfolg. 00:01:23.510 --> 00:01:24.791 Bis zum nächsten Abschnitt.

WEBVTT 00:00:00.109 --> 00:00:05.811 Hello friends, in this part we will cover the subtraction part of our Excel exercises 1B file. 00:00:06.031 --> 00:00:08.651 If you are ready, let's take a look at exercise 1 together. 00:00:09.773 --> 00:00:13.554 Here, we have a formula that subtracts cell C5 from cell A5 and cell B5. 00:00:13.634 --> 00:00:16.535 In other words, it asked us to subtract income from expenses. 00:00:17.155 --> 00:00:19.736 In summary, to do this, I first write an equal sign. 00:00:19.956 --> 00:00:21.277 Then income. 00:00:22.823 --> 00:00:24.604 I clicked on the cell containing it. 00:00:25.143 --> 00:00:27.946 Then I typed an X from my keyboard. 00:00:28.247 --> 00:00:29.808 Then I typed B5. 00:00:30.808 --> 00:00:32.570 And then I pressed Enter. 00:00:32.630 --> 00:00:36.453 As you can see, it subtracted income from expenses and gave us the result. 00:00:37.453 --> 00:00:41.557 Our next step is to copy cell C5 to the range C6 to C10. 00:00:41.637 --> 00:00:43.298 In other words, it asked us to do the same operations in other... 00:00:44.909 --> 00:00:46.491 rows as well. 00:00:46.551 --> 00:00:57.235 As you can see, we applied this operation to the rows below by holding and dragging from the bottom right corner where the plus sign appears. 00:00:58.395 --> 00:01:03.597 Finally, it says to apply TL formatting to the range A5-C10. 00:01:04.298 --> 00:01:08.261 Again, I selected the A5, C10 range as you can see. 00:01:08.441 --> 00:01:15.785 Then I clicked on the currency symbol in the number box in our toolbar. 00:01:16.846 --> 00:01:18.407 Then I selected the Turkish lira. 00:01:19.087 --> 00:01:22.509 As you can see, we have successfully completed your transaction. 00:01:22.770 --> 00:01:23.490 I wish you success. 00:01:23.510 --> 00:01:24.791 See you in the next section.

WEBVTT 00:00:00.109 --> 00:00:05.811 Merhaba arkadaşlar, bu kısmında Excel alışmaları 1B dosyamızın çıkarma kısmını ele alacağız. 00:00:06.031 --> 00:00:08.651 Hazırsanız gelin alışma 1'e hep beraber bakalım. 00:00:09.773 --> 00:00:13.554 Burada C5 hücresini, A5 hücresini, B5 hücresini çıkaran bir formül gidin. 00:00:13.634 --> 00:00:16.535 Yani buradan geliri giderden çıkartmamızı istemiş bizden. 00:00:17.155 --> 00:00:19.736 Özetle bunu yapmam için öncelikle bir eşittir yazıyorum. 00:00:19.956 --> 00:00:21.277 Ardından geliri. 00:00:22.823 --> 00:00:24.604 İçerisinde bulunduran hücreye tıkladım. 00:00:25.143 --> 00:00:27.946 Ardından bir klavyemden X yazdım. 00:00:28.247 --> 00:00:29.808 Ardından da B5 yazdım. 00:00:30.808 --> 00:00:32.570 Ve ardından Enter'a bastım. 00:00:32.630 --> 00:00:36.453 Gördüğünüz üzere gelerek giderden çıkarttı ve sonucu verdi bize. 00:00:37.453 --> 00:00:41.557 Bir sonraki adımız da C5 hücresini, C6, C10 hücre aralığına kopyalayın. 00:00:41.637 --> 00:00:43.298 Yani burada yaptığımız işlerin diğer... 00:00:44.909 --> 00:00:46.491 satırlarda da yapmamızı istemiş. 00:00:46.551 --> 00:00:57.235 Bizden bunun için yine gördüğünüz üzere köşesinde sağ alt köşesinde çıkan art tığ ibaresinden tutup şeklinde de bu işlemi bir alttaki satırlara uygulamış olduk. 00:00:58.395 --> 00:01:03.597 Son olarak A5-C10 hücrü aralığını TL biçimlendirmesi uygulayın denmiş. 00:01:04.298 --> 00:01:08.261 Yine burada A5, C10 aralığını gördüğünüz üzere seçtim. 00:01:08.441 --> 00:01:15.785 Ardından giriş menümüzde bulunan sayı kutucuğundaki para birimi, sembolünü tıkladım. 00:01:16.846 --> 00:01:18.407 Ardından Türk lirasını seçtim. 00:01:19.087 --> 00:01:22.509 Gördüğünüz üzere işleminizi başarıyla tamamlamış olduk. 00:01:22.770 --> 00:01:23.490 Başarılar dilerim. 00:01:23.510 --> 00:01:24.791 Bir sonraki kısmında görüşmek üzere.