Yüzde

WEBVTT 00:00:00.249 --> 00:00:06.475 In diesem Teil unseres Videos werden wir sehen, wie wir die Abschnittsberechnungen korrekt durchführen können. 00:00:06.976 --> 00:00:08.237 Wenn Sie bereit sind, lassen Sie uns beginnen. 00:00:08.938 --> 00:00:15.044 Zunächst wurde uns aufgefordert, eine Formel einzugeben, die den Bereich von B4 bis B8 addiert und in die Zelle B9 einträgt. 00:00:15.084 --> 00:00:17.186 Wir wurden also gebeten, diesen Bereich hier zu addieren. 00:00:17.806 --> 00:00:19.448 Ich habe die automatische Summe verwendet. 00:00:19.668 --> 00:00:20.669 Der Bereich wurde ausgewählt. 00:00:20.870 --> 00:00:21.851 Ich habe dann Enter gedrückt. 00:00:22.531 --> 00:00:23.713 Wie Sie sehen, haben wir die Summe gefunden. 00:00:24.814 --> 00:00:29.599 Es wurde gefordert, eine Formel einzugeben, die die Zelle B4 in die Zelle C4 einträgt. 00:00:30.520 --> 00:00:35.186 Damit die Formel beim Kopieren nicht verrutscht, sollten Sie die Zelle B9 in der Formel fixieren. 00:00:35.867 --> 00:00:37.088 Lassen Sie uns das gemeinsam betrachten. 00:00:37.993 --> 00:00:47.396 Wir wurden gebeten, herauszufinden, wie der Prozentsatz von 28.000 in 127.720 ist. 00:00:48.236 --> 00:00:52.017 Zuerst habe ich ein Gleichheitszeichen geschrieben, da ich eine Formel schreiben werde. 00:00:52.317 --> 00:00:55.178 Dann habe ich die Schlüssel hier eingegeben. 00:00:56.178 --> 00:01:00.559 Ich habe das Trennzeichen auf meiner Tastatur angeklickt. 00:01:01.259 --> 00:01:02.820 Wie Sie sehen, wurde das Symbol eingefügt. 00:01:03.040 --> 00:01:06.861 Dann habe ich den Gesamtwert hier eingegeben und Enter gedrückt. 00:01:07.521 --> 00:01:13.245 Wie Sie sehen, beträgt dieser Wert 22% des Gesamtwerts. 00:01:13.425 --> 00:01:14.586 Wir haben das festgestellt. 00:01:15.147 --> 00:01:19.230 Wie Sie sehen können, habe ich das angewendet, um es in anderen Zeilen anzuwenden. 00:01:20.150 --> 00:01:22.872 Aber hier hat es uns einen Fehler gemeldet. 00:01:23.093 --> 00:01:26.755 Lassen Sie uns zunächst die Formeln identifizieren, die diese beeinflussen. 00:01:28.236 --> 00:01:40.541 Um diesen Prozentsatz zu berechnen, haben wir das Einkommen und das Gesamteinkommen verwendet, aber wenn wir den Wert betrachten, der uns einen Fehler gemeldet hat, hat er das Einkommen von uns genommen, 00:01:41.621 --> 00:01:55.245 aber den Gesamtwert eine Zelle darunter genommen, was bedeutet, dass er den Gesamtwert nicht erkannt hat. Ich entferne die Pfeile hier und 00:01:55.306 --> 00:02:05.569 gehe wie angewiesen zur Zelle hier und fixiere sie auf B9 mit der F4-Taste auf meiner Tastatur. 00:02:06.029 --> 00:02:19.871 Wenn ich das fixiere und diese Aktion auf die unteren Spalten und Zeilen anwende, wird das Gesamteinkommen niemals eine Zeile nach unten gehen. 00:02:20.131 --> 00:02:21.994 Das wird fixiert sein. 00:02:22.054 --> 00:02:25.098 Wie Sie sehen, habe ich die Eingabetaste gedrückt. 00:02:25.638 --> 00:02:29.724 Die Formel zeigt wieder das Dollarzeichen, B Dollarzeichen 9. 00:02:31.185 --> 00:02:33.168 Normalerweise ist unsere Zelle B9. 00:02:36.537 --> 00:02:40.280 Wenn ich das ziehe, haben wir wie Sie sehen kein Problem. 00:02:40.900 --> 00:02:46.264 Um dies zu bestätigen, lassen Sie uns mit dem AutoSum-Werkzeug die Summe dieser Prozentsätze berechnen. 00:02:46.744 --> 00:02:49.606 Wenn es zu 100 % ist, gibt es hier kein Problem. 00:02:50.567 --> 00:02:53.029 Wie Sie sehen, haben wir auch unsere Bestätigung erhalten. 00:02:53.830 --> 00:02:55.391 Wir haben die Aufgaben hier erfolgreich abgeschlossen. 00:02:56.872 --> 00:03:00.716 Unser nächster Schritt ist es, die Zelle C4 in die Zellbereiche C5-C8 zu kopieren. 00:03:01.476 --> 00:03:02.237 Das haben wir erledigt. 00:03:02.457 --> 00:03:06.901 Geben Sie die Formel ein, die die Zellbereiche C4-C8 für Zelle C9 summiert. 00:03:06.961 --> 00:03:08.403 Auch das haben wir erfolgreich erledigt. 00:03:09.144 --> 00:03:11.566 Wie Sie sehen, war das unser Workflow. 00:03:12.407 --> 00:03:13.267 Ich wünsche Ihnen viel Erfolg. 00:03:13.608 --> 00:03:14.869 Bis zum nächsten Video.

