Brainstorming Pivot Table

Brainstorming Pivot Table

Professional Development

10 Qs

quiz-placeholder

Similar activities

How to wear a medical mask

How to wear a medical mask

Professional Development

10 Qs

Cycle 4: Session 8 Review.

Cycle 4: Session 8 Review.

Professional Development

12 Qs

USCG General Orders

USCG General Orders

Professional Development

11 Qs

Preventive Maintenance

Preventive Maintenance

Professional Development

10 Qs

Tebak nama komponen UI

Tebak nama komponen UI

Professional Development

12 Qs

Laptop Orientation

Laptop Orientation

Professional Development

15 Qs

Quiz Informasi Update

Quiz Informasi Update

Professional Development

10 Qs

Business Writing 4

Business Writing 4

Professional Development

10 Qs

Brainstorming Pivot Table

Brainstorming Pivot Table

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Medium

Created by

Muhamad Rifki Taufik

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

PivotTable memiliki empat area, kecuali

Header

Filters

Rows

Values

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

double click pada nilai di Pivot Table, akan memberikan sheet baru berisikan

Detail report berdasarkan filter

Tabel sumber secara utuh

Detail tabel sumber berdasarkan nilai

Semua benar

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Untuk mendapatkan hasil seperti gambar, maka kolom Region, harus diletakkan pada area

Filter

Column

Value

Row

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Untuk mendapatkan hasil seperti gambar, maka kolom Penjualan Unit, harus diletakkan pada area

Filter

Column

Value

Row

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Pivot Table dapat mengenerate Pivot Table baru dengan sheet baru berdasarkan kategori terpilih dalam area Filter terpilih, hal ini dapat dilakukan dengan Fitur

Filter

Show Report Filter Pages

Calculated Field

Pivot Table Field

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Untuk merubah perhitungan aggregate dari SUM menjadi AVERAGE dalam Pivot Table, dapat dilakukan dengan menggunakan

Custom Formatting

Show Report Filter Pages

Value Field Setting

Pivot Table Field

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Agar mendapatkan hasil seperti gambar, maka kita dapat memanfaatkan fitur

Custom Formatting

Clear Format

Font Style

Text Options

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?