# A. Ulangan Kkpi 10 Ap1 & 2 Bag 6

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 Gunawancld
G
Gunawancld
Community Contributor
Quizzes Created: 1 | Total Attempts: 149
Questions: 25 | Attempts: 149

Settings

KLIK SATU JAWABAN YANG BENAR PADA BULATAN

• 1.

### Memberi simbol Rp. Pada lembar kerja yang menyatakan nilai uang dengan memilih Format - Cell - Number dari kotak dialog yang tampil memilih tab .........

• A.

Percentage

• B.

Time

• C.

Date

• D.

Number

• E.

Accounting

E. Accounting
Explanation
The correct answer is Accounting. In accounting, it is common practice to use the symbol Rp. to represent the currency value in Indonesia. By selecting the Accounting format in the Format - Cell - Number dialog box, the user can easily add the Rp. symbol to the worksheet, making it clear that the values represent monetary amounts.

Rate this question:

• 2.

### Dengan meng-klik menu Format - Row - Height digunakan untuk ..........

• A.

Meninggikan baris

• B.

Melebarkan baris

• C.

Meninggikan kolom

• D.

Melebarkan kolom

• E.

A. Meninggikan baris
Explanation
By clicking on the Format - Row - Height menu, you can increase the height of the rows in a spreadsheet. This allows you to adjust the spacing between rows and make the content in the rows more visible.

Rate this question:

• 3.

### Gambar diatas dalam lembar sebar disebut ........

• A.

• B.

Title Bar

• C.

Toolbar

• D.

Cell Pointer

• E.

Scroll Bar

Explanation
The correct answer is Menu Bar. The question is asking for the term used to describe the image in a brochure. The image in the brochure is referred to as the Menu Bar.

Rate this question:

• 4.

### Untuk menutup lembar sebar digunakan perintah ........

• A.

File - Exit

• B.

File - Close

• C.

File - Print

• D.

File - Open

• E.

File - New

B. File - Close
Explanation
The correct answer is "File - Close" because the question is asking for the command to close a spreadsheet. "File - Close" is the appropriate command to use when you want to close a file or document in most software applications.

Rate this question:

• 5.

### Cara membuat lembar kerja baru dengan cepat menggunakan..........

• A.

Ctrl + N

• B.

Ctrl + S

• C.

Ctrl + O

• D.

Ctrl + P

• E.

Ctrl + V

A. Ctrl + N
Explanation
To quickly create a new worksheet, you can use the keyboard shortcut Ctrl + N. This command is commonly used in various software applications to create a new document or file. In this case, pressing Ctrl + N will create a new worksheet in the program or software being used.

Rate this question:

• 6.

### Simbol disamping merupakan simbol dari perangkat lunak lembar sebar ......

• A.

Microsoft Excel

• B.

Open Office Calc

• C.

Open Office Lembar Sebar

• D.

Microsoft Access

• E.

Microsoft Word

A. Microsoft Excel
Explanation
The correct answer is Microsoft Excel because it is a software program commonly used for creating spreadsheets. The symbol next to it is likely representing the logo or icon associated with Microsoft Excel.

Rate this question:

• 7.

### JIka sel A1 berisi angka 10 dan sel B1 angka 5 kemudian pada sel C1 dimasukkan formula perkalian data tersebut maka penulisan yang benar adalah ........

• A.

10 x 5

• B.

A1 * B1

• C.

= 10 x 5

• D.

= 10 * 5

• E.

= A1 * B1

E. = A1 * B1
Explanation
The correct answer is "= A1 * B1" because the formula in cell C1 should refer to the values in cells A1 and B1, which are 10 and 5 respectively. The multiplication operator (*) is used to multiply the values in these cells, resulting in the product of 10 and 5. Therefore, the correct formula to write in cell C1 is "= A1 * B1".

Rate this question:

• 8.

### Penulisan logika yang benar adalah .........

• A.

=IF(A3>,5,A1=200)

• B.

=IF(A1>5,"Sarjana","DO")

• C.

=A1>5,"Sarjana","DO")

• D.

=IF(A1>5,A1*B1,A1..B1)

• E.

IF(A1>5,A1*B1,A1..B1)

