Sayılar Ve Formüller

WEBVTT 00:00:01.420 --> 00:00:06.081 Ja Leute, unsere achte Übung dreht sich um Zahlen und Formeln. 00:00:07.621 --> 00:00:09.321 Warum sind Zahlen und Formeln wichtig? 00:00:09.362 --> 00:00:18.264 Ich hatte Ihnen bereits Formeln gezeigt, als ich Ihnen einige Informationen zu Datumseinstellungen und Kalender gegeben habe. 00:00:18.284 --> 00:00:21.664 Wie verwenden wir jetzt Formeln für einige arithmetische Operationen? 00:00:21.724 --> 00:00:23.045 Lass uns das anschauen. 00:00:24.204 --> 00:00:29.426 Wie Sie sehen können, sind wir bei Übung 8 angekommen, nach Übung 1, Übung 2, Übung 3. 00:00:31.263 --> 00:00:34.904 Übung 8. In Lila. 00:00:35.484 --> 00:00:39.545 Alle Übungen zu Zahlen und Formeln sind lila. 00:00:40.745 --> 00:00:43.806 Jetzt, was von uns in Bezug auf arithmetische Formeln verlangt wird... 00:00:44.446 --> 00:00:47.967 ...ist, dass wir Formeln in die Zellen C4 und C7 eingeben. 00:00:49.387 --> 00:00:50.527 Für die Addition... 00:00:51.948 --> 00:00:52.848 ...habe ich es so gemacht. 00:00:52.848 --> 00:00:55.848 Ich habe 1, 2, 3, 4 hier geschrieben. 00:00:55.888 --> 00:00:58.369 Sie sehen jetzt den markierten Bereich in Gelb. 00:01:00.571 --> 00:01:04.953 Wir werden mit diesen Zahlen arbeiten, um zu verstehen, wie Formeln funktionieren. 00:01:05.553 --> 00:01:09.615 Wenn Sie zur Addition kommen, habe ich bereits die Formeln hier eingegeben. 00:01:10.376 --> 00:01:14.137 Schauen Sie, es ist eine Addition. 00:01:15.018 --> 00:01:17.479 Die Addition in Excel. 00:01:18.099 --> 00:01:19.280 Wie machen wir das? 00:01:20.500 --> 00:01:21.381 Wir sagen gleich. 00:01:22.340 --> 00:01:23.782 Wir schreiben Addieren. 00:01:24.143 --> 00:01:25.544 Wir öffnen eine Klammer. 00:01:25.624 --> 00:01:32.151 Wenn wir die Klammer öffnen, wird Excel automatisch nach Zahl 1, Zahl 2 und Zahl 3 fragen. 00:01:33.572 --> 00:01:41.920 Sie können einzeln markieren, aber da wir die Summe aller Zahlen in der Addition nehmen, was mache ich in diesem Beispiel? 00:01:42.541 --> 00:01:49.594 Ich wähle den gesamten Bereich von H4 bis K4 aus. 00:01:49.874 --> 00:01:53.336 Wenn ich auswähle, wird wie Sie sehen, ein gestrichenes Zeichen angezeigt. 00:01:53.356 --> 00:01:54.836 Dann schließe ich die Klammer. 00:01:55.417 --> 00:02:00.600 Ich drücke Enter und wie Sie sehen, ergibt die Summe von 1, 2, 3, 4 10. 00:02:01.640 --> 00:02:11.419 Auf der anderen Seite müssen wir wissen, dass die Subtraktion in Excel nicht als Funktion vorhanden ist. Es gibt verschiedene Möglichkeiten, dies zu tun. 00:02:11.579 --> 00:02:14.842 Eine davon, genauer gesagt zwei Möglichkeiten, verschiedene Wege zu gehen. 00:02:14.882 --> 00:02:21.447 Eine davon ist zum Beispiel, wenn wir 4 von 3 und 2 abziehen wollen. 00:02:21.667 --> 00:02:22.548 Wir wählen 4 aus. 00:02:22.748 --> 00:02:26.511 Dann fügen wir das Minuszeichen hinzu. 00:02:26.631 --> 00:02:28.273 Dann öffnen wir eine Klammer. 00:02:28.273 --> 00:02:30.895 Wir addieren 2 und 3. 00:02:33.211 --> 00:02:35.294 Die Antwort sollte minus eins sein, oder? 00:02:36.916 --> 00:02:40.661 Wie Sie sehen, gab es hier ein Problem mit dem Wert. 00:02:40.701 --> 00:02:41.502 Denn warum? 00:02:42.303 --> 00:02:49.496 Wie Sie sehen können, wenn Sie zwei Punkte verwenden, anstatt Plus ein Fehler auftritt. 00:02:49.636 --> 00:02:50.496 Was bedeutet das? 00:02:51.317 --> 00:02:59.002 Wenn Excel Ihnen einen Wert gibt, wenn Sie Fehler in Formeln machen, wissen Sie, dass Sie einen Fehler in der Formel gemacht haben. 00:02:59.083 --> 00:03:00.844 Sie müssen diese Formel korrigieren. 00:03:00.904 --> 00:03:06.508 Der einfachste Weg, die Formel zu korrigieren, ist, dies im obigen Formelbereich zu tun. 00:03:07.250 --> 00:03:08.311 Ich habe die Korrektur vorgenommen. 00:03:08.451 --> 00:03:09.291 Ich drücke Enter. 00:03:09.351 --> 00:03:10.692 Wie Sie sehen, unsere Antwort. 00:03:10.892 --> 00:03:11.431 Minus eins. 00:03:12.393 --> 00:03:14.054 Was können wir sonst noch tun? 00:03:14.133 --> 00:03:17.175 Zum Beispiel möchten wir 4 von 2 und 3 abziehen. 00:03:17.395 --> 00:03:19.177 Ich habe 4 unten wieder eingegeben. 00:03:19.717 --> 00:03:26.761 Dann habe ich -2 und -3 geschrieben, weil ich 2 und 3 abziehen werde. 00:03:29.142 --> 00:03:30.223 Dann gleich. 00:03:30.883 --> 00:03:32.244 Ich sagte Addieren. 00:03:33.823 --> 00:03:43.368 Wenn ich Addiere sage, und diese Zahlen, die ich negativ gemacht habe, in die Addition einbeziehe, ist die Antwort wieder minus eins. 00:03:43.448 --> 00:03:46.589 Sie können diese beiden Methoden auch für die Subtraktion verwenden. 00:03:48.450 --> 00:03:54.893 Für die Multiplikation hat Excel die richtige Verwendung übernommen. 00:03:55.013 --> 00:03:56.734 Sie kennen das Malsetz. 00:03:57.634 --> 00:04:02.817 Lassen Sie uns eine Situation betrachten, in der wir zum Beispiel 1, 2, 3, 4 multiplizieren. 00:04:03.737 --> 00:04:05.399 Genau wie bei der Addition. 00:04:05.479 --> 00:04:08.521 Ich habe das Gleichheitszeichen eingegeben, die Formel geschrieben und die Klammer geöffnet. 00:04:09.663 --> 00:04:16.629 Ich habe den Bereich mit den Werten, von H4 bis K4, eingegeben. 00:04:16.869 --> 00:04:22.695 Dann habe ich die Klammer geschlossen, die Eingabetaste gedrückt, also Enter. 00:04:22.695 --> 00:04:31.661 24, 1 mal 2, 2, 2 mal 3, 6, 6 mal 4, 24. Jetzt kommen wir zur Division. 00:04:31.841 --> 00:04:34.382 Hier ist die richtige Verwendung für Excel. 00:04:35.503 --> 00:04:37.284 Wir sagen "geteilt durch". 00:04:39.826 --> 00:04:42.507 In Pie by Pie sagen wir. 00:04:44.514 --> 00:04:54.716 Wenn Sie sich an Brüche erinnern, erinnern Sie sich, dass der obere Teil des Bruchzeichens der Zähler und der untere Teil der Nenner war. 00:04:55.116 --> 00:05:01.377 Sie können also denken, dass es in Vier zwei Mal den Nenner gibt. 00:05:01.476 --> 00:05:02.476 Wir haben Vier geschrieben. 00:05:03.017 --> 00:05:04.017 Ein Komma gesetzt. 00:05:04.898 --> 00:05:05.978 Zwei ausgewählt. 00:05:06.618 --> 00:05:08.438 Dann haben wir die Klammer geschlossen. 00:05:08.958 --> 00:05:11.939 Wir haben die Eingabetaste gedrückt und wie Sie sehen, ist Ihre Antwort zwei. 00:05:14.577 --> 00:05:18.178 Dies sind natürlich die grundlegenden arithmetischen Formeln, die Sie in Excel verwenden werden. 00:05:18.338 --> 00:05:20.699 Daneben können wir zum Beispiel den Durchschnitt berechnen. 00:05:20.738 --> 00:05:21.738 Lassen Sie uns das zeigen. 00:05:25.020 --> 00:05:27.601 Was meinen wir mit Durchschnitt, Leute? 00:05:28.181 --> 00:05:31.563 Die Summe geteilt durch die Anzahl der Werte. 00:05:31.663 --> 00:05:32.783 Was haben wir hier gesagt? 00:05:32.843 --> 00:05:37.845 Die Summe ist 10. Wenn wir 10 durch 4 teilen, erhalten wir einen Durchschnitt. 00:05:40.445 --> 00:05:41.626 Wir schreiben den Durchschnitt. 00:05:44.153 --> 00:05:47.695 Nachdem wir die Durchschnittsformel geschrieben haben, setzen wir die Klammern. 00:05:48.716 --> 00:05:50.837 Dann wählen wir unsere Zahlenreihe aus. 00:05:50.957 --> 00:06:04.534 Wir schließen die Klammer und drücken Enter, und wie Sie sehen, lautet die Antwort 2,5. Angenommen, in einem System, in dem die Antwort zweieinhalb beträgt, möchte ich zwei Dezimalstellen mehr. 00:06:05.214 --> 00:06:08.898 Erhöhen Sie die Dezimalstelle in diesem Zahlenfeld. 00:06:09.318 --> 00:06:17.784 Wie Sie auf dem Bildschirm sehen können, ist es möglich, die erforderlichen Dezimalstellen im Dezimalstellen verringern-Feld auszuwählen. 00:06:19.166 --> 00:06:21.067 Ich drücke die Tasten Strg-S. 00:06:21.367 --> 00:06:23.729 Wir haben Übung 8 abgeschlossen und speichern.

