Analisis Data

Open Ended

Bagaimana mengolah data menjadi sebuah informasi yang lebih berguna?

Multiple Choice

Apa itu spreadsheet?

• Sel A1 saat dipilih

• Nilai Angka

• Sebuah grid kolom dan baris.

Multiple Choice

Sebuah ____________ adalah tempat di mana baris dan kolom bertemu.

• lembar

• rumus

• kosong

• sel

Multiple Choice

What are the key tools used for data analysis as shown in the diagram?

• Worksheets

• Data Validation

• Statistical Functions

• Cell References

Open Ended

Apa itu Data?

Multiple Choice

Kumpulan fakta yang diterima secara apa adanya dan tercatat dinamakan...

• Data

• Analisis

• Informasi

• Formula

Open Ended

What is the difference between data analysis and data interpretation?

Multiple Choice

Mengapa perlu analisis data?

• Untuk mengambil keputusan

• Untuk mengabaikan data

• Untuk menghindari kesimpulan

• Untuk mempercepat proses

Multiple Choice

Apa interpretasi kalian dari data kapasitas memori komputer yang ditunjukkan pada grafik?

• Kenaikan kapasitas memori

• Penurunan kapasitas memori

• Stabilitas kapasitas memori

• Tidak ada perubahan

Multiple Choice

Apa kepanjangan dari RAM?

• Baca Semua Memori

• Memori Selalu Acak

• Akses Baca Memori

• Akses Acak Memori

Multiple Choice

Flashdisk yang mana yang kalian beli agar cukup untuk menyimpan data hasil belajar selama 1 bulan?

• Flashdisk 1GB

• Flashdisk 2GB

• Flashdisk 4GB

• Flashdisk 8GB

Open Ended

Tulis Nama Lengkap dan Kelas kalian dengan format (Nama Lengkap_Kelas)

Multiple Choice

Bagaimana cara memasukkan data ke dalam spreadsheet?

• klik 'Tab Sisipkan'

• pilih spreadsheet

• pilih sel dan ketik judul lalu tekan enter

Multiple Choice

Kursor mana yang memungkinkan Anda untuk menyeret dan mengisi serangkaian?

• Tanda Plus Kurus

• Tanda Plus Gemuk

• Tangan

• Panah

Multiple Choice

What should you select to create a new blank workbook in Microsoft Excel?

• Blank workbook

• Open existing workbook

• Create a new folder

• Save as template

Multiple Choice

What does the Quick Access Toolbar display?

• Frequently used menus/features

• All available menus

• Only the Ribbon

• None of the above

Multiple Choice

What does the term 'range' refer to in a worksheet?

• A single cell

• A collection of cells

• A row of cells

• A column of cells

Multiple Select

What is the process to rename a worksheet in Excel?

• Right-click and select Rename

• Double-click the sheet name

• Press F2 key

• All of the above

Multiple Choice

What is the purpose of the Freeze Panes feature in Excel?

• To lock rows or columns in place

• To delete rows or columns

• To copy worksheets

• To move worksheets

Multiple Choice

What are the steps to move a worksheet in Excel?

• Select the worksheet

• Click on the worksheet tab

• Choose Move or Copy

• All of the above

Multiple Choice

What is the purpose of the Freeze First Column option in Excel?

• Keeps the first column visible while scrolling

• Keeps the first row visible while scrolling

• Hides the selected columns

• Unfreezes all panes

Multiple Choice

What does the Freeze Top Row option do in Excel?

• Keeps the first row visible while scrolling

• Keeps the first column visible while scrolling

• Hides the selected rows

• Unfreezes all panes

Multiple Choice

What are the three options available under the Freeze Panes menu in Excel?

• Freeze Panes

• Freeze Top Row

• Freeze First Column

• Hide

Multiple Choice

What are the three types of cell references mentioned in the image?

• Relative, absolute, mixed

• Fixed, variable, dynamic

• Static, dynamic, relative

• Absolute, variable, fixed

Multiple Choice

What is the purpose of the 'Unfreeze Panes' feature in a worksheet?

• To lock rows and columns

• To unlock rows and columns

• To hide rows and columns

• To split the worksheet

Multiple Choice

What is the difference between relative and absolute references in a worksheet?

• Relative references change when copied to another cell

• Absolute references change when copied to another cell

• Relative references do not change when copied

• Absolute references do not change when copied

Fill in the Blank

Fill in the blank: The Format Cells dialog box allows you to adjust settings related to ___, Font, Border, Fill, and Protection.

Multiple Choice

In the Format Cells dialog box, which tab would you select to change the font style?

• Number

• Alignment

• Font

• Protection

Multiple Choice

What options can be adjusted in the Format Cells dialog box?

• Number

• Font

• Border

• All of the above

Multiple Choice

Conditional formatting pada Excel digunakan untuk...

• Mengubah struktur lembar kerja.