B. =IF(A1>5,"Sarjana","DO")
Explanation
The correct answer is "=IF(A1>5,"Sarjana","DO")". This is the correct logical formula in Excel to check if the value in cell A1 is greater than 5. If it is, the formula will return "Sarjana", otherwise it will return "DO".

Rate this question:

• 9.

### Ikon yang digunakan untuk pembuatan grafik adalah ........

• A.

Open

• B.

Toolbar Standard

• C.

Charter

• D.

Cut

• E.

Chart Wizard

E. Chart Wizard
Explanation
The correct answer is Chart Wizard because it is the tool used for creating graphs and charts in various software programs. The Chart Wizard guides the user through the process of selecting data, choosing the chart type, customizing the appearance, and inserting the chart into the desired location. It simplifies the process of creating visually appealing and informative charts by providing step-by-step instructions and options for customization.

Rate this question:

• 10.

### Perkalian, pembagian, pengurangan, pemangkatan termasuk fungsi ...............

• A.

Matematika

• B.

Statistika

• C.

Finansial

• D.

String

• E.

Pembacaan tabel data

A. Matematika
Explanation
The given question is asking for the category to which multiplication, division, subtraction, and exponentiation belong. These operations are all mathematical functions, so the correct answer is "Matematika" which means "Mathematics" in Indonesian.

Rate this question:

• 11.

### Perintah untuk menyembunyikan / menampilkan kembali garis bantu ( tanda pembatas kolom dan baris ) pada layar adalah .........

• A.

Format, Cells, Protection, Ok

• B.

Tools, Options, Gridlines, Ok

• C.

Format, Cells, Borders,Ok

• D.

Format, Cells, Font, Ok

• E.

Format, Cells, Patterns, Ok

B. Tools, Options, Gridlines, Ok
Explanation
The correct answer is "Tools, Options, Gridlines, Ok". This option suggests that the command to hide/show gridlines on the screen is located in the "Tools" menu, under the "Options" submenu. By selecting this option and clicking "Ok", the user can toggle the visibility of gridlines, which are the column and row boundaries on the screen.

Rate this question:

• 12.

### Sel memiliki identitas yang terdiri

• A.

• B.

Huruf baris saja

• C.

• D.

• E.

C. Abjad kolom dan angka baris
Explanation
The correct answer is "Abjad kolom dan angka baris." This means that the identity of the cell is determined by both the column letter and the row number. In a spreadsheet or table, each cell is identified by a combination of a letter for the column and a number for the row. This combination allows for a unique identification of each cell in the table.

Rate this question:

• 13.

### Fungsi yang digunakan untuk mencari nilai rata-rata adalah ....................

• A.

SUM

• B.

MIN

• C.

AVERAGE

• D.

MAX

• E.

COUNT

C. AVERAGE
Explanation
The correct answer is AVERAGE. The AVERAGE function is used to calculate the mean or average value of a range of numbers. It adds up all the numbers in the range and then divides the sum by the count of numbers in the range. This function is commonly used in data analysis and statistical calculations to find the central tendency of a set of values.

Rate this question:

• 14.

### Fungsi yang digunakan untuk mencari nilai terendah adalah ....................

• A.

MAX

• B.

MIN

• C.

AVERAGE

• D.

COUNT

• E.

SUM

B. MIN
Explanation
The correct answer is "MIN". This function is used to find the lowest value in a set of numbers or a range of cells. It returns the smallest value among the arguments provided.

Rate this question:

• 15.

### Fungsi yang digunakan untuk mengitung jumlah adalah ....................

• A.

SUM

• B.

AVERAGE

• C.

MAX

• D.

MIN

• E.

COUNT

A. SUM
Explanation
The correct answer is SUM. The SUM function is used to calculate the total sum of a range of numbers. It adds up all the numbers in a given range and returns the total sum.

Rate this question:

• 16.

### Fungsi yang digunakan untuk jumlah banyaknya data adalah ....................

• A.

MAX

• B.

MIN

• C.

AVERAGE

• D.

COUNT

• E.

SUM

D. COUNT
Explanation
The correct answer is COUNT. COUNT is a function used to calculate the number of data points in a dataset. It counts the total number of rows or records in a table or a range of cells.

