Spreadsheet Rumus statistik
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Medium
Lilis Susanti
Used 110+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut ini termasuk fungsi statistik adalah
SUM
SUMIF
AVERAGE
VLOOKUP
IF
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kegunaan fungsi MIN adalah....
untuk menghitung nilai rata-rata
untuk menghitung nilai tertinggi
untuk menghitung nilai terendah
untuk menjumlahkan data
untuk menjumlahkan angka
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Penulisan fungsi MAX yang benar adalah
=MAX(number1.....number2)
=MAX(number1;[number2];....)
MAX(number1.....number2)
MAX(number1;[number2];....)
=MIN(number1;[number2];....)
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Fungsi Statistik yang digunakan untuk menghitung rata-rata data adalah....
MIN
MAX
SUM
AVERAGE
IF
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Fungsi Matematika yang digunakan untuk menjumlahkan data yang bersifat numberik yang memenuhi kriteria tertentu adalah
MAX
SUM
SUMIF
IF
MAX
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bentuk penulisan SUM yang benar adalah...
=SUM(number1...)
=SUM(number1;[number2];...)
SUM(number1...)
MIN(number1...)
SUM(number1;[number2];...)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
rumus yang digunakan E3 adalah...
=C3*D4
=C4*D3
=B3*D3
=C3*D3
=A3*D3
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
Already have an account?
Similar Resources on Wayground
10 questions
String and Math Methods AP CSA
Quiz
•
10th Grade
10 questions
Year 10 Plenary SUM,MAX, MIN, AVERAGE
Quiz
•
6th Grade - University
15 questions
สอบท้ายหน่วยที่ 4 วิทยาการคำนวณ 2 ม.2
Quiz
•
9th - 12th Grade
10 questions
Excel - formules en functies
Quiz
•
10th - 12th Grade
10 questions
Python Quiz for 10s
Quiz
•
10th Grade
15 questions
Guess the Controller 1
Quiz
•
KG - Professional Dev...
15 questions
After Effect Intoduction
Quiz
•
10th Grade - University
12 questions
Основные понятия Excel
Quiz
•
10th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