WEBVTT 00:00:00.249 --> 00:00:06.475 In this part of our video, we will see how to correctly perform face value exercises. 00:00:06.976 --> 00:00:08.237 If you are ready, let's get started. 00:00:08.938 --> 00:00:15.044 First of all, we were asked to enter a formula that sums the range B4-B8 in cell B9. 00:00:15.084 --> 00:00:17.186 In other words, we were asked to sum this range here. 00:00:17.806 --> 00:00:19.448 I used the automatic sum for this. 00:00:19.668 --> 00:00:20.669 The range was selected. 00:00:20.870 --> 00:00:21.851 I pressed Enter. 00:00:22.531 --> 00:00:23.713 As you can see, we found the sum. 00:00:24.814 --> 00:00:29.599 It was asked to enter a formula in cell C4 that calculates the cell of B4 in the total. 00:00:30.520 --> 00:00:35.186 To prevent the formula from changing when copied, fix cell B9 within the formula. 00:00:35.867 --> 00:00:37.088 Let's look at this together. 00:00:37.993 --> 00:00:47.396 We were asked how to find the percentage value of 28,000 in 127,720 from here. 00:00:48.236 --> 00:00:52.017 First, I wrote an equal sign because I will write a formula. 00:00:52.317 --> 00:00:55.178 Then I typed the keys here. 00:00:56.178 --> 00:01:00.559 I clicked on the division symbol on my keyboard. 00:01:01.259 --> 00:01:02.820 As you can see, the symbol appeared. 00:01:03.040 --> 00:01:06.861 Then I typed the total value here and pressed Enter. 00:01:07.521 --> 00:01:13.245 As you can see, this value is 22% of the total value. 00:01:13.425 --> 00:01:14.586 We have identified this. 00:01:15.147 --> 00:01:19.230 As you can see, I applied this in other rows like this. 00:01:20.150 --> 00:01:22.872 But it gave us an error here. 00:01:23.093 --> 00:01:26.755 First, let's identify what affects these in the formulas. 00:01:28.236 --> 00:01:40.541 To calculate the percentage here, we used income and total income, but if we look at the value that gives an error below, it took the income from us here 00:01:41.621 --> 00:01:55.245 but it took the total value from one cell below, so in this case, it does not recognize the total value, I remove the arrows here and 00:01:55.306 --> 00:02:05.569 as instructed, I come to this cell here and fix it to B9 with the F4 key on my keyboard. 00:02:06.029 --> 00:02:19.871 When I fix it, if I apply this operation to the rows below, the Total Income will never be one row below here. 00:02:20.131 --> 00:02:21.994 This will be fixed. 00:02:22.054 --> 00:02:25.098 As you can see, I pressed Enter. 00:02:25.638 --> 00:02:29.724 The formula still shows the dollar sign, B dollar sign 9. 00:02:31.185 --> 00:02:33.168 Our cell, which was normally B9. 00:02:36.537 --> 00:02:40.280 When I drag it from here, as you can see, we didn't have any problems. 00:02:40.900 --> 00:02:46.264 Let's also use the AutoSum tool to calculate the sum of these percentages to confirm. 00:02:46.744 --> 00:02:49.606 If it's 100%, then there is no problem here. 00:02:50.567 --> 00:02:53.029 As you can see, we have also confirmed. 00:02:53.830 --> 00:02:55.391 We have successfully completed the tasks here. 00:02:56.872 --> 00:03:00.716 Our next step is to copy cell C4 to the ranges C5-C8. 00:03:01.476 --> 00:03:02.237 We've done that. 00:03:02.457 --> 00:03:06.901 Enter the formula summing the ranges C4-C8 into cell C9. 00:03:06.961 --> 00:03:08.403 We have also successfully completed this. 00:03:09.144 --> 00:03:11.566 As you can see, this was our routine. 00:03:12.407 --> 00:03:13.267 I wish you success. 00:03:13.608 --> 00:03:14.869 See you in the next video.

