Rumus Dasar Excel
Authored by Super Academy
Professional Development, Computers
1st Grade
Used 48+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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
8 questions
Evaluasi dalam proses keperawatan
Quiz
•
1st Grade
15 questions
MS Office
Quiz
•
1st - 2nd Grade
10 questions
Microsoft Office - PowerPoint 1, 1º
Quiz
•
1st Grade
10 questions
Compubotics Siri 2
Quiz
•
1st - 3rd Grade
10 questions
Examen final informática
Quiz
•
1st - 5th Grade
14 questions
examen diagnostico cultura digital 2p
Quiz
•
1st Grade
15 questions
Systems Architecture
Quiz
•
KG - 9th Grade
12 questions
Intro to Scratch 2
Quiz
•
KG - University
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
Discover more resources for Professional Development
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
13 questions
Fractions
Quiz
•
1st - 2nd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
15 questions
Place Value tens and ones
Quiz
•
1st Grade
16 questions
Money - Coins
Lesson
•
1st - 2nd Grade
20 questions
Halves and Fourths
Quiz
•
1st Grade