Rumus Dasar Excel
1st Grade
•10 Qs
Similar activities
Ulangan Informatika Kelas 1 (Lat ASAS1)
1st Grade - University
•15 Qs
Fixed Voice & VAS
1st Grade
•10 Qs
Excel Quiz
KG - University
•15 Qs
Jarkom
1st Grade - Professional Development
•11 Qs
kuiz1
1st Grade
•10 Qs
Post Test Seminar SR 2022
1st - 3rd Grade
•14 Qs
Rpl Part 2
1st Grade
•10 Qs
HARDWARE TROUBLESHOOTING
1st Grade
•10 Qs
Rumus Dasar Excel
Quiz
•
Professional Development, Computers
•
1st Grade
•
Practice Problem
•
Hard
Super Academy
Used 46+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Rumus excel yang digunakan untuk menghitung banyak data adalah
SUM
AVERAGE
COUNT
IF
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Fungsi CONCANTENATE adalah untuk
mencari data dari sebuah tabel
menghitung jumlah total data (angka)
pembulatan sebuah angka
menggabungkan beberapa data dari sel yang beda-beda
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Mana diantara 4 rumus Excel HLOOKUP di bawah ini yang benar?
=HLOOKUP(range;kriteria)
=HLOOKUP(number1;number2;...)
=HLOOKUP(lookup_value;tabel_array;col_index_num;range_lookup)
=HLOOKUP(range_lookup;lookup_value_tabel_array_col_index_num)
4.
FILL IN THE BLANK QUESTION
1 min • 10 pts
Dalam sebuah data ditemukan hasil #N/A
Bagaimana cara menyamarkannya?
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Pak Ari ingin menentukan rangking total penjualan tahun 2021 jika dibandingkan selama 5 tahun terakhir ini
rumus excel yang akan digunakan Pak Ari adalah..
RUNK
RANK
SUM
MAX
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
terdapat data sebagai berikut :
> 2.890.000
> 3.000.000
> 1.990.890
> 4.367.800
Jika ingin menentukan nilai data terbesar menggunakan rumus..
MIN
SUM
MAX
XNPV
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Untuk menguji pernyataan lebih dari 1 data, maka digunakan rumus excel..
COUNTA
IF
MAX
COUNT
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
Technologie moderne (Marzo)
Quiz
•
1st - 3rd Grade
15 questions
Bezpieczeństwo w internecie
Quiz
•
KG - 10th Grade
8 questions
Semana 9
Quiz
•
1st - 9th Grade
10 questions
¿Que son las Tics?
Quiz
•
1st Grade
10 questions
S2-1-Data1-Quizizz
Quiz
•
1st - 5th Grade
10 questions
Spreadsheets 1
Quiz
•
1st - 3rd Grade
13 questions
Power Point
Quiz
•
1st - 5th Grade
10 questions
Formato de Excel
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Professional Development
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
14 questions
States of Matter
Lesson
•
KG - 3rd Grade
13 questions
Veterans' Day
Quiz
•
1st - 3rd Grade
20 questions
Multiplication Mastery Checkpoint
Quiz
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
16 questions
natural resources
Quiz
•
1st Grade
20 questions
Identify Coins and Coin Value
Quiz
•
1st Grade
24 questions
Addition
Quiz
•
1st Grade