Quiz Tik Kelas Xi Semeter 2
Sebelum mengerjakan tes isi identitas kamu berikut dengan kelasnya contoh: ajis x.2
Questions and Answers
- 1.
Yang dimaksud dengan sel adalah . . . .
- A.
Bujur setiap baris
- B.
Pertemuan antara workbook
- C.
Pertemuan baris dan kolom
- D.
Batas antar kolom
- E.
Pertemuan antara worksheet
Correct Answer
C. Pertemuan baris dan kolomExplanation
The correct answer is "Pertemuan baris dan kolom." This means the intersection between rows and columns. In the context of a spreadsheet program like Microsoft Excel, a cell refers to a single unit where a row and a column intersect. Each cell can hold data or formulas, allowing users to organize and analyze information in a structured manner. Therefore, "Pertemuan baris dan kolom" accurately describes the concept of a cell in this context.Rate this question:
-
- 2.
Tampilan menu berikut ini adalah ....
- A.
Menu edit
- B.
Menu insert
- C.
Menu data
- D.
Menu format
- E.
Menu tool
Correct Answer
D. Menu formatExplanation
The given correct answer is "Menu format" because the question asks for the identification of the displayed menu. Among the options provided, "Menu format" is the most suitable choice as it matches the displayed menu.Rate this question:
-
- 3.
Arti gambar dari ikon ini adalah ….
- A.
Merge Cells
- B.
Format Cell
- C.
Close
- D.
Save
- E.
Save As
Correct Answer
A. Merge CellsExplanation
The correct answer is "Merge Cells." This icon represents the action of merging multiple cells into one. By merging cells, you can combine their contents and formatting into a single cell, which can be useful for organizing and formatting data in spreadsheets or tables.Rate this question:
-
- 4.
Sel atau gabungan dari beberapa sel dapat diformat sesuai dengan aturan format sel. Isi Format Sel adalah sebagai berikut, kecuali . .
- A.
Function
- B.
Border
- C.
Alignment
- D.
Number
- E.
Protect
Correct Answer
A. FunctionExplanation
The correct answer is Function. The explanation for this answer is that the Format Cell feature allows users to apply various functions to the selected cell or range of cells, such as applying a specific date format, currency format, or custom format. The other options listed (Border, Alignment, Number, and Protect) are all valid components of the Format Cell feature, but they do not encompass the full range of functions that can be applied.Rate this question:
-
- 5.
Jika anda ingin menggabungkan beberapa sel (dalam satu baris) maka anda masuk pada perintah Format - Cells - Alignment - . . . .
- A.
Center
- B.
Number
- C.
Merge Cells
- D.
Accounting
- E.
Justifikasi
Correct Answer
C. Merge CellsExplanation
The correct answer is "Merge Cells". When you want to combine multiple cells into one in a single row, you can use the "Merge Cells" option. This allows you to merge the selected cells into a single cell, which can be useful for formatting purposes or when you want to create a visually unified layout.Rate this question:
-
- 6.
Klik 2 kali pada sheet1 (kelompok workbook) berfungsi untuk . . .
- A.
Rename
- B.
Mengganti
- C.
Mencari
- D.
Insert
- E.
Editing
Correct Answer
E. EditingExplanation
Double-clicking on sheet1 (worksheet group) allows you to edit the contents of the sheet. This action opens the sheet in a new window, enabling you to make changes to the data or formatting within the sheet.Rate this question:
-
- 7.
Untuk menampilkan tanda mata uang yang terletak rata kiri, digunakan format . . .
- A.
Number
- B.
Currency
- C.
Date
- D.
Accounting
- E.
General
Correct Answer
B. CurrencyExplanation
The correct answer is "Currency". This format is used to display currency symbols aligned to the left.Rate this question:
-
- 8.
Jika pada sebuah sel yang diformat ternyata muncul tanda “# # # # #”, artinya . . .
- A.
Salah dalam memasukkan data
- B.
Salah dalam memformat
- C.
Kolom kurang lebar
- D.
Baris kurang tinggi
- E.
Jenis datanya numerik
Correct Answer
C. Kolom kurang lebarExplanation
If the formatted cell displays the symbol "# # # # #", it means that the column width is insufficient to display the complete data.Rate this question:
-
- 9.
Perhatikan gambar dibawah ini.
- A.
Format General
- B.
Format Tanggal
- C.
Format Persentase
- D.
Format Text
- E.
Format Waktu
Correct Answer
B. Format TanggalExplanation
The given options represent different formats that can be applied to data. "Format Tanggal" refers to the format used for displaying dates. This format is commonly used to present dates in a specific order, such as day-month-year or month-day-year.Rate this question:
-
- 10.
Jika membuat rumus harus didahului dengan tanda . . .
- A.
=
- B.
( )
- C.
X
- D.
-
- E.
/
Correct Answer
A. =Explanation
The correct answer is the equal sign (=). In mathematics, the equal sign is used to indicate that two expressions have the same value. It is commonly used to write equations and formulas. In this context, the equal sign is necessary to start a formula or equation.Rate this question:
-
- 11.
Untuk mengembalikan pemformatan cell atau range, caranya . .
- A.
Format Numbering
- B.
Format Dating
- C.
Format Accounting
- D.
Format Fraction
- E.
Format General
Correct Answer
E. Format GeneralExplanation
The correct answer is "Format General" because it is the option that allows for restoring the formatting of a cell or range. This format is a default format that displays the content of the cell as it is, without any specific formatting such as number, date, accounting, or fraction formatting.Rate this question:
-
- 12.
Perhatikan gambar di bawah iniGambar diatas menyatakan...
- A.
A. format teks di tengah sel
- B.
B. format teks di tengah sel dan posisi miring 45 derajat
- C.
C. format teks miring 90 derajat dan bergaris bawah
- D.
D. format teks miring 45 derajat dan huruf tebal
- E.
E. format teks seperti biasanya tidak ada perubahan
Correct Answer
B. B. format teks di tengah sel dan posisi miring 45 derajatExplanation
The image shows text that is centered within a cell and tilted at a 45-degree angle. This formatting is not the usual format for text, as it deviates from the standard horizontal orientation. Therefore, the correct answer is b. format teks di tengah sel dan posisi miring 45 derajat.Rate this question:
-
- 13.
Gambar berikut menunjukkan penggunaan ....
- A.
Border
- B.
Table
- C.
Numbering
- D.
Chart
- E.
Grafik
Correct Answer
A. BorderExplanation
The given image shows the use of a border. A border is a decorative or functional element that is placed around the edges of an object or area to define its boundaries and separate it from its surroundings. In the context of the image, it is likely that the image is demonstrating how to add a border to a specific element or area, such as a table, chart, or graph.Rate this question:
-
- 14.
Tanda $ di depan lambang kolom ($A) artinya adalah . . .
- A.
Baris mutlak
- B.
Kolom mutlak
- C.
Baris dan kolom mutlak
- D.
Sel mutlak
- E.
Range mutlak
Correct Answer
B. Kolom mutlakExplanation
The symbol $ in front of a column label ($A) means that it is an absolute column reference. This means that the column reference will not change when the formula is copied or moved to other cells. The $ sign fixes the column reference so that it always refers to the same column, regardless of its position in the worksheet.Rate this question:
-
- 15.
Rumus untuk mencari data terkecil dari sebuah range adalah . ..
- A.
Count
- B.
Average
- C.
Sum
- D.
Min
- E.
Max
Correct Answer
D. MinExplanation
The correct answer is "min." The "min" function is used to find the smallest value within a range of data. It is commonly used in programming and data analysis to determine the minimum value in a set of numbers. By using the "min" function, you can easily identify the smallest value in a range without having to manually compare each number.Rate this question:
-
- 16.
Untuk mengabsolutkan sel B7 caranya adalah ...
- A.
B7
- B.
$B7
- C.
B$7
- D.
$B$7
- E.
$B7$
Correct Answer
D. $B$7Explanation
The correct answer is $B$7. This is because the dollar sign ($) before both the column letter (B) and the row number (7) makes the cell reference an absolute reference. An absolute reference means that when the formula or reference is copied to other cells, the reference will always point to the same cell, in this case, cell B7.Rate this question:
-
- 17.
Rumus untuk mencari jumlah dari sel A1 sampai dengan sel A14 adalah . . .
- A.
=SUM(A1:A14)
- B.
=COUNT(A1:A14)
- C.
=MIN(A1:A14)
- D.
=MAX(A1:A14)
- E.
=AVERAGE(A1:A14)
Correct Answer
A. =SUM(A1:A14)Explanation
The correct answer is =SUM(A1:A14). This formula calculates the sum of the values in cells A1 to A14.Rate this question:
-
- 18.
Di samping pembuatan rumus dapat dibuat dari Insert Function juga dapat . ..
- A.
DICOPY
- B.
Di tulis langsung
- C.
Dipaste
- D.
Insert
- E.
Format
Correct Answer
B. Di tulis langsungExplanation
The correct answer is "di tulis langsung". This means that besides creating formulas using "Insert Function", formulas can also be written directly.Rate this question:
-
- 19.
Untuk menghitung jumlah objek menggunakan fungsi ....
- A.
=count
- B.
=avg
- C.
=countif
- D.
=word
- E.
=rad
Correct Answer
A. =countExplanation
The correct answer is "=count". This function is used to count the number of cells in a range that contain numerical values. It is commonly used to find the total number of objects or items in a dataset.Rate this question:
-
- 20.
=MID(”INDONESIA”,3,3) menghasilkan . . .
- A.
Ind
- B.
Don
- C.
Nes
- D.
Sia
- E.
Ndo
Correct Answer
B. DonExplanation
The MID function in this question is used to extract a specific number of characters from a given text string, starting from a specified position. In this case, the text string is "INDONESIA" and the starting position is 3. The function is set to extract 3 characters. Therefore, the correct answer is "don" because it is the result of extracting the characters "don" from the text string "INDONESIA" starting from the third position.Rate this question:
-
- 21.
Pada sel A2 terisi 75, dan terdapat fungsi =IF(A2<60,”C”,IF(A2<75,”B”,IF(A2<=100,”A”))) maka akan memberi hasil ….
- A.
A
- B.
B
- C.
C
- D.
A ATAU B
- E.
FALSE
Correct Answer
B. BExplanation
The given formula uses nested IF statements to assign a grade based on the value in cell A2. If the value is less than 60, it will give a grade of "C". If the value is between 60 and 75, it will give a grade of "B". If the value is 75 or greater, it will give a grade of "A". Since the value in cell A2 is 75, it falls into the range of 75 or greater, so the formula will give a grade of "A".Rate this question:
-
- 22.
”Jika n lebih besar atau sama dengan 65 maka Lulus, jika n kurang dari 65 maka Mengulang”. Formula tersebut dituliskan pada Ms. Excel sebagai ....
- A.
=IF(n>=65,”Mengulang”,”Lulus”)
- B.
=IF(n>=65,”Lulus”,”Mengulang”)
- C.
=IF(n>=65,”Mengulang”,IF(n
- D.
=IF(n>=65,”Lulus”,IF(n>65,”Mengulang”))
- E.
=IF(n>65,”Lulus”,IF(n
Correct Answer
B. =IF(n>=65,”Lulus”,”Mengulang”)Explanation
The correct answer is "=IF(n>=65,”Lulus”,”Mengulang”)". This formula in Excel checks if the value of n is greater than or equal to 65. If it is, it returns "Lulus", which means "Pass" in English. If the value of n is less than 65, it returns "Mengulang", which means "Repeat" in English.Rate this question:
-
- 23.
Fungsi yang melibatkan sebuah tabel dan pembacaannya secara vertikal adalah ….
- A.
Vertikal
- B.
Horizontal
- C.
Vlookup
- D.
Hlookup
- E.
Lookup
Correct Answer
C. VlookupExplanation
The correct answer is vlookup. Vlookup is a function in Excel that allows you to search for a value in the first column of a table and retrieve a corresponding value in the same row from a different column. It is used to perform vertical lookups, where the search is done vertically down a column.Rate this question:
-
- 24.
Untuk mengabsolutkan range tabel, pada keyboard kita tekan tombol ..
- A.
F1
- B.
F2
- C.
F3
- D.
F4
- E.
F5
Correct Answer
D. F4Explanation
To complete the range table, we need to press the F4 key on the keyboard.Rate this question:
-
- 25.
Tampilan diatas merupakan sub menu dari...
- A.
Edit
- B.
File
- C.
Format
- D.
Table
- E.
Insert
Correct Answer
B. FileExplanation
The given sub menu is a part of the "file" menu.Rate this question:
-
- 26.
Perhatikan gambar berikut ini. Lembar kerja yang sedang aktif adalah ....
- A.
Sheet 1
- B.
Sheet 2
- C.
Sheet 3
- D.
Tidak ada sheet yang aktif
- E.
Sheet 1 dan 2
Correct Answer
A. Sheet 1Explanation
The correct answer is sheet 1 because it is mentioned in the question that "the active worksheet is..." and the only option that fits this description is sheet 1.Rate this question:
-
- 27.
merupakan tool menu ….
- A.
Sort descending
- B.
Sort ascending
- C.
Sort one
- D.
Sort up
- E.
Short down
Correct Answer
A. Sort descendingExplanation
The correct answer is "sort descending". This tool is used to arrange items or data in a specific order, with the highest or largest values appearing first and the lowest or smallest values appearing last.Rate this question:
-
- 28.
Hasil dari fungsi =VLOOKUP(B30,$B$36:$D$40,2) adalah...
- A.
C
- B.
D
- C.
JELEK
- D.
KURANG
- E.
FALSE
Correct Answer
C. JELEKExplanation
The correct answer for the given question is "JELEK". This is because the VLOOKUP function is used to search for a value in the first column of a range and return a value in the same row from a specified column. In this case, the function is searching for the value in cell B30 in the range B36:D40 and returning the value in the second column. Since the value in cell B30 corresponds to "JELEK" in the second column of the range, "JELEK" is the result of the function.Rate this question:
-
- 29.
Untuk memunculkan kata Melompong di kolom D, maka perintahnya ....
- A.
=HLOOKUP(B30,$B$36:$D$40,2)
- B.
=HLOOKUP(B30,$B$36:$D$40,3)
- C.
=VLOOKUP(B30,$B$36:$D$40,1)
- D.
=VLOOKUP(B30,$B$36:$D$40,2)
- E.
=VLOOKUP(B30,$B$36:$D$40,3)
Correct Answer
E. =VLOOKUP(B30,$B$36:$D$40,3)Explanation
The correct answer is =VLOOKUP(B30,$B$36:$D$40,3). This formula is used to search for the value of B30 in the range $B$36:$D$40 and return the value in the third column of that range. In this case, it will return the value in column D, which is "Melompong".Rate this question:
-
- 30.
Menu yang digunakan untuk mengurutkan data adalah ....
- A.
File
- B.
Edit
- C.
Insert
- D.
Data
- E.
Tools
Correct Answer
D. DataExplanation
The correct answer is "data" because the menu options given are file, edit, insert, data, and tools. Among these options, the "data" menu is most likely to have functions or options related to sorting or organizing data.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 -
Jun 02, 2010Quiz Created by
Tiksmanka
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Back to top