Ujian Tik Sman 1 Pangkalan Kuras Kelas X Sm 2
SILAHKAN JAWAB SOAL - SOAL UJIAN BERIKUT INI LAPORKAN HASIL UJIAN ANDA KE PENGAWAS
Questions and Answers
- 1.
Di bawah ini Prosedur yang di gunakan untuk mengaktifkan lembar Microsoft excel 2003,adalah…..
- A.
Start,program,Microsoft office
- B.
Start,program,Microsoft word
- C.
Start,Run,Microsoft excel
- D.
Start,program,Microsoft worksheet
- E.
Star,program,Microsoft excel
Correct Answer
E. Star,program,Microsoft excelExplanation
The correct answer is "Start, program, Microsoft excel." This is the correct procedure to activate Microsoft Excel 2003. The other options mentioned do not follow the correct sequence or include incorrect terms such as "Microsoft word" or "Microsoft worksheet."Rate this question:
-
- 2.
Istilah lain dari bentuk tampilan/jendela Microsoft excel adalah…..
- A.
Lembaran dokumen
- B.
Lembar Kerja
- C.
Kumpulan data
- D.
Worksheet
- E.
Workbook
Correct Answer
B. Lembar KerjaExplanation
The correct answer is "Lembar Kerja". In Microsoft Excel, a "Lembar Kerja" refers to a sheet or a tab within a workbook where data can be entered, organized, and manipulated. It is the primary interface where users can perform calculations, create charts, and analyze data. The term "Lembar Kerja" is commonly used in Indonesian to describe the worksheet in Excel.Rate this question:
-
- 3.
Yang bukan merupakan format perataan atau aligment pada lembar kerja Ms.excel adalah.....
- A.
Right
- B.
Left
- C.
Centre
- D.
Justify
- E.
Turn left
Correct Answer
E. Turn leftExplanation
The given options are all related to formatting or alignment in Microsoft Excel, except for "Turn left". "Turn left" does not represent any formatting or alignment option in Excel.Rate this question:
-
- 4.
Untuk mencari rata-rata dari beberapa angka digunakan fungsi…
- A.
SUM
- B.
MIN
- C.
AVERAGE
- D.
MAX
- E.
IF
Correct Answer
C. AVERAGEExplanation
The correct answer is AVERAGE because the question asks for the calculation of the average of several numbers. The AVERAGE function is specifically designed to calculate the average of a set of numbers.Rate this question:
-
- 5.
Pertemuan antara baris dan kolom dalam MS Excel disebut…
- A.
Jendela
- B.
Track
- C.
Sel
- D.
Worksheet
- E.
Sel
Correct Answer
C. SelExplanation
The correct answer is "Sel". In MS Excel, the intersection between a row and a column is called a cell. A cell is the basic unit of a worksheet and is identified by a unique combination of its column letter and row number. Therefore, the correct answer is "Sel" which translates to "Cell" in English.Rate this question:
-
- 6.
Perintah untuk menyimpan dokumen adalah…
- A.
CTRL+N
- B.
CTRL+S
- C.
CTRL+P
- D.
CTRL+H
- E.
CTRL+O
Correct Answer
B. CTRL+SExplanation
The correct answer is CTRL+S. This keyboard shortcut is commonly used to save documents in various software applications. By pressing CTRL+S, the user can quickly save their work without having to navigate through menus or use the mouse. This shortcut is widely recognized and used across different operating systems and software programs, making it a convenient and efficient way to save documents.Rate this question:
-
- 7.
Untuk menghitung jumlah semua jenis data dari suatu range digunakan rumus…
- A.
COUNTA
- B.
INDEX
- C.
COUNT
- D.
HLOOKUP
- E.
IF
Correct Answer
C. COUNTExplanation
The correct answer is COUNT because the COUNT function is used to calculate the number of cells in a range that contains numbers, text, logical values, or empty cells. It does not count cells that contain errors or text that appears as numbers.Rate this question:
-
- 8.
. Lambang yang digunakan untuk mengalikan angka dalam MS Excel adalah…
- A.
/
- B.
+
- C.
*
- D.
=
- E.
-
Correct Answer
C. *Explanation
The correct answer is *. In MS Excel, the * symbol is used as the multiplication operator. This symbol is used to multiply numbers or cell references together to perform mathematical calculations.Rate this question:
-
- 9.
Langkah untuk menyimpan file dengan nama yang diinginkan adalah…
- A.
File,save As
- B.
File,save
- C.
Close
- D.
CTRL+P
- E.
CTRL+O
Correct Answer
A. File,save AsExplanation
The correct answer is "File, save As" because when you want to save a file with a specific name, you need to go to the "File" menu and select "save As" option. This allows you to choose the desired name and location for the file before saving it.Rate this question:
-
- 10.
Jika dalam cell C3 berisi angka 50 dan di cell D3 berisi angka 60, maka jika ingin dikalikan, penulisannya adalah…
- A.
=50*60
- B.
=C3*D3
- C.
=C3xD3
- D.
C3.D3
- E.
C3*D3
Correct Answer
B. =C3*D3Explanation
The correct answer is =C3*D3 because in Excel, to multiply the values in two cells, we use the asterisk (*) symbol. So, to multiply the value in cell C3 (50) with the value in cell D3 (60), we write =C3*D3.Rate this question:
-
- 11.
Ctrl+P adalah shortcut key untuk memunculkan kotak dialog …
- A.
Page setup
- B.
Customize
- C.
Heater
- D.
Format cells
- E.
Print
Correct Answer
E. PrintExplanation
Ctrl+P adalah shortcut key untuk mencetak dokumen atau halaman yang sedang aktif. Ketika pengguna menekan Ctrl+P, kotak dialog pencetakan akan muncul, yang memungkinkan pengguna untuk mengatur opsi pencetakan seperti jumlah salinan, ukuran kertas, dan printer yang akan digunakan. Dengan menggunakan shortcut ini, pengguna dapat dengan cepat mencetak dokumen tanpa harus mencari menu pencetakan di toolbar atau menu.Rate this question:
-
- 12.
Ikon “Undo” berfungsi untuk…
- A.
Mencetak dokumen
- B.
Menyimpan dokumen
- C.
Membuka file
- D.
Memotong bagian dari dokumen
- E.
Membatalkan pengerjaan
Correct Answer
E. Membatalkan pengerjaanExplanation
The correct answer is "membatalkan pengerjaan" which means "to cancel an action". This option is the most appropriate because "Undo" is a feature commonly found in software applications that allows users to reverse their last action or restore a previous state. Therefore, selecting "membatalkan pengerjaan" accurately describes the function of the "Undo" icon.Rate this question:
-
- 13.
Untuk menembah COLOUM dalam Excel, perintah yang diklik pada menu Insert adalah …
- A.
Insert Cells
- B.
Insert Sheet Rows
- C.
Insert Sheet Column
- D.
Insert Sheet
- E.
Insert Name
Correct Answer
C. Insert Sheet ColumnExplanation
The correct answer is "Insert Sheet Column". This option is chosen to add a new column in Excel. By selecting this option from the Insert menu, a new column is inserted to the left of the selected column, shifting the existing columns to the right.Rate this question:
-
- 14.
Salah satu cara menyimpan wordbook pada excel adalah dengan menggunakan…
- A.
Ctrl+B
- B.
Ctrl+P
- C.
Ctrl+C
- D.
Ctrl+V
- E.
Ctrl+S
Correct Answer
E. Ctrl+SExplanation
Ctrl+S is the correct answer because it is the keyboard shortcut to save a file in Microsoft Excel. By pressing Ctrl+S, the user can save the wordbook they have created in Excel, ensuring that any changes or updates made to the file are saved and can be accessed later.Rate this question:
-
- 15.
Fungsi yang digunakan untuk menghitung penjumlahan data angka…..
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
- E.
Count
Correct Answer
A. SumExplanation
The correct answer is "Sum". The function "Sum" is used to calculate the total sum of a set of numerical data. It adds up all the numbers in the dataset and provides the sum as the result.Rate this question:
-
- 16.
Fungsi yang digunakan untuk menghitung nilai terbesar data angka…
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
- E.
Count
Correct Answer
B. MaxExplanation
The correct answer is "Max". The function "Max" is used to calculate the largest value among a set of numerical data. It returns the maximum value from the given data.Rate this question:
-
- 17.
. Fungsi yang digunakan untuk menghitung nilai terkecil data angka…
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
- E.
Count
Correct Answer
C. MinExplanation
The correct answer is "Min". The function "Min" is used to calculate the smallest value in a set of numerical data. It is commonly used to find the minimum value in a given range or to compare values and determine the smallest one.Rate this question:
-
- 18.
Berikut ini yang merupakan alamat sel, yaitu .…
- A.
84
- B.
3F
- C.
B5.
- D.
BB
- E.
F0
Correct Answer
C. B5.Explanation
The given answer "B5" is the correct address of the cell. This can be deduced from the information provided in the question. The question states "Berikut ini yang merupakan alamat sel" which translates to "The following is the address of the cell." Therefore, "B5" is the correct answer as it is the given address.Rate this question:
-
- 19.
Cara menjalankan aplikasi Microsoft Excel dengan menggunakan fasilitas shortcut yang ada di desktop Windows adalah ….
- A.
Kilik Start, pilih Programs, klik Microsoft Excel
- B.
Double klik shortcut Excel
- C.
Klik kanan shortcut Excel
- D.
Klik shortcut Excel
- E.
Klik Start, klik Microsoft Excel
Correct Answer
B. Double klik shortcut ExcelExplanation
To run the Microsoft Excel application using the shortcut on the Windows desktop, you need to double-click on the shortcut icon for Excel. This action will launch the Excel program and open the application for use.Rate this question:
-
- 20.
Perintah untuk menyisipkan kolom pada Microsoft Excel adalah ....
- A.
Addcolomn
- B.
Edit colomn
- C.
Insertcolomn
- D.
Format colomn
- E.
Viewcolomn
Correct Answer
C. InsertcolomnExplanation
The correct answer is "Insertcolomn." In Microsoft Excel, the command to insert a column is called "Insert Column." This command allows users to add a new column in between existing columns in a worksheet. By selecting the column where the new column should be inserted and using the "Insert Column" command, users can easily expand their data and make room for additional information or calculations.Rate this question:
-
- 21.
Dibawah ini adalah fungsi dari IF OR yaitu ....
- A.
Menghasilkan nilai dari satu logika yang diuji kebenarannya
- B.
Menghasilkan nilai lebih dari satu logika yang diuji kebenarannya
- C.
Menghasilkan nilai benar bila berargumen benar
- D.
Menampilkan angka tahun
- E.
Menampilkan angka tanggal dalam data bulan
Correct Answer
C. Menghasilkan nilai benar bila berargumen benarExplanation
IF OR function in Excel is used to test multiple conditions and return a TRUE value if any of the conditions are TRUE. It checks each argument one by one and returns TRUE if at least one argument is TRUE. In this case, the correct answer suggests that the IF OR function will produce a TRUE value if the argument is true.Rate this question:
-
- 22.
Dalam Ms. Excel, untuk menampilkan beberapa dokumen dengan mode layar penuh menggunakan submenu ……
- A.
Page Break Preview
- B.
Full Screen
- C.
Custom Views
- D.
New Window
- E.
Heading
Correct Answer
B. Full ScreenExplanation
To display multiple documents in full screen mode in Microsoft Excel, you can use the "Full Screen" option. This option allows you to view your documents without any distractions or clutter from the Excel interface, maximizing the available screen space for your documents. By selecting this option from the submenu, you can easily switch between different documents and focus solely on their content.Rate this question:
-
- 23.
Untuk menggabungkan beberapa sel menjadi satu, kita harus menggunakan submenu ……..
- A.
Merge and Center
- B.
Merge Across
- C.
Merge Cells
- D.
Unmerge Cells
- E.
Sort
Correct Answer
A. Merge and CenterExplanation
To combine multiple cells into one, the appropriate submenu to use is "Merge and Center". This option allows you to merge the selected cells and center the content within the merged cell. It is a useful feature when you want to create a header or title that spans across multiple columns or rows.Rate this question:
-
- 24.
Berikut merupakan tombol yang digunakan dalam memformat teks agar menjadi miring, yaitu ….
- A.
Ctrl+B
- B.
Ctrl+I
- C.
Ctrl+U
- D.
Ctrl+S
- E.
Ctrl+O
Correct Answer
B. Ctrl+IExplanation
The correct answer is Ctrl+I. This keyboard shortcut is commonly used to format text and make it italicized in various text editing applications. By pressing Ctrl+I, the selected text will be transformed into italic font style.Rate this question:
-
- 25.
Fungsi dalam excel yang di gunakan menghitung rata-rata dari sekelompok nilai…
- A.
SUM
- B.
AVERAGE
- C.
MAX
- D.
MIN
- E.
IF
Correct Answer
B. AVERAGEExplanation
The correct answer is AVERAGE because the question asks for the Excel function that calculates the average of a group of values. The AVERAGE function in Excel adds up all the values in the specified range and then divides the sum by the number of values in the range, giving the average value.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 17, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 09, 2013Quiz Created by
Labcom
Back to top