Counting words that start with a capital letter - Byk hrfl balayan szlrin saylma

Uploaded By: Myvideo

Published on

6 Dec 2023

1 view

0

0 votes

0

About Share Download Add to

Task: Sol sütunda verilmiş sözlər sırasına əsasən neçə sözün böyük hərflə yazıldığını excel formulalarını istifadə edərək tapın. Prosesin izahı: Exceldə konkret böyük və ya kiçik hərflə başlayan sözləri sayan formula yoxdur. Buna görə də biz müxtəlif formulalardan istifadə edəcəyik. Əvvəlcə LEFT ilə sözlərin ilk hərfi çıxarılır. Sonra isə PROPER ilə həmin o ilk hərflər hamısı böyük hərfə çevrilir. Daha sonra isə həmin iki sütun EXACT ilə müqayisə edilir. Böyük hərflə başlayan sözlər TRUE, kiçik hərflə başlayan sözlər isə FALSE verəcək. TRUE və FALSE o

Share with your friends

Link:

Embed:

<iframe width="640" height="360" src="//myvideo.cc/embed/ZHZPR1J3VDVqNVFvc3pIc041S3VuRDNJU0NSdnJNYis5SlBUT3pYYkZyOD0" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>

Video Size:

Custom size:

x

Autoplay video

Hide player controls

Hide resume playing

Add to Playlist:

Favorites

My Playlist

Watch Later

Morgan Wallen - Smile (Official Music Video)

4 weeks ago

00:05:18

Morgan Wallen - Smile (Official Music Video)

7 80%

Megadeth - Countdown To Extinction Unplugged at SiriusXM

1 month ago

00:05:19

Megadeth - Countdown To Extinction Unplugged at SiriusXM

1 86%

Plato Describes Atlantis // First Mention of the Island // 360 BC 'Critias'

1 month ago

00:23:41

Plato Describes Atlantis // First Mention of the Island // 360 BC 'Critias'

1 64%

BODY COUNT - F What You Heard (OFFICIAL VIDEO)

3 months ago

00:03:19

BODY COUNT - F What You Heard (OFFICIAL VIDEO)

1 90%

Numbers Vocabulary | How to Say Numbers in English | English Pronunciation

3 months ago

00:03:03

Numbers Vocabulary | How to Say Numbers in English | English Pronunciation

3 35%

The Trapeze Swinger l Gregory Alan Isakov cover

3 months ago

00:08:00

The Trapeze Swinger l Gregory Alan Isakov cover

1 47%

Lewis Capaldi - Bruises (Official Video)

3 months ago

00:03:47

Lewis Capaldi - Bruises (Official Video)

1 35%

The Tubes - What Do You Want From Life - 12/31/1975 - Winterland (Official)

3 months ago

00:05:55

The Tubes - What Do You Want From Life - 12/31/1975 - Winterland (Official)

1 64%

How to Become Yahuah's Good and Faithful Servant MUST SEE

3 months ago

00:13:46

How to Become Yahuah's Good and Faithful Servant MUST SEE

1 61%

In The Night - Fly By Midnight (Official Lyric Video)

3 months ago

00:03:26

In The Night - Fly By Midnight (Official Lyric Video)

1 50%

3 months ago

00:02:20

'

1 93%

Speedpaint - Dracula Parrot (Tav/Astarion)

3 months ago

01:20:10

Speedpaint - Dracula Parrot (Tav/Astarion)

1 27%

William Black & Fairlane - Broken (Lyrics)

3 months ago

00:03:49

William Black & Fairlane - Broken (Lyrics)

1 69%

One-Way Ticket - Jennifer Bassett | Oxford Bookworm: Stage 1

3 months ago

00:49:20

One-Way Ticket - Jennifer Bassett | Oxford Bookworm: Stage 1

1 95%

Architects - when we were young (Live at Alexandra Palace)

3 months ago

00:03:47

Architects - when we were young (Live at Alexandra Palace)

1 90%

NaruvemberToumei Datta Sekai (Naruto Shippuden) Full English FandubRage

3 months ago

00:03:53

NaruvemberToumei Datta Sekai (Naruto Shippuden) Full English FandubRage

1 84%

Nathan James - Misanthrope (Official Music Video)

3 months ago

00:03:04

Nathan James - Misanthrope (Official Music Video)

1 78%

You're Gonna Lose That Girl - The Beatles - Full Instrumental Recreation (4K)

3 months ago

00:02:21

You're Gonna Lose That Girl - The Beatles - Full Instrumental Recreation (4K)

1 6%

Dmitri Hvorostovsky - Yeletsky's aria from The Queen of Spades (CSOTW, 17th June 1989)

3 months ago

00:05:16

Dmitri Hvorostovsky - Yeletsky's aria from The Queen of Spades (CSOTW, 17th June 1989)

1 89%

Space Shooter - Speed Typing Challenge - Game Video - Ans32 Game

3 months ago

00:01:46

Space Shooter - Speed Typing Challenge - Game Video - Ans32 Game

1 56%

All Glory Be To Christ - The Petersens (LIVE)

3 months ago

00:03:45

All Glory Be To Christ - The Petersens (LIVE)

1 52%

Minuscule - Top Tobasco

4 months ago

00:03:58

Minuscule - Top Tobasco

1 28%

ALL QUIET ALONG THE POTOMAC TONIGHT The PICKET GUARD sing along song lyrics words text

4 months ago

00:03:35

ALL QUIET ALONG THE POTOMAC TONIGHT The PICKET GUARD sing along song lyrics words text

1 76%

Редьярд Киплинг Если (О, если ты спокоен, не растерян...) Читает Павел Морозов

4 months ago

00:02:01

Редьярд Киплинг Если (О, если ты спокоен, не растерян...) Читает Павел Морозов

1 80%

0 Comments

Guest