WEBVTT 00:00:01.420 --> 00:00:06.081 Yes friends, our eighth exercise is about numbers and formulas. 00:00:07.621 --> 00:00:09.321 Why are numbers and formulas important? 00:00:09.362 --> 00:00:18.264 I had shown you formulas when I gave you some information about date settings and calendar related to formulas in history. 00:00:18.284 --> 00:00:21.664 Now, how do we use formulas for some arithmetic operations? 00:00:21.724 --> 00:00:23.045 Let's see that. 00:00:24.204 --> 00:00:29.426 As you can see, we started with exercise 1, then 2, then 3, and now we are at exercise 8. 00:00:31.263 --> 00:00:34.904 Exercise 8. In purple color. 00:00:35.484 --> 00:00:39.545 All our exercises related to numbers and formulas are in purple color. 00:00:40.745 --> 00:00:43.806 Now, what is asked from us regarding arithmetic formulas... 00:00:44.446 --> 00:00:47.967 ...is to enter formulas into the cells at C4 and C7 borders. 00:00:49.387 --> 00:00:50.527 For the addition operation... 00:00:51.948 --> 00:00:52.848 ...this is what I did. 00:00:52.848 --> 00:00:55.848 I wrote 1, 2, 3, 4 here. 00:00:55.888 --> 00:00:58.369 You can see the area marked in yellow right now. 00:01:00.571 --> 00:01:04.953 We will work with these numbers so that we can understand how formulas work as an example. 00:01:05.553 --> 00:01:09.615 When you come to the addition operation, I had already entered the formulas here. 00:01:10.376 --> 00:01:14.137 Look, it's the Sum operation. 00:01:15.018 --> 00:01:17.479 The equivalent of the addition operation in Excel. 00:01:18.099 --> 00:01:19.280 How do we do this? 00:01:20.500 --> 00:01:21.381 We say equals. 00:01:22.340 --> 00:01:23.782 We write sum. 00:01:24.143 --> 00:01:25.544 We open a parenthesis. 00:01:25.624 --> 00:01:32.151 As you can see when we open the parenthesis, Excel will automatically expect numbers 1, 2, and 3 from us. 00:01:33.572 --> 00:01:41.920 You have the chance to select them one by one, but since we are taking the sum of all numbers in the addition operation, what am I doing in this example? 00:01:42.541 --> 00:01:49.594 I am selecting the entire range from H4 to K4. 00:01:49.874 --> 00:01:53.336 When I select, as you can see around it, there is this dashed border. 00:01:53.356 --> 00:01:54.836 Then I close the parenthesis. 00:01:55.417 --> 00:02:00.600 I press Enter and as you can see, the sum of 1, 2, 3, 4 appears as 10. 00:02:01.640 --> 00:02:11.419 On the other hand, we need to know that the subtraction operation is not available as a function in Excel. There are various ways to do this. 00:02:11.579 --> 00:02:14.842 One of them, or rather two ways, various ways I mean. 00:02:14.882 --> 00:02:21.447 For example, if we want to subtract 3 and 2 from 4. 00:02:21.667 --> 00:02:22.548 We select 4. 00:02:22.748 --> 00:02:26.511 Then we add the minus sign. 00:02:26.631 --> 00:02:28.273 Then let's open a parenthesis. 00:02:28.273 --> 00:02:30.895 Let's add 2 and 3. 00:02:33.211 --> 00:02:35.294 The answer should be negative, right? 00:02:36.916 --> 00:02:40.661 As you can see, there is a problem here in terms of value. 00:02:40.701 --> 00:02:41.502 Because why? 00:02:42.303 --> 00:02:49.496 As you can see, when you use a colon instead of a plus sign, it gives an error. 00:02:49.636 --> 00:02:50.496 What does this mean? 00:02:51.317 --> 00:02:59.002 When Excel gives you a value for errors you made in formulas, know that you made a mistake in the formula. 00:02:59.083 --> 00:03:00.844 You need to go in and correct this formula. 00:03:00.904 --> 00:03:06.508 The easiest way to correct the formula is to perform this operation from the formula field above. 00:03:07.250 --> 00:03:08.311 I made the correction. 00:03:08.451 --> 00:03:09.291 I press Enter. 00:03:09.351 --> 00:03:10.692 As you can see, our answer. 00:03:10.892 --> 00:03:11.431 Is negative one. 00:03:12.393 --> 00:03:14.054 On the other hand, what else can we do? 00:03:14.133 --> 00:03:17.175 For example, we want to subtract 2 and 3 from 4. 00:03:17.395 --> 00:03:19.177 I rewrote 4 below. 00:03:19.717 --> 00:03:26.761 Then, since I will subtract 2 and 3, I wrote negative 2 and negative 3. 00:03:29.142 --> 00:03:30.223 Then equals. 00:03:30.883 --> 00:03:32.244 I said add. 00:03:33.823 --> 00:03:43.368 When I said add, as you can see, when I put these numbers that I made negative into the addition operation, the answer is again negative one. 00:03:43.448 --> 00:03:46.589 You can use these two methods for subtraction. 00:03:48.450 --> 00:03:54.893 For multiplication, the correct usage in Turkish is Excel. 00:03:55.013 --> 00:03:56.734 You know, it's the multiplication table. 00:03:57.634 --> 00:04:02.817 Let's imagine a situation where we multiply 1, 2, 3, 4 together for the multiplication operation. 00:04:03.737 --> 00:04:05.399 Exactly the same as addition. 00:04:05.479 --> 00:04:08.521 I entered the equal sign, wrote the formula, and opened the parentheses. 00:04:09.663 --> 00:04:16.629 I entered the range of values, from H4 to K4. 00:04:16.869 --> 00:04:22.695 Then I closed the parentheses, pressed the enter key. 00:04:22.695 --> 00:04:31.661 24, 1 times 2, 2, 2 times 3, 6, 6 times 4, 24. Now when we come to the division operation, Division is here. 00:04:31.841 --> 00:04:34.382 This time the correct usage for Excel. 00:04:35.503 --> 00:04:37.284 We say equal division. 00:04:39.826 --> 00:04:42.507 In Pie by pie, it says if you notice. 00:04:44.514 --> 00:04:54.716 If you remember fractions, for those who remember fractions, the part above the division sign was the numerator and the part below was the denominator. 00:04:55.116 --> 00:05:01.377 So, for example, in four, you can think how many times two is in the denominator. 00:05:01.476 --> 00:05:02.476 We wrote four. 00:05:03.017 --> 00:05:04.017 Put a comma. 00:05:04.898 --> 00:05:05.978 Selected two. 00:05:06.618 --> 00:05:08.438 Then we closed the parentheses. 00:05:08.958 --> 00:05:11.939 Pressed the enter key and as you can see, your answer is two. 00:05:14.577 --> 00:05:18.178 Of course, these are the basic arithmetic formulas you will use in Excel. 00:05:18.338 --> 00:05:20.699 Besides this, for example, we can calculate the average. 00:05:20.738 --> 00:05:21.738 Let's show this as well. 00:05:25.020 --> 00:05:27.601 What do we mean by average, friends? 00:05:28.181 --> 00:05:31.563 It is the division of the sum by the number of values. 00:05:31.663 --> 00:05:32.783 For example, what did we say here? 00:05:32.843 --> 00:05:37.845 The total is 10. When we divide 10 by 4, it will give us an average of 2.5. 00:05:40.445 --> 00:05:41.626 We write the average. 00:05:44.153 --> 00:05:47.695 After writing the average formula, we put our parentheses. 00:05:48.716 --> 00:05:50.837 Then we select our number sequence. 00:05:50.957 --> 00:06:04.534 We close the parentheses, press enter, and as you can see, the answer is 2.5. Let's say in a scenario where the answer is two and a half, I want two decimal places. 00:06:05.214 --> 00:06:08.898 Increase the decimal place in the number field. 00:06:09.318 --> 00:06:17.784 As you see on the screen, it is possible to select the necessary decimal values from the decrease decimal place field. 00:06:19.166 --> 00:06:21.067 I press Control-S keys. 00:06:21.367 --> 00:06:23.729 We have completed Exercise 8 and we are saving.