WEBVTT 00:00:00.249 --> 00:00:06.475 Videomuzun bu kısmında yüzü hesabı alıştırmaları kısmını nasıl doğru şekilde yapacağımızı göreceğiz. 00:00:06.976 --> 00:00:08.237 Hazırsanız gelin başlayalım. 00:00:08.938 --> 00:00:15.044 Öncelikle olarak B9 sucesine B4-B8 füze aralığını toplayan bir formül girmemiz istenmiş. 00:00:15.084 --> 00:00:17.186 Yani şu aralığı şuraya toplamamız istenmiş. 00:00:17.806 --> 00:00:19.448 Bu da ben otomatik toplamı kullandım. 00:00:19.668 --> 00:00:20.669 Aralık seçili geldi. 00:00:20.870 --> 00:00:21.851 Ardına Enter bastım. 00:00:22.531 --> 00:00:23.713 Gördüğünüz üzere toplamı bulduk. 00:00:24.814 --> 00:00:29.599 C4 hücresine B4 hücresinin toplamdaki hücresini hesaplayan bir formül girin demiş. 00:00:30.520 --> 00:00:35.186 Bu formülü kopyalandığında bir yatağa çıkmaması için formül içerisinde B9 hücresini sabitleyin. 00:00:35.867 --> 00:00:37.088 Gelin buna bir beraber bakalım. 00:00:37.993 --> 00:00:47.396 Biz de buradan 28.000 sayısının 127.720 içerisindeki % değerini nasıl bulacağımızı istemiş. 00:00:48.236 --> 00:00:52.017 Burada öncelikle bir eşittir yazdım çünkü formül yazacağım. 00:00:52.317 --> 00:00:55.178 Ardından keyleri buraya yazdım. 00:00:56.178 --> 00:01:00.559 Klavyemde bulunan yan çizgi yani bölme sembolünü tıkladım. 00:01:01.259 --> 00:01:02.820 Gördüğünüz üzere sembolü çıktı. 00:01:03.040 --> 00:01:06.861 Ardından toplam değeri buraya yazdım ve enter'a bastım. 00:01:07.521 --> 00:01:13.245 Gördüğünüz üzere bu değerin toplam değer içindeki yüzde 22'ymiş. 00:01:13.425 --> 00:01:14.586 Bunu tespit etmiş olduk. 00:01:15.147 --> 00:01:19.230 Bunu diğer satırlarda uygulamak için gördüğünüz üzere çektim şu şekilde. 00:01:20.150 --> 00:01:22.872 Fakat burada bize bir hata verdi. 00:01:23.093 --> 00:01:26.755 Öncelikle gelin bunları formüllerden etkileyenlerini tespit edelim. 00:01:28.236 --> 00:01:40.541 Buradaki yüzdeyi hesaplayabilmek için gelire ve toplam geliri kullandık fakat bir altındakine hata veren değere bakarsak eğer burada bizden geliri almış 00:01:41.621 --> 00:01:55.245 fakat toplam değeri bir hücre aşağıdan almış yani bu durumda toplam değeri algılamamış oluyor buradaki hesaplamalarımız buradaki okları kaldırıyorum ve 00:01:55.306 --> 00:02:05.569 bize talimatları söylendiği gibi buradaki hücreye gelip B9'a Klavyemde bulunan F4 tuşu ile sabitliyorum. 00:02:06.029 --> 00:02:19.871 Sabitlediğimde eğer ben bu işlemi aşağıdaki stünlere, aşağıdaki satırlara da uygulamam halinde Toplam gelir, burada asla bir satır aşağıya kalmayacak. 00:02:20.131 --> 00:02:21.994 Bu sabitlenmiş olacak. 00:02:22.054 --> 00:02:25.098 Bunu gördüğünüz üzere Enter'e bastım. 00:02:25.638 --> 00:02:29.724 Formülü de yine dolar işareti, B dolar işareti 9 olarak gözüküyor. 00:02:31.185 --> 00:02:33.168 Normalde B9 olan hücremiz. 00:02:36.537 --> 00:02:40.280 Buradan tutup çektiğim zaman gördüğünüz üzere hiç bir sorun yaşamadık. 00:02:40.900 --> 00:02:46.264 Bir de bunu teyit etmek için gelin otomatik toplam aracı ile bu yüzlülerin toplumunu hesap edelim. 00:02:46.744 --> 00:02:49.606 Eğer %100 ise burada bir problem yok demektir. 00:02:50.567 --> 00:02:53.029 Gördüğünüz üzere teyidimizi de yapmış olduk. 00:02:53.830 --> 00:02:55.391 Buradaki işlerin başarıyla tamamladık. 00:02:56.872 --> 00:03:00.716 Bir sonraki işlemimiz C4 fücresini C5-C8 fücre aralarına kopyalayın. 00:03:01.476 --> 00:03:02.237 Bunu hallettik. 00:03:02.457 --> 00:03:06.901 C9 fücresine C4-C8 fücre aralarını toplayan reformu girin. 00:03:06.961 --> 00:03:08.403 Bunu da başarıyla hallettik. 00:03:09.144 --> 00:03:11.566 Gördüğünüz üzere alışımımız bu kadardı. 00:03:12.407 --> 00:03:13.267 Başarılar diliyorum. 00:03:13.608 --> 00:03:14.869 Bir sonraki videoda görüşmek üzere.