Kira Hesapları 3

WEBVTT 00:00:00.409 --> 00:00:05.156 Ja, Freunde, wie ihr wisst, haben wir die Quelle bei der Fertigstellung des 5. Vorgangs übergeben. 00:00:05.736 --> 00:00:10.202 Und wir haben gesehen, wie wir das D5-Virus, das wir für die erste Formel des C13-Virus verwendet haben, stabilisieren können. 00:00:10.723 --> 00:00:15.249 Dementsprechend haben wir den Zellbereich C14-C17 kopiert. 00:00:15.848 --> 00:00:19.892 Wir haben diese Formel und wie ihr wisst, die Ausgaben der anderen Familien identifiziert. 00:00:20.753 --> 00:00:24.517 Wenn ihr möchtet, können wir kommen und uns die Gesamtsumme dieser Ausgaben ansehen, um dies zu bestätigen. 00:00:24.657 --> 00:00:26.879 Die Gesamtsumme sollte 7.525 betragen. 00:00:27.560 --> 00:00:31.564 Hier bin ich wieder in unser Eingangsmenü gegangen und habe auf die Option für die automatische Gesamtsumme geklickt. 00:00:31.724 --> 00:00:33.026 Es wurde dieser Bereich ausgewählt. 00:00:33.746 --> 00:00:36.348 Als ich Enter gedrückt habe, waren es 2525 TL. 00:00:36.909 --> 00:00:39.112 Hier haben wir die Bestätigung erfolgreich abgeschlossen. 00:00:40.866 --> 00:00:42.487 Lass uns das in Rot markieren. 00:00:43.268 --> 00:00:44.229 Erfolgreich abgeschlossen. 00:00:44.710 --> 00:00:49.775 Hier wurde auch eine Formatierung der Währung in der Spanne B4-B8 in TL angefordert. 00:00:50.296 --> 00:00:52.037 Hier ist der Bereich B4-B8. 00:00:52.537 --> 00:01:00.487 Wie ihr wisst, zeigt mir das Währungssymbol im Eingangsmenü sofort neben der Tür, wenn ich es aufhänge, die Währungen an. 00:01:00.927 --> 00:01:03.610 Ich habe die Option Türkei, Türkei ausgewählt. 00:01:04.291 --> 00:01:08.276 Wie ihr sehen könnt, haben wir die Währungsformatierung erfolgreich angewendet. 00:01:09.437 --> 00:01:11.940 Unser nächster Schritt hier ist der achte Schritt. 00:01:12.621 --> 00:01:15.364 Unser achter Schritt ist die Formatierung in Zelle B8. 00:01:16.345 --> 00:01:22.949 Es wurde gefordert, die Formatierung in Zelle D5 zu kopieren und dann in den Zellen C13-C18 anzuwenden. 00:01:23.950 --> 00:01:26.872 Lassen Sie uns die Formatierung in Zelle B8 überprüfen. 00:01:27.072 --> 00:01:32.095 Wir werden die Formatfarbe in Zelle B8 verwenden, um die Formatierung hier zu kopieren. 00:01:32.956 --> 00:01:36.878 Ich habe es ausgewählt und werde es in Zelle D5 anwenden. 00:01:37.659 --> 00:01:40.700 Ich habe Zelle D5 gefunden und angewendet. 00:01:42.401 --> 00:01:43.222 Wie Sie sehen können. 00:01:45.407 --> 00:02:08.631 Der nächste Schritt ist, denselben Vorgang auch im Zellenbereich C13-C18 durchzuführen. Ich habe es auf Zelle C18 angewendet, wie Sie sehen können. Wir haben diesen Schritt erfolgreich abgeschlossen. 00:02:10.593 --> 00:02:15.336 Unser nächster Schritt ist, die Länge von DS2 an die Länge des Inhalts anzupassen. 00:02:16.737 --> 00:02:17.778 Ich schaue mir DS2 an. 00:02:19.268 --> 00:02:23.873 Wie du weißt, ist der Text hier jetzt über das E-Studio hinausgegangen. 00:02:24.373 --> 00:02:26.135 Wir haben zwei Möglichkeiten, dies zu tun. 00:02:26.175 --> 00:02:27.395 Erstens, den Text zu verschieben. 00:02:27.616 --> 00:02:32.020 Wenn ich den Text verschiebe, wird der Text geteilt. 00:02:32.901 --> 00:02:34.843 Eine andere Möglichkeit, die wir haben. 00:02:35.844 --> 00:02:38.367 Ich habe den Text hier nach unten verschoben. 00:02:38.488 --> 00:02:41.772 Ein Doppelklick zwischen Spalte D und E. 00:02:41.912 --> 00:02:46.657 Dies stellt die optimale Breite gemäß dem Text sicher. 00:02:47.720 --> 00:02:49.702 Das haben wir erfolgreich umgesetzt. 00:02:49.862 --> 00:02:50.924 Ich habe die Methoden gezeigt. 00:02:51.204 --> 00:02:57.847 Unsere letzte Aktion hier ist die Anwendung der Quadratmeterformatierung auf den Zellenbereich B13-B17. 00:02:58.748 --> 00:03:02.470 Das Ergebnis sollte beispielsweise wie 82 Quadratmeter aussehen. 00:03:02.610 --> 00:03:08.293 Wie Sie wissen, handelt es sich hier um Flächen, die in Quadratmetern angezeigt werden sollen. 00:03:08.453 --> 00:03:17.797 Um dies zu erreichen, habe ich die Zellen ausgewählt, die Quadratmeter erfordern, und mit der rechten Maustaste darauf geklickt. 00:03:18.037 --> 00:03:22.279 Dann erscheint die Option 'Zellen formatieren'. 00:03:22.559 --> 00:03:23.199 Ich klicke darauf. 00:03:24.199 --> 00:03:29.680 Dann erscheinen einige Kategorien, die wir auswählen müssen. 00:03:30.520 --> 00:03:32.139 Es gibt hier einige Optionen. 00:03:32.220 --> 00:03:35.201 Tatsächlich sind dies die Optionen, die im obigen Menü erscheinen. 00:03:35.841 --> 00:03:39.741 Hier wird auch etwas manuell angezeigt. 00:03:40.482 --> 00:03:44.542 Was wir hier tun müssen, ist eine benutzerdefinierte Option gefolgt von einer Ganzzahl. 00:03:45.122 --> 00:03:48.203 Aber es gibt hier eine wichtige Sache zu beachten. 00:03:48.803 --> 00:03:52.285 Um dies zu erreichen, benötigen wir wiederum ein Leerzeichen nach der Null. 00:03:52.946 --> 00:03:54.747 Dann öffne ich Anführungszeichen. 00:03:57.149 --> 00:03:57.629 Ich sage M. 00:03:58.510 --> 00:04:01.151 Dann habe ich das Quadrat von M hinzugefügt. 00:04:01.872 --> 00:04:03.173 Ich schließe wieder meine Anführungszeichen. 00:04:05.214 --> 00:04:08.816 Sie können dies auch einfach kopieren. 00:04:09.577 --> 00:04:12.179 Dann speichere ich dies, indem ich auf OK klicke. 00:04:13.055 --> 00:04:16.139 Wie Sie sehen können, bleibt die Operation hier immer noch konstant. 00:04:16.339 --> 00:04:22.186 Wir haben nur ein zusätzliches Detail vor den Zahlenwert hier hinzugefügt. 00:04:23.226 --> 00:04:25.650 So haben wir das erledigt. 00:04:26.630 --> 00:04:27.392 Ich wünsche Ihnen viel Erfolg.