WEBVTT 00:00:01.420 --> 00:00:06.081 Evet arkadaşlar, sekizinci alıştırmamız sayılar ve formüller. 00:00:07.621 --> 00:00:09.321 Sayılar ve formüller neden önemli? 00:00:09.362 --> 00:00:18.264 Size formüllerle ilgili tarihte bir tarih ayarları ve takvimle ilgili size bazı bilgiler verdiğimde formülleri göstermiştim. 00:00:18.284 --> 00:00:21.664 Şimdi formülleri bazı aritmatik işlemleri için nasıl kullanıyoruz? 00:00:21.724 --> 00:00:23.045 Buna bakalım. 00:00:24.204 --> 00:00:29.426 Gördüğünüz gibi baştan alıştırma 1, alıştırma 2, alıştırma 3 geldik, alıştırma 8'deyiz. 00:00:31.263 --> 00:00:34.904 Alıştırma 8. Mor renkte. 00:00:35.484 --> 00:00:39.545 Sayılar ve formüllerle ilgili olan tüm alıştırmalarımızın hepsi mor renkte. 00:00:40.745 --> 00:00:43.806 Şimdi arıkmetik formüllerle ilgili bizden istenen şey... 00:00:44.446 --> 00:00:47.967 ...C4 ve C7 sınırındaki hücrelere formülleri girmemiz. 00:00:49.387 --> 00:00:50.527 Toplama işlemi için... 00:00:51.948 --> 00:00:52.848 ...şöyle yaptım ben. 00:00:52.848 --> 00:00:55.848 1, 2, 3, 4 yazdım buraya. 00:00:55.888 --> 00:00:58.369 Şu sarıyla işaretli alanı görüyorsunuz şu anda. 00:01:00.571 --> 00:01:04.953 Bu sayılarla çalışacağız ki örnek olarak formüllerin nasıl çalıştığını anlayabilelim. 00:01:05.553 --> 00:01:09.615 Toplama işlemine geldiğinizde burada zaten formülleri girmiştim. 00:01:10.376 --> 00:01:14.137 Bakın, Topla işlemi oluyor. 00:01:15.018 --> 00:01:17.479 Toplama işleminin Excel'deki karşılığı. 00:01:18.099 --> 00:01:19.280 Nasıl yapıyoruz bunu? 00:01:20.500 --> 00:01:21.381 Eşittir diyoruz. 00:01:22.340 --> 00:01:23.782 Topla yazıyoruz. 00:01:24.143 --> 00:01:25.544 Parantez açıyoruz. 00:01:25.624 --> 00:01:32.151 Parantez açtığımızda gördüğünüz gibi Excel otomatik olarak bizden sayı 1, sayı 2 ve sayı 3 bekleyecek. 00:01:33.572 --> 00:01:41.920 Teker teker işaretleme şansınız var ama toplama işleminde bütün sayıların toplamını aldığımız için, ya bu örnekte ben ne yapıyorum? 00:01:42.541 --> 00:01:49.594 H4'den K4'e kadar Bütün alanı seçiyorum. 00:01:49.874 --> 00:01:53.336 Seçtiğim zaman etrafında gördüğünüz gibi şu kesili işaret oluyor. 00:01:53.356 --> 00:01:54.836 Sonra parantezi kapatıyorum. 00:01:55.417 --> 00:02:00.600 Enter'a basıyorum ve gördüğünüz gibi 1, 2, 3, 4'ün toplamı 10 olarak karşıma çıkıyor. 00:02:01.640 --> 00:02:11.419 Diğer bir yandan bilmemiz gereken çıkarma işleminin Excel'de fonksiyon olarak bulunmadığı Bunu yapmanın çeşitli yolları var. 00:02:11.579 --> 00:02:14.842 Bir tanesi, daha doğrusu iki tane yolu var çeşitli yolları derken. 00:02:14.882 --> 00:02:21.447 Bir tanesi mesela 4'den 3 ve 2'yi çıkarmak istiyoruz. 00:02:21.667 --> 00:02:22.548 4'ü seçtik. 00:02:22.748 --> 00:02:26.511 Sonra eksi işaretini ekledik. 00:02:26.631 --> 00:02:28.273 Sonra bir parantez açalım. 00:02:28.273 --> 00:02:30.895 2 ile 3'ü toplayalım. 00:02:33.211 --> 00:02:35.294 Cevabın eksi bir olması gerekiyor değil mi? 00:02:36.916 --> 00:02:40.661 Değer olarak gördüğünüz gibi burada bir sorun oluştu. 00:02:40.701 --> 00:02:41.502 Çünkü neden? 00:02:42.303 --> 00:02:49.496 Arada gördüğünüz gibi İki nokta işareti kullandığında artı yerine bir hata veriyor. 00:02:49.636 --> 00:02:50.496 Bu ne demek? 00:02:51.317 --> 00:02:59.002 Formüllerde yaptığınız hatalarda Excel size değer verdiğinde bilin ki formülün içerisinde bir hata yaptınız. 00:02:59.083 --> 00:03:00.844 Girip bu formülü düzeltmeniz lazım. 00:03:00.904 --> 00:03:06.508 Formülü düzeltmenin en kolay yolu da yukarıdaki formül alanından bu işlemi gerçekleştirmek. 00:03:07.250 --> 00:03:08.311 Düzeltmeyi yaptım. 00:03:08.451 --> 00:03:09.291 Enter'a basıyorum. 00:03:09.351 --> 00:03:10.692 Gördüğünüz gibi cevabımız. 00:03:10.892 --> 00:03:11.431 Eksi bir. 00:03:12.393 --> 00:03:14.054 Diğer bir yandan ne yapabiliriz? 00:03:14.133 --> 00:03:17.175 Mesela 4'tan 2 ve 3'ü çıkarmak istiyoruz. 00:03:17.395 --> 00:03:19.177 4'ü aşağıya tekrar yazdım. 00:03:19.717 --> 00:03:26.761 Sonra 2 ile 3'ü çıkaracağım için eksi 2. Eksi 3 yazdım. 00:03:29.142 --> 00:03:30.223 Sonra eşittir. 00:03:30.883 --> 00:03:32.244 Topla dedim. 00:03:33.823 --> 00:03:43.368 Topla dediğimde bu sayıları negatif hale getirdiğim sayıları toplama işlemine koyduğunda cevap gördüğünüz gibi yine eksi bir. 00:03:43.448 --> 00:03:46.589 Bu iki yolu da çıkarma işlemi için kullanabilirsiniz. 00:03:48.450 --> 00:03:54.893 Çarpma işlemi için Türkçe'de doğru olan kullanıma eksel almış. 00:03:55.013 --> 00:03:56.734 Biliyorsunuz çarpım tablosudur. 00:03:57.634 --> 00:04:02.817 Çarpım işlemi için mesela 1, 2, 3, 4'ü birbiriyle çarptığımız bir durumu düşünelim. 00:04:03.737 --> 00:04:05.399 Toplamayla birebir olarak aynı. 00:04:05.479 --> 00:04:08.521 Eşittiri girdim, formülü yazdım, parantezi açtım. 00:04:09.663 --> 00:04:16.629 Değerlerin olduğu alanı yani H4'den K4'de kadar girdim. 00:04:16.869 --> 00:04:22.695 Sonra parantezi kapattım, giriş tuşuna bastım yani enter tuşuna. 00:04:22.695 --> 00:04:31.661 24, 1 kere 2, 2, 2 kere 3, 6, 6 kere 4, 24. Şimdi bölme işlemine geldiğimizde Bölüm burada. 00:04:31.841 --> 00:04:34.382 Bu sefer doğru olan kullanım Excel için. 00:04:35.503 --> 00:04:37.284 Eşittir diyoruz bölüm. 00:04:39.826 --> 00:04:42.507 Pie by pie'de diyor farkındaysanız. 00:04:44.514 --> 00:04:54.716 Kesirleri hatırlarsanız, kesirleri hatırlayan arkadaşlar bölü işaretinin üstünde bulunan kısım pay altında bulunan kısım paydaydı. 00:04:55.116 --> 00:05:01.377 Yani mesela dördün içerisinde payda iki kaç kere var gibi düşünebilirsiniz. 00:05:01.476 --> 00:05:02.476 Dördü yazdık. 00:05:03.017 --> 00:05:04.017 Virgül koyduk. 00:05:04.898 --> 00:05:05.978 İkiyi seçtik. 00:05:06.618 --> 00:05:08.438 Sonra parantezi kapattık. 00:05:08.958 --> 00:05:11.939 Giriş tuşuna bastık ve gördüğünüz gibi cevabınız iki. 00:05:14.577 --> 00:05:18.178 Excel'de kullanacağınız temel aritmatik formüller tabii ki bu. 00:05:18.338 --> 00:05:20.699 Bunun yanısına mesela ortalama alabiliriz. 00:05:20.738 --> 00:05:21.738 Bunu da gösterelim. 00:05:25.020 --> 00:05:27.601 Ortalamadan kastettiğimiz şey ne arkadaşlar? 00:05:28.181 --> 00:05:31.563 Toplamın sayıları kaç tane değer olduğuna bölümü. 00:05:31.663 --> 00:05:32.783 Mesela burada ne demiştik? 00:05:32.843 --> 00:05:37.845 Toplam 10. 10'u 4'e böldüğümüz zaman bize bir ortalama verecek. 00:05:40.445 --> 00:05:41.626 Ortalama yazıyoruz. 00:05:44.153 --> 00:05:47.695 Ortalama formülünü yazdıktan sonra parantezimizi koyuyoruz. 00:05:48.716 --> 00:05:50.837 Sonra sayı dizimizi seçiyoruz. 00:05:50.957 --> 00:06:04.534 Parantezi kapatıp enter'a basıyoruz ve gördüğünüz gibi cevap 2.5. Diyelim ki cevabın iki buçuk olduğu bir düzende ben ondalık olarak daha iki ondalık değer istiyorum. 00:06:05.214 --> 00:06:08.898 Sayı alanında geldiğiniz bu ondalık artır. 00:06:09.318 --> 00:06:17.784 Ekranla gördüğünüz gibi ondalık azalt alanından gerekli olan ondalık değerlerini seçmeniz mümkün. 00:06:19.166 --> 00:06:21.067 Control-S tuşlarına basıyorum. 00:06:21.367 --> 00:06:23.729 Alıştırma 8'i bitirdik ve kaydediyoruz.