Pre-Test | E-workshop 2023 (Ms Excel)

Pre-Test | E-workshop 2023 (Ms Excel)

University

30 Qs

quiz-placeholder

Similar activities

KURSUS PENGURUSAN KEWANGAN TAHUN 2021 (ZON SARAWAK)

KURSUS PENGURUSAN KEWANGAN TAHUN 2021 (ZON SARAWAK)

1st Grade - University

25 Qs

Analysis of Financial Management

Analysis of Financial Management

12th Grade - University

25 Qs

Focus Direct Fun Test

Focus Direct Fun Test

University

25 Qs

UAS Sistem Informasi Manajemen

UAS Sistem Informasi Manajemen

University

25 Qs

melukis al Quran di hati

melukis al Quran di hati

1st Grade - University

25 Qs

Ulangan Harian 2 Teks Pidato Persuasif

Ulangan Harian 2 Teks Pidato Persuasif

9th Grade - Professional Development

25 Qs

#7 Salam Pramuka - Pengembangan Emosional

#7 Salam Pramuka - Pengembangan Emosional

KG - Professional Development

30 Qs

Soal Pengantar Akuntansi

Soal Pengantar Akuntansi

University

25 Qs

Pre-Test | E-workshop 2023 (Ms Excel)

Pre-Test | E-workshop 2023 (Ms Excel)

Assessment

Quiz

Professional Development

University

Medium

Created by

Yesy Rosita

Used 51+ times

FREE Resource

AI

Enhance your content in a minute

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

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Pada Tab apakah fungsi untuk membuat Chart?

Home

Insert

Page Layout

Formulas

Data

2.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Kombinasi tombol apakah yang digunakan untuk berpindah ke Cell A1 secara otomatis?

Ctrl + Home

Ctrl + C

Ctrl + V

Ctrl + X

Ctrl + Backspace

3.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Yang bukan termasuk dari tipe data Excel adalah ...

Numerical Value

Alphanumerical Text Value

Formula

Function

XML

4.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

20

13

18

36

28

5.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Manakah di bawah ini yang benar dalam urutan penulisan formula SUMIF?

=SUMIF(criteria,range,[sum_range])

=SUMIF([sum_range],criteria,range)

=SUMIF([sum_range],range,criteria)

=SUMIF(range,criteria,[sum_range])

=SUMIF(range,[sum_range],criteria)

6.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Formula apakah yang digunakan:

Misalkan pada suatu data penjualan ingin menjumlahkan total penjualan berdasarkan dua parameter yaitu bulan dan lokasi tertentu?

SUMIF

SUMIFS

COUNTIF

COUNTIFS

AVERAGE

7.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Formula apakah yang digunakan:

Misalkaan pada suatu data penjualan ingin menjumlahkan total transaksi berdasarkan dua parameter yaitu bulan dan supllier tertentu?

SUMIF

SUMIFS

COUNTIF

COUNTIFS

AVERAGE

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?