Ulangan 1 Smt 1 - Kelas 6 - Sdi Muslimat

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Anshori
A
Anshori
Community Contributor
Quizzes Created: 7 | Total Attempts: 7,652
Questions: 15 | Attempts: 375

SettingsSettingsSettings
Ulangan 1 Smt 1 - Kelas 6 - Sdi Muslimat - Quiz

Ini adalah ulangan I TIK Kelas VI di Semester I. Materi : Microsoft ExcelKerjakan dengan teliti!Isilah data dengan nama lengkap kamu!Waktu mengerjakan : 15 menit


Questions and Answers
  • 1. 

    Microsoft Excel berguna untuk ....

    • A.

      Mengolah angka dalam bentuk tabel

    • B.

      Mengolah kata dalam bentuk paragraf

    • C.

      Membuat gambar

    • D.

      Membuat presentasi

    Correct Answer
    A. Mengolah angka dalam bentuk tabel
    Explanation
    Microsoft Excel berguna untuk mengolah angka dalam bentuk tabel. Microsoft Excel adalah program spreadsheet yang memungkinkan pengguna untuk melakukan perhitungan, analisis data, dan menyajikan angka-angka dalam bentuk tabel yang mudah dibaca dan dipahami. Dengan Excel, pengguna dapat melakukan berbagai operasi matematika, membuat rumus, membuat grafik, dan mengatur data dalam bentuk tabel yang terstruktur.

    Rate this question:

  • 2. 

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

    • A.

      Sel (cells)

    • B.

      Kolom (column)

    • C.

      Baris (rows)

    • D.

      Sheet

    Correct Answer
    B. Kolom (column)
    Explanation
    In a table, the vertical sections are called columns. Each column contains data that is related to a specific category or attribute. This is different from rows, which are the horizontal sections of a table. In this context, the correct answer is "kolom" (column) because it accurately describes the vertical sections of a table.

    Rate this question:

  • 3. 

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

    • A.

      6 (enam)

    • B.

      5 (lima)

    • C.

      4 (empat)

    • D.

      3 (tiga)

    Correct Answer
    D. 3 (tiga)
    Explanation
    In Microsoft Excel, each new file always comes with three worksheets (lembar kerja). This means that when you open a new Excel file, you will have three sheets available to work on.

    Rate this question:

  • 4. 

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

    • A.

      : (titik dua)

    • B.

      / (slash)

    • C.

      = (sama dengan)

    • D.

      > (lebih besar)

    Correct Answer
    C. = (sama dengan)
    Explanation
    The correct answer is "=" because in Microsoft Excel, formulas are always preceded by the "=" sign. This signifies to Excel that the following characters should be interpreted as a formula rather than plain text.

    Rate this question:

  • 5. 

    Fasilitas Autofill berguna untuk ....

    • A.

      Membuat lambang mata uang

    • B.

      Membuat data nomor berurutan

    • C.

      Membingkai tabel

    • D.

      Membuat rumus

    Correct Answer
    B. Membuat data nomor berurutan
    Explanation
    The correct answer is "membuat data nomor berurutan." Autofill is a feature that automatically fills in a series of data or numbers in a sequential order. It saves time and effort by eliminating the need to manually enter each individual number. This feature is commonly used in spreadsheet programs like Microsoft Excel or Google Sheets to quickly generate a series of numbers, dates, or other types of data.

    Rate this question:

  • 6. 

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

    • A.

      20

    • B.

      76

    • C.

      84

    • D.

      320

    Correct Answer
    A. 20
    Explanation
    The given expression "80/4" represents the division of 80 by 4. When we calculate this division, the result is 20. Therefore, the correct answer is 20.

    Rate this question:

  • 7. 

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

    • A.

      Latihan.doc

    • B.

      Latihan.bmp

    • C.

      Latihan.xls

    • D.

      Latihan.ppt

    Correct Answer
    C. Latihan.xls
    Explanation
    The correct answer is "Latihan.xls" because Microsoft Excel is a spreadsheet program that typically saves files with the .xls extension. The other options, "Latihan.doc" and "Latihan.ppt" are file extensions used by Microsoft Word and Microsoft PowerPoint respectively. "Latihan.bmp" is a file extension for bitmap image files.

    Rate this question:

  • 8. 

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

    • A.

      Column

    • B.

      Sheet

    • C.

      Rows

    • D.

      Cell

    Correct Answer
    D. Cell
    Explanation
    The correct answer is "cell". In the context of spreadsheets, a cell refers to the intersection point between a column and a row. It is a rectangular box where data can be entered and stored. Cells are used to organize and manipulate data in a spreadsheet, allowing for calculations, formatting, and data analysis.

    Rate this question:

  • 9. 

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

    • A.

      2010/01/31

    • B.

      01/31/2010

    • C.

      31/01/2010

    • D.

      31/2010/01

    Correct Answer
    C. 31/01/2010
    Explanation
    The correct answer is 31/01/2010 because it follows the format of dd/mm/yyyy, where the day is represented by two digits, the month is represented by two digits, and the year is represented by four digits. In this case, the day is 31, the month is 01 (January), and the year is 2010.

    Rate this question:

  • 10. 

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

    • A.

      Border

    • B.

      Number

    • C.

      Alignment

    • D.

      Pattern

    Correct Answer
    D. Pattern
    Explanation
    The correct answer is "pattern". This is because patterns can be used to add color and design to the background of a table. By using different patterns, the table can be made more visually appealing and interesting.

    Rate this question:

  • 11. 

    Merge Cells berguna untuk ....

    • A.

      Melebarkan kolom

    • B.

      Menggabung sel

    • C.

      Membuat dua baris tulisan dalam 1 sel

    • D.

      Mengetik rumus

    Correct Answer
    B. Menggabung sel
    Explanation
    Merge Cells berguna untuk menggabungkan sel-sel yang berdekatan menjadi satu sel yang lebih besar. Dengan menggabungkan sel, kita dapat membuat tampilan yang lebih rapi dan terstruktur pada lembar kerja.

    Rate this question:

  • 12. 

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

    • A.

      Numbers

    • B.

      Date

    • C.

      Accounting

    • D.

      Percentage

    Correct Answer
    C. Accounting
    Explanation
    The correct answer is "Accounting" because creating currency symbols like the Indonesian Rupiah (Rp) falls under the domain of accounting. Accounting involves recording, analyzing, and reporting financial transactions, which includes representing currency symbols accurately.

    Rate this question:

  • 13. 

    Fasilitas Border berguna untuk ....

    • A.

      Membuat garis bingkai pada tabel

    • B.

      Mewarnai tabel

    • C.

      Menggabung sel

    • D.

      Membuat data tanggal

    Correct Answer
    A. Membuat garis bingkai pada tabel
    Explanation
    The correct answer is "membuat garis bingkai pada tabel." Fasilitas Border berguna untuk membuat garis bingkai pada tabel. This means that the Border feature is used to create a border or outline around a table, helping to visually separate and organize the content within the table.

    Rate this question:

  • 14. 

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

    • A.

      Akhir kolom

    • B.

      Akhir baris

    • C.

      Awal kolom

    • D.

      Awal baris

    Correct Answer
    B. Akhir baris
    Explanation
    Pressing the Ctrl key along with the down arrow is useful for moving to the end of a row in a document or spreadsheet. This combination of keys allows the user to quickly navigate to the last cell in a row without having to manually scroll or use the mouse. This can be helpful when working with large amounts of data and needing to quickly move to the end of a row to make edits or view information.

    Rate this question:

  • 15. 

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

    • A.

      Rata kiri

    • B.

      Rata kanan

    • C.

      Di tengah

    • D.

      Di mana saja

    Correct Answer
    B. Rata kanan
    Explanation
    The given correct answer is "rata kanan" which means "right align" in English. This suggests that the numerical data will be positioned towards the right side of the cell. This alignment is commonly used for numerical data to maintain consistency and improve readability in a table or spreadsheet.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.