A. Ulangan Kkpi 10 Ap1 & 2 Bag 6
KLIK SATU JAWABAN YANG BENAR PADA BULATAN
Questions and Answers
- 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
Correct Answer
E. AccountingExplanation
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.
Tidak ada pengaruh
Correct Answer
A. Meninggikan barisExplanation
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.
Menu Bar
- B.
Title Bar
- C.
Toolbar
- D.
Cell Pointer
- E.
Scroll Bar
Correct Answer
A. Menu BarExplanation
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
Correct Answer
B. File - CloseExplanation
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
Correct Answer
A. Ctrl + NExplanation
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
Correct Answer
A. Microsoft ExcelExplanation
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
Correct Answer
E. = A1 * B1Explanation
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)
Correct Answer
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
Correct Answer
E. Chart WizardExplanation
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
Correct Answer
A. MatematikaExplanation
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
Correct Answer
B. Tools, Options, Gridlines, OkExplanation
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.
Abjad kolom saja
- B.
Huruf baris saja
- C.
Abjad kolom dan angka baris
- D.
Abjad baris dan angka kolom
- E.
Abjad kolom dan angka kolom
Correct Answer
C. Abjad kolom dan angka barisExplanation
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
Correct Answer
C. AVERAGEExplanation
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
Correct Answer
B. MINExplanation
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
Correct Answer
A. SUMExplanation
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
Correct Answer
D. COUNTExplanation
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
Correct Answer
B. OpenExplanation
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
Correct Answer
D. Meletakan teks ditengah-tengah selExplanation
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.
Kolom teraahir pada MS Excel adalah
- A.
XcD
- B.
XFD
- C.
DXF
- D.
CFE
Correct Answer
B. XFDExplanation
The last column in MS Excel is labeled as XFD.Rate this question:
-
- 20.
BANYAKNYA BARIS PAD ms eXCEL 2007 ADALAH
- A.
1048576
- B.
1054876
- C.
1408576
- D.
1054876
Correct Answer
A. 1048576Explanation
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
Correct Answer
A. MatematikaExplanation
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
Correct Answer
B. Tools, Options, Gridlines, OkExplanation
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
Correct Answer
E. = A1 * B1Explanation
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)
Correct Answer
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
Correct Answer
E. Chart WizardExplanation
The correct answer is "Chart Wizard" because it is the tool used for creating charts or graphs in various software applications. It provides a step-by-step guide for selecting the data, choosing the chart type, customizing the appearance, and inserting the chart into the document or presentation. The Chart Wizard simplifies the process of creating professional-looking charts by providing pre-designed templates and options to customize the chart according to the user's requirements.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 -
May 29, 2013Quiz Created by
Gunawancld
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