Rate this question:

• 17.

### Berkas yang telah disimpan dapat dibuka kembali dengan ...

• A.

New

• B.

Open

• C.

Save

• D.

Print

B. Open
Explanation
The correct answer is "open". This is because the sentence states that a saved file can be reopened, implying that it can be accessed or viewed again. The other options, "new", "save", and "print", do not indicate the action of reopening a file. Therefore, "open" is the most appropriate choice.

Rate this question:

• 18.

### Gambar yang digunakan untuk....

• A.

Under line

• B.

Rata sebelah kanan

• C.

Rata sebelah kiri

• D.

Meletakan teks ditengah-tengah sel

D. Meletakan teks ditengah-tengah sel
Explanation
The correct answer is "meletakan teks ditengah-tengah sel" which means "placing text in the middle of the cell". This suggests that the given image is used to demonstrate how to center-align text within a cell in a table or spreadsheet.

Rate this question:

• 19.

• A.

XcD

• B.

XFD

• C.

DXF

• D.

CFE

B. XFD
Explanation
The last column in MS Excel is labeled as XFD.

Rate this question:

• 20.

• A.

1048576

• B.

1054876

• C.

1408576

• D.

1054876

A. 1048576
Explanation
The correct answer is 1048576. In Microsoft Excel 2007, the maximum number of rows is 1048576. This means that Excel can accommodate up to 1048576 rows of data in a single worksheet.

Rate this question:

• 21.

### Perkalian, pembagian, pengurangan, pemangkatan termasuk fungsi ...............

• A.

Matematika

• B.

Statistika

• C.

Finansial

• D.

String

• E.

Pembacaan tabel data

A. Matematika
Explanation
The given question is asking for the category to which multiplication, division, subtraction, and exponentiation belong. These operations are all mathematical functions, so the correct answer is "Matematika" (Mathematics).

Rate this question:

• 22.

### Perintah untuk menyembunyikan / menampilkan kembali garis bantu ( tanda pembatas kolom dan baris ) pada layar adalah .........

• A.

Format, Cells, Protection, Ok

• B.

Tools, Options, Gridlines, Ok

• C.

Format, Cells, Borders,Ok

• D.

Format, Cells, Font, Ok

• E.

Format, Cells, Patterns, Ok

B. Tools, Options, Gridlines, Ok
Explanation
The correct answer is "Tools, Options, Gridlines, Ok". This option suggests that the command to hide/show gridlines on the screen is located under the "Tools" menu, then selecting "Options", and finally choosing "Gridlines" and clicking "Ok". This command allows the user to toggle the visibility of the gridlines, which are the column and row boundaries, on the screen.

Rate this question:

• 23.

### JIka sel A1 berisi angka 10 dan sel B1 angka 5 kemudian pada sel C1 dimasukkan formula perkalian data tersebut maka penulisan yang benar adalah ........

• A.

10 x 5

• B.

A1 * B1

• C.

= 10 x 5

• D.

= 10 * 5

• E.

= A1 * B1

E. = A1 * B1
Explanation
The correct answer is "= A1 * B1" because the formula for multiplication in Excel is using the asterisk (*) symbol. So, to multiply the values in cells A1 and B1, we need to use the formula "= A1 * B1".

Rate this question:

• 24.

### Penulisan logika yang benar adalah .........

• A.

=IF(A3>,5,A1=200)

• B.

=IF(A1>5,"Sarjana","DO")

• C.

=A1>5,"Sarjana","DO")

• D.

=IF(A1>5,A1*B1,A1..B1)

• E.

IF(A1>5,A1*B1,A1..B1)

B. =IF(A1>5,"Sarjana","DO")
Explanation
The correct answer is "=IF(A1>5,"Sarjana","DO")". This is the correct syntax for the logical function IF in Excel. It checks if the value in cell A1 is greater than 5, and if it is, it returns the text "Sarjana". If the value is not greater than 5, it returns the text "DO".

Rate this question:

• 25.

### Ikon yang digunakan untuk pembuatan grafik adalah ........

• A.

Open

• B.

Toolbar Standard

• C.

Charter

• D.

Cut

• E.

Chart Wizard