Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

10th Grade

10 Qs

quiz-placeholder

Similar activities

String and Math Methods AP CSA

String and Math Methods AP CSA

10th Grade

10 Qs

 Unit 4 Advanced AP CSP

Unit 4 Advanced AP CSP

9th - 12th Grade

10 Qs

Informática 9, 10 y 11 Semana 6

Informática 9, 10 y 11 Semana 6

9th - 11th Grade

10 Qs

Robotics Ch1 Intro

Robotics Ch1 Intro

6th - 10th Grade

10 Qs

Lesson 5 Looping Quiz

Lesson 5 Looping Quiz

10th - 12th Grade

15 Qs

2020 Excel上半年复习

2020 Excel上半年复习

10th Grade

12 Qs

After Effect Intoduction

After Effect Intoduction

10th Grade - University

15 Qs

Основные понятия Excel

Основные понятия Excel

10th Grade

12 Qs

Spreadsheet Rumus statistik

Spreadsheet Rumus statistik

Assessment

Quiz

Computers

10th Grade

Practice Problem

Medium

Created by

Lilis Susanti

Used 109+ 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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?