SOAL EXCEL IF
Authored by Setya Prahestin
Computers
10th Grade
Used 14+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pada sel A2 terisi 75 dan terdapat fungsi =IF(A2<65,”C”,IF(A2<75,”B”,”A”)) maka akan memberikan hasil ….
A
B
C
A,B, C
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk memasukkan rumus / formula diawali dengan ….
(
*
:
=
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi statistik yang digunakan untuk mencari nilai rata-rata pada suatu range adalah …
SUM
AVERAGE
MAX
MIN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pada waktu memasukkan rumus atau data jika kolomnya kurang lebar, maka tampilan isi sel tersebut adalah …
@@@@@@@@@
############
===========
**********************
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan rumus yang benar untuk menjumlahkan data yang berada pada range E5 sampai E9 adalah
SUM(E5;E9)
=AVERAGE (E5:E9)
SUM(E5:E9)
=AVERAGE{E5:E9}
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Pilihan untuk lambang Rp terdapat pada …
Date
Number
Accounting
Format
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan perintah logika berikut ini yang benar adalah …
=IF(A5>5)5,A1=200
=IF(A1>5,A1)=”LULUS”,B1=”TIDAK”
=IF(A1>5,”SARJANA”,”SMA”)
=IF(A1>5)=”LULUS”,B1=”TIDAK”
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Software
Quiz
•
10th Grade
10 questions
UNIT 2.4 LOGIC
Quiz
•
10th Grade
20 questions
Unit-1 Computational Thinking
Quiz
•
9th - 12th Grade
12 questions
Spreadsheet
Quiz
•
5th - 11th Grade
12 questions
Networking L1 - KS3
Quiz
•
10th Grade
10 questions
If-Statements
Quiz
•
9th - 12th Grade
10 questions
BTEC DIT C3 LAA - Maintenance, Set up, Performance
Quiz
•
10th - 11th Grade
10 questions
Python: matlpotlib Online Quiz
Quiz
•
9th - 10th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
