Sayılar Ve Formüller (2)

WEBVTT 00:00:00.109 --> 00:00:03.690 Jetzt wenden Sie Zahlen und Formeln in Übung 9 an. 00:00:04.630 --> 00:00:11.552 Führen wir nun Addition, Subtraktion, Multiplikation und Division mit zwei Zahlen wie in der vorherigen Übung durch. 00:00:11.612 --> 00:00:13.212 Lassen Sie uns unser Wissen festigen. 00:00:13.872 --> 00:00:15.053 Was war die Addition? 00:00:15.173 --> 00:00:20.414 Gleich, addiere, öffnen Sie die Klammer, wählen Sie 10, wählen Sie 2. 00:00:21.226 --> 00:00:30.733 Sie können die Zahlen auch einzeln auswählen, indem Sie die Umschalttaste gedrückt halten und mit der linken Maustaste oder mit der Steuerungstaste und der linken Maustaste auswählen. 00:00:30.773 --> 00:00:31.273 Mit der Steuerungstaste. 00:00:32.034 --> 00:00:42.156 Wir schließen die Klammer, drücken Enter, die Summe von 10 und 2 ist 12. Wenn wir die Subtraktion durchführen, wählen wir zuerst die erste Zahl. 00:00:42.277 --> 00:00:43.958 Wir setzen das Minuszeichen dazwischen. 00:00:44.018 --> 00:00:46.439 Wir vergessen niemals das Gleichheitszeichen am Anfang. 00:00:46.479 --> 00:00:51.342 Denn wenn wir dieses Gleichheitszeichen nicht setzen, wird die Formel von Excel nicht erkannt. 00:00:52.943 --> 00:00:56.545 Wie Sie sehen, 10-2 ergibt 8, ganz einfach. 00:00:56.605 --> 00:00:58.046 Was haben wir sonst noch gemacht? 00:00:58.106 --> 00:01:07.651 Wenn wir zum Beispiel 2 nehmen, es zu -2 machen und die obige Formel nach unten ziehen, erreichen wir wieder den Wert 8. 00:01:07.811 --> 00:01:09.632 Wir haben beide Wege ausprobiert. 00:01:11.188 --> 00:01:12.350 Was war die Multiplikation? 00:01:13.611 --> 00:01:16.854 Denken Sie an das Multiplikationstableau. 00:01:16.894 --> 00:01:25.321 Multiplikation 10. Ich drücke die 2 als zweiten Wert. Enter. 00:01:25.321 --> 00:01:26.322 Es ergab 20. 00:01:26.502 --> 00:01:27.543 Division. 00:01:27.863 --> 00:01:28.904 Es war eine Division. 00:01:29.925 --> 00:01:31.046 Haben wir Division geschrieben? 00:01:31.887 --> 00:01:33.308 Wir haben unsere Klammer genommen. 00:01:33.608 --> 00:01:35.010 Wir werden 10 durch 2 teilen. 00:01:38.194 --> 00:01:54.164 Wir vergessen das Komma nicht, schließen die Klammer, drücken Enter und es erscheint eine 5. 00:01:54.164 --> 00:02:01.669 Bevor wir mit unserer 10. Übung fortfahren, bitte ich Sie erneut, mit den Tasten Strg-S zu speichern.

WEBVTT 00:00:00.109 --> 00:00:03.690 Now apply numbers and formulas in exercise 9. 00:00:04.630 --> 00:00:11.552 Let's perform addition, subtraction, multiplication, and division operations with two numbers just like we did in the previous exercise. 00:00:11.612 --> 00:00:13.212 Let's reinforce what we know. 00:00:13.872 --> 00:00:15.053 What was the addition operation? 00:00:15.173 --> 00:00:20.414 Equals, add, we opened the parentheses, selected 10, selected 2. 00:00:21.226 --> 00:00:30.733 While doing this, you can also select the numbers one by one by holding down the shift key and pressing the left mouse button, or 00:00:30.773 --> 00:00:31.273 with the control key. 00:00:32.034 --> 00:00:42.156 We closed the parentheses, pressed enter, the sum of 10 and 2 is 12. When we perform the subtraction operation, as we remembered just now, we first select the first number. 00:00:42.277 --> 00:00:43.958 We put a minus sign in between. 00:00:44.018 --> 00:00:46.439 We never forget the equals sign at the beginning. 00:00:46.479 --> 00:00:51.342 Because if we don't put that equals sign, the formula will not be recognized by Excel. 00:00:52.943 --> 00:00:56.545 As you can see, 10-2 equals 8, quite simple. 00:00:56.605 --> 00:00:58.046 On the other hand, what did we do? 00:00:58.106 --> 00:01:07.651 For example, if we take 2, make it negative 2, and drag the formula above, we can still reach the value of 8. 00:01:07.811 --> 00:01:09.632 We tried both ways. 00:01:11.188 --> 00:01:12.350 What was the multiplication operation? 00:01:13.611 --> 00:01:16.854 Let's keep the multiplication table in mind. 00:01:16.894 --> 00:01:25.321 Multiplication by 10. Pressing 2 as the second value. Enter. 00:01:25.321 --> 00:01:26.322 It resulted in 20. 00:01:26.502 --> 00:01:27.543 It was division. 00:01:27.863 --> 00:01:28.904 It was a division operation. 00:01:29.925 --> 00:01:31.046 Did we write division? 00:01:31.887 --> 00:01:33.308 We took our parentheses. 00:01:33.608 --> 00:01:35.010 We will divide 10 by 2. 00:01:38.194 --> 00:01:54.164 We don't forget the comma in between, close the parentheses, press Enter, and 5 appears. 00:01:54.164 --> 00:02:01.669 Before moving on to our 10th exercise, I would like to remind you to save with Ctrl-S again.