WEBVTT 00:00:00.409 --> 00:00:05.156 Yes, friends, as you know, we delivered the source when completing the 5th operation. 00:00:05.736 --> 00:00:10.202 And we saw how to stabilize the D5 virus we used for the first formulation of the C13 virus. 00:00:10.723 --> 00:00:15.249 As a result, we copied the C14-C17 cell range. 00:00:15.848 --> 00:00:19.892 With this formula, we have also identified the expenses of other families, as you know. 00:00:20.753 --> 00:00:24.517 If you want, let's come and look at the total of these expense shares to confirm. 00:00:24.657 --> 00:00:26.879 The total should be 7,525. 00:00:27.560 --> 00:00:31.564 Here, I clicked on the remaining automatic total option in our entry menu again. 00:00:31.724 --> 00:00:33.026 We were brought to this range. 00:00:33.746 --> 00:00:36.348 When I hit Enter, it became 2525 TL. 00:00:36.909 --> 00:00:39.112 Here, we have successfully completed the confirmation process. 00:00:40.866 --> 00:00:42.487 Let's highlight this in red. 00:00:43.268 --> 00:00:44.229 Successfully completed. 00:00:44.710 --> 00:00:49.775 Here, a currency formatting application in TL currency was requested for the B4-B8 range. 00:00:50.296 --> 00:00:52.037 This is the B4-B8 range. 00:00:52.537 --> 00:01:00.487 As you know, in the entry menu, when I click on the door icon right next to the currency symbol, it shows me the currencies. 00:01:00.927 --> 00:01:03.610 I selected Turkey, Turkey from here. 00:01:04.291 --> 00:01:08.276 As you can see, we have successfully applied the currency formatting as well. 00:01:09.437 --> 00:01:11.940 Our next step here is the eighth step. 00:01:12.621 --> 00:01:15.364 Our eighth step is to format the B8 cell. 00:01:16.345 --> 00:01:22.949 We have been asked to move it to the D5 cell and then to the cell range C13-C18. 00:01:23.950 --> 00:01:26.872 Let's take a look at the formatting in the B8 cell. 00:01:27.072 --> 00:01:32.095 We will use the format painter here in the B8 cell to copy the formatting. 00:01:32.956 --> 00:01:36.878 I have selected it here and the place we want to apply it is the D5 cell. 00:01:37.659 --> 00:01:40.700 I found the D5 cell here and applied it. 00:01:42.401 --> 00:01:43.222 As you can see. 00:01:45.407 --> 00:02:08.631 the next operation we need to do is to apply the same operation to the cell range C13-C18, I applied this operation to the C18 range as you can see, we have successfully completed this operation as well. 00:02:10.593 --> 00:02:15.336 Our next step is to adjust the length of DS2 to fit the length of the content. 00:02:16.737 --> 00:02:17.778 I'm looking at DS2. 00:02:19.268 --> 00:02:23.873 As you know, the text here has overflowed onto the E studio. 00:02:24.373 --> 00:02:26.135 We have two methods to handle this overflow. 00:02:26.175 --> 00:02:27.395 The first one is to shift the text. 00:02:27.616 --> 00:02:32.020 If I shift the text, the text will be split into two. 00:02:32.901 --> 00:02:34.843 Another operation we can do besides this. 00:02:35.844 --> 00:02:38.367 I have activated the text shift here. 00:02:38.488 --> 00:02:41.772 Double-clicking the space between columns D and E. 00:02:41.912 --> 00:02:46.657 Here, it provides the optimum width according to the text. 00:02:47.720 --> 00:02:49.702 We have successfully implemented this. 00:02:49.862 --> 00:02:50.924 I have shown the methods. 00:02:51.204 --> 00:02:57.847 Our final operation here is to apply square meter formatting to the B13-B17 cell range. 00:02:58.748 --> 00:03:02.470 Ultimately, it is desired to appear as 82 square meters, for example. 00:03:02.610 --> 00:03:08.293 As you know, these are areas and they need to appear as square meters. 00:03:08.453 --> 00:03:17.797 In order to achieve this, I selected the cells that have square meters and right-clicked. 00:03:18.037 --> 00:03:22.279 Then, as you can see, there is an option to format cells. 00:03:22.559 --> 00:03:23.199 I click on that. 00:03:24.199 --> 00:03:29.680 And then, a number of things that we need to select as a category appeared in front of us. 00:03:30.520 --> 00:03:32.139 There are some options here. 00:03:32.220 --> 00:03:35.201 Actually, these are the options that appear in the menu above. 00:03:35.841 --> 00:03:39.741 Here, they are also presented a bit manually. 00:03:40.482 --> 00:03:44.542 What we need to do here is to customize it according to our preference and then enter a whole number. 00:03:45.122 --> 00:03:48.203 But there is a detail that needs to come before that. 00:03:48.803 --> 00:03:52.285 In order to do this, again, a space after zero. 00:03:52.946 --> 00:03:54.747 Then I open the quotation mark. 00:03:57.149 --> 00:03:57.629 I say 'M'. 00:03:58.510 --> 00:04:01.151 Then I put the square of M. 00:04:01.872 --> 00:04:03.173 I close my quotation again. 00:04:05.214 --> 00:04:08.816 You can copy this ready if you want. 00:04:09.577 --> 00:04:12.179 Then I save it by saying okay. 00:04:13.055 --> 00:04:16.139 As you can see, the operation here still remains constant. 00:04:16.339 --> 00:04:22.186 We just added an extra detail in front of the number value here. 00:04:23.226 --> 00:04:25.650 And we handled it like this. 00:04:26.630 --> 00:04:27.392 I wish you success.

