Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

10th Grade

10 Qs

quiz-placeholder

Similar activities

Java Math

Java Math

1st - 12th Grade

10 Qs

Adobe Digital Design 1.00 (Part 1)

Adobe Digital Design 1.00 (Part 1)

9th - 12th Grade

15 Qs

Quiz Microsoft Excel

Quiz Microsoft Excel

9th - 12th Grade

10 Qs

Excel formulas VS Functions

Excel formulas VS Functions

10th - 12th Grade

10 Qs

kiểm tra lớp 5

kiểm tra lớp 5

1st - 12th Grade

15 Qs

Excel

Excel

10th - 11th Grade

10 Qs

Latihan Class Library

Latihan Class Library

9th - 12th Grade

10 Qs

2.2 MAC Address

2.2 MAC Address

9th - 10th Grade

10 Qs

Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

Assessment

Quiz

Computers

10th Grade

Practice Problem

Medium

Created by

Lilis Susanti

Used 110+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Media Image

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?