Belli şartı sağlayan hücrelerin dolgu rengini mavi yapmak için hangi komut kullanılmalıdır?
excel eğer
11th Grade
•30 Qs
Similar activities
Excel Cell References
9th - 12th Grade
•28 Qs
Chủ đề: Excel 2007 (phần 1)
2nd Grade - Professional Development
•25 Qs
Relative, Mixed and Absolute Cell Reference
9th - 12th Grade
•27 Qs
Tin học 9-Ôn tập giữa kì 2
9th Grade - University
•28 Qs
Hoja de cálculo
11th Grade
•25 Qs
Formulas de Excel
11th Grade
•26 Qs
Informatica, scuola e generale
8th - 12th Grade
•26 Qs
Soal MS Excel Gabungan
9th - 12th Grade
•30 Qs
excel eğer
Quiz
•
Computers
•
11th Grade
•
Hard
SİBEL BAHÇIVAN
Used 8+ times
FREE Resource
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Eğer
Koşullu biçimlendirme
Tablo biçimlendir
hücre biçimlendir
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
C2 hücresine = A1+A2*A4 formülünü yazdığınızda C2 hücresinin görüntüsü ne olur?
8
10
25
26
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formülde her zaman büyük olan sayıdan küçük olan sayıyı çıkaran formülü yazdırın
=eğer(b2>b1;b1-b2;b2-b1)
=eğer(b2>b1;b2-b1;b1-b2)
=eğer(b2>b1;"b1-b2";"b2-b1")
=eğer(b1>b2;"b1-b2";"b2-b1")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Aşağıdaki formülde b2 ye girilecek sayı 0 olunca tanımsız yazsın değilse bölme işlemini yapsın
=eğer(b2>0;"tanımsız";"b1/b2")
=eğer(b2=0;"tanımsız";"b1/b2")
=eğer(b2=0;"tanımsız";b1/b2)
eğer(b2=0;"tanımsız";b1/b2)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Resimdeki tabloda F1 formülü nedir ?
=ortalama(c1:f1)
=ort(c2:f2)
=ortalama(c2:f2)
=ortalama(c2:f2) / 4
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=EĞER(E2>45;) formülünü sınıf geçmeyi belirleyecek şekilde tamamlayın.
=EĞER(E2>45;"GEÇTİ";"KALDI")
=EĞER(E2>45;"KALDI";"GEÇTİ")
=EĞER(E2>45;GEÇTİ;KALDI)
=EĞER(E2>45;KALDI;GEÇTİ)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
=TOPLA(C3:C5) formülünü açılımı nedir?
=C3+C5
=C3+C4+C5
C3+2
C5+C4
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
28 questions
Tin học 9-Ôn tập giữa kì 2
Quiz
•
9th Grade - University
26 questions
Informatica, scuola e generale
Quiz
•
8th - 12th Grade
32 questions
Arutikasutus ja suhtlemine arvutiga
Quiz
•
5th - 12th Grade
25 questions
EXCEL
Quiz
•
11th Grade
25 questions
Intro to Business Computer Applications Final Review
Quiz
•
9th - 12th Grade
25 questions
PTS Informatika
Quiz
•
11th Grade
25 questions
ASSEMENT Badan Usaha Dalam Perekonomian
Quiz
•
11th Grade
25 questions
Prueba programa Excel
Quiz
•
1st - 12th Grade
Popular Resources on Quizizz
10 questions
Chains by Laurie Halse Anderson Chapters 1-3 Quiz
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
15 questions
Character Analysis
Quiz
•
4th Grade
12 questions
Multiplying Fractions
Quiz
•
6th Grade
30 questions
Biology Regents Review #1
Quiz
•
9th Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
50 questions
Biology Regents Review: Structure & Function
Quiz
•
9th - 12th Grade
Discover more resources for Computers
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
50 questions
Biology Regents Review: Structure & Function
Quiz
•
9th - 12th Grade
20 questions
Taxes
Quiz
•
9th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression
Quiz
•
9th - 12th Grade
14 questions
Attributes of Linear Functions
Quiz
•
9th - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University
50 questions
Biology Regents Review 2: Ecology
Quiz
•
9th - 12th Grade
20 questions
Investing
Quiz
•
9th - 12th Grade