Latihan 2 - Semester 1 - Tik Kelas 6

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Anshori
A
Anshori
Community Contributor
Quizzes Created: 5 | Total Attempts: 7,389
| Attempts: 3,271
SettingsSettings
Please wait...
  • 1/19 Soalan

    Microsoft Excel berguna untuk ....

    • Mengolah angka dalam bentuk tabel
    • Mengolah kata dalam bentuk paragraf
    • Membuat gambar
    • Membuat presentasi
Please wait...
Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    Pada tabel, bagian yang tegak dan dilambangkan dengan huruf disebut ....

    • Sel (cells)

    • Kolom (column)

    • Baris (rows)

    • Sheet

    Correct Answer
    A. Kolom (column)
    Explanation
    In a table, the vertical part that is represented by letters is called a column. A column is a vertical arrangement of cells in a table, and it is used to organize and categorize data in a structured manner. Each column represents a specific attribute or characteristic of the data being displayed in the table. Therefore, the correct answer is "kolom" (column).

    Rate this question:

  • 3. 

    Dalam setiap file baru Microsoft Excel yang kita buka, selalu disediakan lembar kerja (sheet) sebanyak ....

    • 6 (enam)

    • 5 (lima)

    • 4 (empat)

    • 3 (tiga)

    Correct Answer
    A. 3 (tiga)
    Explanation
    In Microsoft Excel, each new file always comes with three default worksheets or sheets. These sheets are provided to allow users to organize their data and calculations into separate sections within the same file. Having multiple sheets in a single Excel file makes it easier to manage and analyze different sets of data without the need for separate files.

    Rate this question:

  • 4. 

    Pengetikan rumus dalam Microsoft Excel selalu diawali dengan tanda ....

    • : (titik dua)

    • / (slash)

    • = (sama dengan)

    • > (lebih besar)

    Correct Answer
    A. = (sama dengan)
    Explanation
    In Microsoft Excel, the equal sign (=) is used to indicate that the entry in a cell is a formula or a calculation. It is the symbol that tells Excel to perform a calculation rather than treating the entry as text. Therefore, the correct answer is = (sama dengan).

    Rate this question:

  • 5. 

    Fasilitas Autofill berguna untuk ....

    • Membuat lambang mata uang

    • Membuat data nomor berurutan

    • Membingkai tabel

    • Membuat rumus

    Correct Answer
    A. Membuat data nomor berurutan
    Explanation
    The correct answer is "membuat data nomor berurutan". Autofill is a feature that allows users to automatically fill a series of cells with a sequence of numbers or data. This is useful for creating a list of sequential numbers or data in a spreadsheet or any other data entry form.

    Rate this question:

  • 6. 

    Pada sel tertulis : =80/4Apabila ketikan rumus tersebut kita Enter, hasilnya menjadi ....

    • 20

    • 76

    • 84

    • 320

    Correct Answer
    A. 20
    Explanation
    When the formula "=80/4" is entered, the result is 20. This is because when 80 is divided by 4, the quotient is 20.

    Rate this question:

  • 7. 

    Penulisan nama file yang dihasilkan oleh Microsoft Excel adalah ....

    • Latihan.doc

    • Latihan.bmp

    • Latihan.xls

    • Latihan.ppt

    Correct Answer
    A. Latihan.xls
    Explanation
    The correct answer is "Latihan.xls" because Microsoft Excel is a spreadsheet program that uses the .xls file extension for its files. The .xls extension indicates that the file is a workbook created in Microsoft Excel. Therefore, "Latihan.xls" is the most appropriate and logical choice for the file name generated by Microsoft Excel.

    Rate this question:

  • 8. 

    Perpotongan / pertemuan antara kolom dan baris membentuk kotak yang disebut ....

    • Column

    • Sheet

    • Rows

    • Cell

    Correct Answer
    A. Cell
    Explanation
    When columns and rows intersect, they form squares or boxes called "cells." Cells are the individual units within a spreadsheet or table where data can be entered or displayed. Each cell has a unique address based on its column and row position, allowing users to easily reference and manipulate specific data within the spreadsheet.

    Rate this question:

  • 9. 

    Pengetikan tanggal dengan format : dd/mm/yyyy adalah ....

    • 2010/01/31

    • 01/31/2010

    • 31/01/2010

    • 31/2010/01

    Correct Answer
    A. 31/01/2010
    Explanation
    The correct answer is "31/01/2010". This is the correct format for typing a date in dd/mm/yyyy format, where the day is written first, followed by the month and then the year.

    Rate this question:

  • 10. 

    Untuk memberi warna pada background (isi) tabel, gunakan ....

    • Border

    • Number

    • Alignment

    • Pattern

    Correct Answer
    A. Pattern
    Explanation
    The correct answer is "pattern". In order to give color to the background of a table, a pattern can be used. This means that instead of a solid color, a pattern or design can be applied to the background of the table. This can be useful for adding visual interest or differentiation to the table, rather than just using a plain color.

    Rate this question:

  • 11. 

    Merge Cells berguna untuk ....

    • Melebarkan kolom

    • Menggabung sel

    • Membuat dua baris tulisan dalam 1 sel

    • Mengetik rumus

    Correct Answer
    A. Menggabung sel
    Explanation
    Merge Cells berguna untuk menggabung sel.

    Rate this question:

  • 12. 

    Untuk membuat lambang mata uang (Rp), fasilitasnya adalah ....

    • Numbers

    • Date

    • Accounting

    • Percentage

    Correct Answer
    A. Accounting
    Explanation
    The correct answer is accounting because the symbol for the currency (Rp) is commonly used in accounting to represent the Indonesian Rupiah. In accounting, this symbol is used to denote monetary values and transactions related to financial statements, budgets, and other financial records.

    Rate this question:

  • 13. 

    Fasilitas Border berguna untuk ....

    • Membuat garis bingkai pada tabel

    • Mewarnai tabel

    • Menggabung sel

    • Membuat data tanggal

    Correct Answer
    A. Membuat garis bingkai pada tabel
    Explanation
    The correct answer is "membuat garis bingkai pada tabel". Fasilitas Border pada tabel digunakan untuk membuat garis bingkai pada tabel, sehingga memungkinkan pengguna untuk memisahkan dan membedakan antara sel-sel dalam tabel. Dengan menggunakan fasilitas ini, pengguna dapat memberikan tampilan yang lebih terstruktur dan terorganisir pada tabel yang dibuat.

    Rate this question:

  • 14. 

    Menekan tombol Ctrl disertai dengan menekan tanda panah ke bawah berguna untuk berpindah ke ....

    • Akhir kolom

    • Akhir baris

    • Awal kolom

    • Awal baris

    Correct Answer
    A. Akhir baris
    Explanation
    Pressing the Ctrl key along with the down arrow is useful for moving to the end of a row.

    Rate this question:

  • 15. 

    Data yang berupa angka pada awalnya akan diposisikan ... pada kotak sel.

    • Rata kiri

    • Rata kanan

    • Di tengah

    • Di mana saja

    Correct Answer
    A. Rata kanan
    Explanation
    The correct answer is "rata kanan" because it means "right-aligned" in English. This suggests that the numerical data will be positioned to the right side of the cell.

    Rate this question:

  • 16. 

    Untuk mencari nilai rata-rata, gunakan fungsi ....

    • SUM

    • AVERAGE

    • MAX

    • MIN

    Correct Answer
    A. AVERAGE
    Explanation
    To find the average value, the appropriate function to use is "AVERAGE". This function calculates the sum of all the values in a set and then divides it by the number of values in the set. Therefore, it is the most suitable option for finding the average value.

    Rate this question:

  • 17. 

    Pertemuan antara kolom dengan baris membentuk kotak yang disebut ....

    • Rows

    • Column

    • Table

    • Sel

    Correct Answer
    A. Sel
    Explanation
    The correct answer is "sel". This is because "sel" is the Indonesian word for "cell", which refers to the intersection point between a column and a row in a table.

    Rate this question:

  • 18. 

    Sekelompok data dari sel A12 sampai A15 akan dijumlah dengan fungsi SUM. Pengetikan rumus yang benar adalah ....

    • SUM=(A12;A15)

    • =SUM(A12;A15)

    • SUM=(A12:A15)

    • =SUM(A12:A15)

    Correct Answer
    A. =SUM(A12:A15)
    Explanation
    The correct answer is =SUM(A12:A15). This is the correct formula for summing a range of cells from A12 to A15. The SUM function is used to add up the values in the specified range, and the colon (:) is used to indicate the range of cells to be included in the sum. Therefore, =SUM(A12:A15) is the correct formula to use in this case.

    Rate this question:

  • 19. 

    Data terbesar dari sekelompok data dicari menggunakan rumus ....

    • SUM

    • AVERAGE

    • MAX

    • MIN

    Correct Answer
    A. MAX
    Explanation
    The correct answer is MAX. The question is asking for the largest value in a group of data, and the MAX function is used to find the maximum value in a set of numbers.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 24, 2010
    Quiz Created by
    Anshori

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.