WEBVTT 00:00:00.109 --> 00:00:03.690 Şimdi alıştırma 9'da sayılar ve formülleri uygula. 00:00:04.630 --> 00:00:11.552 Az önce yaptığımız işlemdeki gibi şimdi toplama, çıkarma, çarpma, bölme işlemlerini iki sayıyla gerçekleştirelim. 00:00:11.612 --> 00:00:13.212 Bildiklerimizi pekiştirelim. 00:00:13.872 --> 00:00:15.053 Toplama işlemi neydi? 00:00:15.173 --> 00:00:20.414 Eşittir, topla, parantizi açtık, 10'u seçtik, 2'yi seçtik. 00:00:21.226 --> 00:00:30.733 Bunu yaparken shift'e basıl tutup sol faro düğmesiyle, shift yani yukarı tuşuna basıp sol faro düğmesiyle teker teker sayıları seçmeniz de mümkün ya da 00:00:30.773 --> 00:00:31.273 control tuşuyla. 00:00:32.034 --> 00:00:42.156 Parantezi kapattık, enter'a bastık, 10 ile 2'nin toplamı 12. Çıkarma işlemi yaptığımızda az önce de hatırladığımız gibi Önce birinci sayıyı seçiyoruz. 00:00:42.277 --> 00:00:43.958 Araya eksi işareti koyuyoruz. 00:00:44.018 --> 00:00:46.439 Baştaki eşittir işaretini hiç unutmuyoruz. 00:00:46.479 --> 00:00:51.342 Çünkü o eşittir işaretini koymadığımızda formül Excel tarafından tanımlanmayacak. 00:00:52.943 --> 00:00:56.545 Gördüğünüz gibi 10-2, 8 zaten gayet basit. 00:00:56.605 --> 00:00:58.046 Diğer bir yandan ne yapmıştık? 00:00:58.106 --> 00:01:07.651 Mesela 2'yi alıp, eksi 2 yapıp yukarıdaki formülü aşağı çektiğimizde 8 değerine yine ulaşabiliyoruz. 00:01:07.811 --> 00:01:09.632 İki yolu da denemiş olduk. 00:01:11.188 --> 00:01:12.350 Çarpma işlemi neydi? 00:01:13.611 --> 00:01:16.854 Çarpım tablosundan aklınızda kalsın. 00:01:16.894 --> 00:01:25.321 Çarpım 10. İkinci değer olarak 2. Enter'a basıyorum. 00:01:25.321 --> 00:01:26.322 20 geldi. 00:01:26.502 --> 00:01:27.543 Bölümdü. 00:01:27.863 --> 00:01:28.904 Bölme işlemiydi. 00:01:29.925 --> 00:01:31.046 Bölüm mü yazdık? 00:01:31.887 --> 00:01:33.308 Parantezimizi aldık. 00:01:33.608 --> 00:01:35.010 10'u 2'ye böleceğiz. 00:01:38.194 --> 00:01:54.164 Aradaki virgülü unutmuyoruz, parantezi kapatıyoruz, Enter'a basıyoruz ve 5 karşımıza gelmiş oldu. 00:01:54.164 --> 00:02:01.669 10. alıştırmamıza geçmeden önce sizden tekrar Ctrl-S tuşlarıyla kaydetmenizi istiyorum.