WEBVTT 00:00:00.409 --> 00:00:05.156 Evet arkadaşlar bildiğiniz üzere 5. işlemi tamamlarken kaynağı teslim ettik. 00:00:05.736 --> 00:00:10.202 Ve C13 virüsün ilk formüle kullandığımız D5 virüsünü nasıl sabitleyeceğimizi gördük. 00:00:10.723 --> 00:00:15.249 Buna bağlı olarak da C14-C17 hücre aralığını kopyaladık. 00:00:15.848 --> 00:00:19.892 Bu formülü ve bildiğiniz üzere diğer ailelerinde giderlerini tespit etmiş olduk. 00:00:20.753 --> 00:00:24.517 Bunu teyit edebilmek için isterseniz gelin bu gider paylarının bir toplamına bakalım. 00:00:24.657 --> 00:00:26.879 Toplamın 7.525 olması gerekiyor. 00:00:27.560 --> 00:00:31.564 Burada gelip yine giriş menümüze kalan otomatik toplam seçeneğini tıkladım. 00:00:31.724 --> 00:00:33.026 Bize bu aralık seçil geldi. 00:00:33.746 --> 00:00:36.348 Entre bastımda 2525 TL oldu. 00:00:36.909 --> 00:00:39.112 Burada da teyit işlemini başarıyla halletmiş olduk. 00:00:40.866 --> 00:00:42.487 Şunu bir kırmızıya boyayalım. 00:00:43.268 --> 00:00:44.229 Başarıyla tamamladık. 00:00:44.710 --> 00:00:49.775 Burada da B4-B8 aralığına TL cinsinden bir biçimlendirme para birimi uygulaması istenmiş. 00:00:50.296 --> 00:00:52.037 Burası B4-B8 aralığı. 00:00:52.537 --> 00:01:00.487 Bildiğin üzere yine giriş menüsünde para sembolü hemen yanında bulunan O kapı astığımda bana para birimlerini gösterir. 00:01:00.927 --> 00:01:03.610 Ben buradan Türkiye, Türkiye ile seçenini seçtim. 00:01:04.291 --> 00:01:08.276 Gördüğünüz üzere para birimi biçimlendirmesini de başarıyla uyguladık. 00:01:09.437 --> 00:01:11.940 Burada bir sonraki adımımız, sekizinci adım. 00:01:12.621 --> 00:01:15.364 Sekizinci adımımız da B8 hücresindeki biçimlendirmeyi. 00:01:16.345 --> 00:01:22.949 D5 hücresine ve akabinde C13-C18 hücre aralığına taşımamız istenmiş. 00:01:23.950 --> 00:01:26.872 B8 hücresindeki biçimlendirmeyi bir bakalım. 00:01:27.072 --> 00:01:32.095 Bu B8 hücresi buradaki biçimlendirmeyi kopyalamak için buradaki biçim boyasını kullanacağız. 00:01:32.956 --> 00:01:36.878 Bunu buradan seçtim ve uygulamak isteyeceğimiz yer D5 hücresi. 00:01:37.659 --> 00:01:40.700 Burada D5 hücresini buldum ve uyguladım. 00:01:42.401 --> 00:01:43.222 Gördüğünüz üzere. 00:01:45.407 --> 00:02:08.631 ardından yapmamız gereken işlem C13-C18 hücre aralığına da yine aynı işlem uygulamak C18 aralığına bu işlemi uyguladım gördüğünüz üzere Bu işlemi de başarıyla tamamladık. 00:02:10.593 --> 00:02:15.336 Bir sonraki adımız DS2'nun uzunluğunu içeriğin uzunluğuna uyacak şekilde ayarlayın. 00:02:16.737 --> 00:02:17.778 DS2'na bakıyorum. 00:02:19.268 --> 00:02:23.873 Bildiğin üzere buradaki metin artık E stüdyonunun üzerine taşmış. 00:02:24.373 --> 00:02:26.135 Bunu yapabildikçe yine iki yöntemimiz var. 00:02:26.175 --> 00:02:27.395 Birincisi metini kaydırmak. 00:02:27.616 --> 00:02:32.020 Metini kaydırırsam metin ikiye bölünmüş oldu. 00:02:32.901 --> 00:02:34.843 Bunun haricinde yapabileceğimiz bir diğer işlem. 00:02:35.844 --> 00:02:38.367 Burada metni kaydımı D aktif hale getirdim. 00:02:38.488 --> 00:02:41.772 D ile E sütünün arasına kalan yere çift tıklamak olur. 00:02:41.912 --> 00:02:46.657 Burada da yine metne göre oluşan optimum genişliği sağlar. 00:02:47.720 --> 00:02:49.702 Bunu da başarıyla uygulamış olduk. 00:02:49.862 --> 00:02:50.924 Yöntemleri gösterdim. 00:02:51.204 --> 00:02:57.847 Burada son işlemimiz olan B13-B17 hücre alanına metrekare biçimlendirmesi uygulamak. 00:02:58.748 --> 00:03:02.470 Sonuçta örneğin 82 metrekare gibi gözükmesi istenmiş. 00:03:02.610 --> 00:03:08.293 Burada bildiğiniz üzere bunlar alan ve bunların metrekare gibi gözükmesi gerekmekte. 00:03:08.453 --> 00:03:17.797 Bunu sağlayabilmemiz için de yine bu uygulamayı yapmamız gereken yani metrekare için üzerinden olan hücreleri seçtim ve sağ tıkladım. 00:03:18.037 --> 00:03:22.279 Bunun ardından Gördüğünüz üzere hücreleri biçimlendir seçeneği var. 00:03:22.559 --> 00:03:23.199 Buna tıklıyorum. 00:03:24.199 --> 00:03:29.680 Ve ardından da kategori olarak seçmemiz gereken bir takım şeyler çıktı önümüze. 00:03:30.520 --> 00:03:32.139 Burada bir takım seçenekler var. 00:03:32.220 --> 00:03:35.201 Aslında yukarıdaki menüde de önümüze çıkan seçenekler. 00:03:35.841 --> 00:03:39.741 Burada biraz da manuel olarak önümüze sunulmakta. 00:03:40.482 --> 00:03:44.542 Burada yapmamız gereken şey isteğe uyarlanmış ardından bir tam sayı. 00:03:45.122 --> 00:03:48.203 Fakat önüne gelecek burada bir detay var. 00:03:48.803 --> 00:03:52.285 Bunu yapabilmemiz için de yine sıfırdan sonra bir boşluk. 00:03:52.946 --> 00:03:54.747 Ardından tırnak açıyorum. 00:03:57.149 --> 00:03:57.629 M diyorum. 00:03:58.510 --> 00:04:01.151 Ardından da M karesini koydum. 00:04:01.872 --> 00:04:03.173 Yine tırnağımı kapatıyorum. 00:04:05.214 --> 00:04:08.816 İsterseniz bunu hazırda kopyalayabilirsiniz. 00:04:09.577 --> 00:04:12.179 Ardından bunu tamam diyerek kaydediyorum. 00:04:13.055 --> 00:04:16.139 Gördüğünüz üzere buradaki işlem hala sabit kalmış oldu. 00:04:16.339 --> 00:04:22.186 Biz sadece buradaki sayı değerinin önüne ekstra bir detay eklemiş olduk. 00:04:23.226 --> 00:04:25.650 Bunu da bu şekilde halletmiş olduk. 00:04:26.630 --> 00:04:27.392 Başarılar dilerim.