• Menambahkan rumus ke sel-sel tertentu.

• Mengubah tampilan sel berdasarkan kondisi tertentu.

• Menggabungkan sel-sel secara otomatis.

• Menghapus data dari lembar kerja.

Multiple Choice

What is the significance of the Date & Time section in the Number tab?

• It shows how dates are stored as numbers

• It provides formatting options for dates

• It explains the calendar types available

• All of the above

Multiple Choice

What are the different formats for displaying numbers in the Number tab?

• Format-1: 2 decimal places

• Format-2: 0 decimal places

• Format-3: 2 decimal places

• Format-4: 3 decimal places

Open Ended

Explain how to adjust the alignment of text in Excel cells as shown in the image.

Multiple Choice

What formatting options can be applied to numbers in Excel according to the image?

• Currency

• Percentage

• Scientific

• Text

Multiple Choice

What does the indicated icon do in the red box?

• Apply underline

• Apply italic

• Make text bigger

• Apply bold

Multiple Choice

What options can be adjusted in the Font settings according to the image?

• Font style

• Font size

• Font color

• All of the above

Multiple Choice

What are lines that can be applied around worksheet cells or objects?

• Gridlines
• Borders
• Underlines
• Boundaries

Multiple Choice

What options are available for formatting the fill color of a cell in Excel?

• No Color

• Automatic

• Custom Color

• Gradient Color

Multiple Select

Cocokkan pertanyaan dan jawaban berikut. Pilihan jawaban dapat digunakan lebih dari 1 kali. Pilihan Jawaban: Absolute Cell References; Fill Color; Format Accounting; Format Border; Format Date; Format Currency; Format Font; Format Number; Format Text; Freeze Panes; Mixed Cell References. Pertanyaan: 1. Fitur ini dapat memberi warna latar pada cell. 2. Dengan fitur ini, apabila menyalin suatu formula, hasilnya akan tetap sama. 3. $C$9 merupakan contoh dari ... 4. Dengan fitur ini, kita bisa membuat data pada baris pertama akan tetap walaupun halaman sudah di-scroll ke bawah. 5. Dengan fitur ini, angka 0 di bagian depan akan tetap ditampilkan. 6. Dengan fitur ini, kita bisa membuat data pada baris dan kolom tertentu akan tetap walaupun halaman sudah di-scroll ke bawah. 7. Dengan fitur ini, kita bisa mengambil nilai bilangan dari sebuah tanggal. 8. Dengan fitur ini, kita bisa mengatur pemisah ribuan untuk suatu bilangan. 9. Dengan fitur ini, kita dapat menampilkan nilai uang dengan mata uang tertentu. 10. Dengan fitur ini, kita dapat mengatur pilihan garis pinggir suatu cell. 11. Dengan fitur ini, kita dapat mengubah pilihan tampilan tulisan. 12. L$48 merupakan contoh dari ...

• Absolute Cell References

• Fill Color

• Format Accounting

• Format Border

Multiple Choice

What does the COUNT function do in data processing?

• Counts the total number of cells

• Calculates the total sum of values

• Finds the minimum value

• Displays the average of the data

Multiple Choice

What is the purpose of the SUM function in data processing?

• To count the number of entries

• To calculate the average

• To find the maximum value

• To sum the total amount of data

Multiple Choice

What is the purpose of the SUMIF function as described in the image?

• To sum values based on a single condition

• To count the number of entries

• To find the average of a range

• To display data in a chart

Open Ended

Explain how the COUNTIF function can be implemented based on the example provided in the image.

Fill in the Blank

Fill in the blank: The formula for COUNTIF is =COUNTIF(___, criteria).

Multiple Choice

What is the purpose of the COUNTIF function as described in the image?

• To count data based on one condition

• To sum data based on multiple conditions

• To find the average of a range

• To filter data based on criteria

Open Ended

Explain how the YEAR, MONTH, DAY function works in data manipulation.

Multiple Choice

What arithmetic operations can be performed using standard arithmetic operators?

• Addition and subtraction

• Multiplication and division

• All of the above

• None of the above

Multiple Choice

What is the purpose of using absolute cell reference in the formula?

• To simplify the formula

• To change the data range

• To make the formula more complex

• To avoid errors in calculations

Multiple Choice

What is the purpose of the DATE function in Excel?

• To convert a date into year, month, and day

• To combine year, month, and day into a date

• To format a date in different languages

• To extract the day from a date

Open Ended

Explain how the functions HOUR, MINUTE, and SECOND work in Excel.

Fill in the Blank

Fill in the blank: The function ___ will return the current date and time in Excel.

Multiple Choice

What is the purpose of the function =NOW() in Excel?

• To return the current date and time

• To sum a range of cells

• To count the number of cells

• To find the average of a range

Poll

Seberapa yakin Anda tentang topik ini sekarang?

• Sangat percaya diri
• Agak percaya diri
• Tidak percaya diri