Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

10th Grade

10 Qs

quiz-placeholder

Similar activities

JS SQL Reviewer

JS SQL Reviewer

10th Grade

15 Qs

Начала программирования на языке Паскаль

Начала программирования на языке Паскаль

8th - 11th Grade

15 Qs

Python 2

Python 2

9th - 12th Grade

10 Qs

MICROSOFT EXCEL

MICROSOFT EXCEL

10th Grade

10 Qs

Functions

Functions

5th Grade - Professional Development

13 Qs

User-Interface Design Cert Prep

User-Interface Design Cert Prep

9th - 12th Grade

15 Qs

Weekly Quiz 1

Weekly Quiz 1

4th Grade - Professional Development

10 Qs

APLIKASI SPREADSHEET

APLIKASI SPREADSHEET

10th Grade

15 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

Access all questions and much more by creating a free account

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?