# Quiz Tik Kelas Xi Semeter 2

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.
| By Tiksmanka
T
Tiksmanka
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,374
Questions: 30 | Attempts: 928  Settings  Sebelum mengerjakan tes isi identitas kamu berikut dengan kelasnya contoh: ajis x.2

• 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

C. Pertemuan baris dan kolom
Explanation
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.

• A.

• B.

• C.

• D.

• E.

Explanation
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

A. Merge Cells
Explanation
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

A. Function
Explanation
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

C. Merge Cells
Explanation
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

E. Editing
Explanation
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

B. Currency
Explanation
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

C. Kolom kurang lebar
Explanation
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

B. Format Tanggal
Explanation
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.

/

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

E. Format General
Explanation
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

B. B. format teks di tengah sel dan posisi miring 45 derajat
Explanation
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

A. Border
Explanation
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

B. Kolom mutlak
Explanation
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

D. Min
Explanation
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\$

D. \$B\$7
Explanation
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)

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

B. Di tulis langsung
Explanation
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.

A. =count
Explanation
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

B. Don
Explanation
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

B. B
Explanation
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

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

C. Vlookup
Explanation
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

D. F4
Explanation
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

B. File
Explanation

Rate this question:

• 26.

### Perhatikan gambar berikut ini. Lembar kerja yang sedang aktif adalah ....

• A.

Sheet 1

• B.

Sheet 2

• C.

Sheet 3

• D.

• E.

Sheet 1 dan 2

A. Sheet 1
Explanation
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.

• A.

Sort descending

• B.

Sort ascending

• C.

Sort one

• D.

Sort up

• E.

Short down

A. Sort descending
Explanation
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

C. JELEK
Explanation
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)

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.

• A.

File

• B.

Edit

• C.

Insert

• D.

Data

• E.

Tools Back to top