Latihan 2 - Semester 1 - Tik Kelas 6
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 tabelExplanation
Microsoft Excel berguna untuk mengolah angka dalam bentuk tabel. Excel adalah program spreadsheet yang memungkinkan pengguna untuk melakukan perhitungan matematika, analisis data, dan membuat grafik berdasarkan data yang dimasukkan ke dalam tabel. Dengan Excel, pengguna dapat melakukan berbagai macam operasi matematika seperti penjumlahan, pengurangan, perkalian, dan pembagian, serta melakukan analisis data seperti mencari rata-rata, median, dan modus. Selain itu, Excel juga menyediakan fitur-fitur seperti filter data, sorting, dan pivot table yang memudahkan pengguna dalam mengelola dan menganalisis data dalam bentuk tabel.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 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 ....
- 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 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 ....
- A.
: (titik dua)
- B.
/ (slash)
- C.
= (sama dengan)
- D.
> (lebih besar)
Correct Answer
C. = (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 ....
- A.
Membuat lambang mata uang
- B.
Membuat data nomor berurutan
- C.
Membingkai tabel
- D.
Membuat rumus
Correct Answer
B. Membuat data nomor berurutanExplanation
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 ....
- A.
20
- B.
76
- C.
84
- D.
320
Correct Answer
A. 20Explanation
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 ....
- A.
Latihan.doc
- B.
Latihan.bmp
- C.
Latihan.xls
- D.
Latihan.ppt
Correct Answer
C. Latihan.xlsExplanation
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 ....
- A.
Column
- B.
Sheet
- C.
Rows
- D.
Cell
Correct Answer
D. CellExplanation
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 ....
- A.
2010/01/31
- B.
01/31/2010
- C.
31/01/2010
- D.
31/2010/01
Correct Answer
C. 31/01/2010Explanation
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 ....
- A.
Border
- B.
Number
- C.
Alignment
- D.
Pattern
Correct Answer
D. PatternExplanation
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 ....
- A.
Melebarkan kolom
- B.
Menggabung sel
- C.
Membuat dua baris tulisan dalam 1 sel
- D.
Mengetik rumus
Correct Answer
B. Menggabung selExplanation
Merge Cells berguna untuk menggabung sel.Rate this question:
-
- 12.
Untuk membuat lambang mata uang (Rp), fasilitasnya adalah ....
- A.
Numbers
- B.
Date
- C.
Accounting
- D.
Percentage
Correct Answer
C. AccountingExplanation
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 ....
- A.
Membuat garis bingkai pada tabel
- B.
Mewarnai tabel
- C.
Menggabung sel
- D.
Membuat data tanggal
Correct Answer
A. Membuat garis bingkai pada tabelExplanation
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 ....
- A.
Akhir kolom
- B.
Akhir baris
- C.
Awal kolom
- D.
Awal baris
Correct Answer
B. Akhir barisExplanation
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.
- A.
Rata kiri
- B.
Rata kanan
- C.
Di tengah
- D.
Di mana saja
Correct Answer
B. Rata kananExplanation
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 ....
- A.
SUM
- B.
AVERAGE
- C.
MAX
- D.
MIN
Correct Answer
B. AVERAGEExplanation
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 ....
- A.
Rows
- B.
Column
- C.
Table
- D.
Sel
Correct Answer
D. SelExplanation
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 ....
- A.
SUM=(A12;A15)
- B.
=SUM(A12;A15)
- C.
SUM=(A12:A15)
- D.
=SUM(A12:A15)
Correct Answer
D. =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 ....
- A.
SUM
- B.
AVERAGE
- C.
MAX
- D.
MIN
Correct Answer
C. MAXExplanation
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 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 24, 2010Quiz Created by
Anshori
Back to top