Soal Ulangan Online Smk Sari Putra Jakarta
.jpg "Soal Ulangan Online Smk Sari Putra Jakarta - Quiz")
Ulangan Harian MID Semester Kelas X
- 1.
Software spreadsheet yang di produksi Oleh Microsoft adalah. ...
- A.
Microsoft Excel
- B.
Spreadsheet
- C.
Calc
- D.
Lotus
- E.
Accurate
Correct Answer
A. Microsoft ExcelExplanation
Microsoft Excel is the correct answer because it is a software spreadsheet produced by Microsoft. It is widely used for creating, editing, and analyzing data in a tabular format. Excel offers various features such as formulas, charts, graphs, and data manipulation tools, making it a popular choice for businesses, organizations, and individuals.Rate this question:
-
- 2.
Untuk membuka Microsoft Excel melalui fasilitas Run, Langkah-langkahnya adalah : Klik Star -> ........ . -> Run ðEnter atau Klik Ok.
- A.
Microsoft Excel
- B.
Ms Excel
- C.
MSEXCEL
- D.
Excel
- E.
M.Excel
Correct Answer
D. ExcelExplanation
To open Microsoft Excel through the Run facility, the correct step is to click on Start, then type "Excel" in the Run dialog box and press Enter or click OK.Rate this question:
-
- 3.
Satuan terkecil area pada lembar kerja Microsoft Excel adalah. ...
- A.
Sel
- B.
Kolom
- C.
Baris
- D.
Sheet
- E.
Workbook
Correct Answer
A. SelExplanation
The correct answer is "Sel". In Microsoft Excel, a "Sel" refers to a single cell, which is the smallest unit of area on a worksheet. It is the intersection of a row and a column and can be used to store data or perform calculations.Rate this question:
-
- 4.
Tombol fungsi yang bisa digunakan untuk menyimpan workbook adalah tombol. ...
- A.
F1
- B.
F2
- C.
F4
- D.
F8
- E.
F12
Correct Answer
E. F12Explanation
The correct answer is F12 because in Microsoft Excel, pressing the F12 key opens the "Save As" dialog box, allowing the user to save the workbook with a new name or in a different location. This key function is commonly used to save workbooks in Excel.Rate this question:
-
- 5.
Jika kita mengetik angka “2014” pada suatu sel, di mana sel tersebut belum dilakukan Setting terlebih dahulu, maka akan menghasilkan tampilan seperti pada gambar di atas adalah. ...
- A.
Gambar 1
- B.
Gambar 2
- C.
Gambar 3
- D.
Gambar 4
- E.
Gambar 5
Correct Answer
A. Gambar 1Explanation
The correct answer is "Gambar 1" because when we type the number "2014" in a cell without prior formatting, it will be displayed as a general number without any specific formatting applied.Rate this question:
-
- 6.
Selain dengan mengklik tombol Close Wndows yang berada di sudut kanan atas, untuk menutup workbook dapat juga dilakukan dengan perintah. ...
- A.
Alt + F + X
- B.
Alt + F + C
- C.
Alt + F + N
- D.
Ctrl + X
- E.
Ctrl + C
Correct Answer
B. Alt + F + CExplanation
To close a workbook, you can click on the Close Windows button in the top right corner or use the shortcut Alt + F + C. This shortcut allows you to quickly close the active workbook without having to use the mouse. It is a convenient and efficient way to close the workbook and move on to other tasks.Rate this question:
-
- 7.
Sel A1 berisi agka 1 dan sel A2 berisi angka 4. Lalu kedua sel tersebut di blok dan drag memalui Fil handle-nya hingga sel A5; maka sel A5 berisi angka. ...
- A.
10
- B.
11
- C.
12
- D.
13
- E.
14
Correct Answer
D. 13Explanation
When the cells A1 and A2 are blocked and dragged through the fill handle until cell A5, the numbers in the cells are incremented by 1 each time. So, the number in cell A5 will be 13, as it is the next number in the sequence.Rate this question:
-
- 8.
Posisi Kata “MedalI” pada sel tergabung. Hal ini dapat terjadi setelah kita mengklik toolbar No Pada gambar di bawah ini. ...
- A.
No 1
- B.
No 2
- C.
No 3
- D.
No 4
- E.
No 5
Correct Answer
D. No 4Explanation
The correct answer is No 4 because when we click on the toolbar, it will rearrange the cells in the table. So, the position of the word "MedalI" can change and it can be located in any of the cells.Rate this question:
-
- 9.
Toolbar yang digunakan untuk membuat grafik, pada gambar di bawah ini terdapat pada No. ...
- A.
No. 1
- B.
No. 2
- C.
No. 4
- D.
No. 5
- E.
No. 6
Correct Answer
C. No. 4Explanation
The toolbar used to create graphs is located at No. 4 in the image.Rate this question:
-
- 10.
Memblok seluruh sel yang terdapat pada suatu sheet, dapat di lkukan dengan perintah. ...
- A.
Ctrl+X
- B.
Ctrl+C
- C.
Ctrl+A
- D.
Ctrl+N
- E.
Ctrl+S
Correct Answer
C. Ctrl+AExplanation
Ctrl+A is the correct answer because it is the keyboard shortcut for selecting all the cells in a sheet. By pressing Ctrl+A, all the cells on the sheet will be highlighted or selected, allowing the user to perform actions such as copying, cutting, formatting, or deleting the selected cells.Rate this question:
-
- 11.
Menekan tombol Shift + Page Up digunakan untuk memblok. ...
- A.
1 sel di kanan Pointer
- B.
1 sel di kiri Pointer
- C.
1 sel di atas pointer
- D.
1 sel di bawah pointer
- E.
1 kolom perlayar ke atas
Correct Answer
C. 1 sel di atas pointerExplanation
Menekan tombol Shift + Page Up digunakan untuk memblok satu sel di atas pointer. This means that pressing Shift + Page Up allows you to select one cell above the current pointer position.Rate this question:
-
- 12.
Jika posisi sel aktif di B2, lalu kita tekan tombol Shift hingga kita klik sel E8, yang terjadi adalah. ...
- A.
Sel aktif pindah ke sel E8
- B.
Sel aktif pada dua tempat, yaitu di B2 dan E8
- C.
Terblok area sebanyak 7 sel, dari sel B2 hingga E8
- D.
Terblok area sebanyak 28 sel, dari sel B2 hingga E8
- E.
Terblok area sebanyak 4 sel, dari sel B2 hingga E8
Correct Answer
D. Terblok area sebanyak 28 sel, dari sel B2 hingga E8Explanation
When the active cell is in B2 and we press the Shift button until we click on cell E8, the area between B2 and E8 is selected and blocked. This means that a total of 28 cells are blocked, including B2 and E8.Rate this question:
-
- 13.
Perhatikan gambar berikut ! Kata “Lahir” tidak berada di sebelah kanan dari kata “Tanggal” karena. ....
- A.
Setelah menulis “tanggal” lalu Enter
- B.
Baris no 2 di lebarkan
- C.
Kolom B di persempit
- D.
Setelah menulis “tanggal” lalu kita tekan tombol panah ke bawah ()
- E.
Kita mengaktifkan Wrap text pada opsi Text Control
Correct Answer
E. Kita mengaktifkan Wrap text pada opsi Text ControlExplanation
The word "Lahir" is not placed to the right of the word "Tanggal" because the Wrap text option in Text Control is activated.Rate this question:
-
- 14.
Jika pada suatu sel, kita mengetikkan kata “Keterangan” dan format Orientation-nya diset 15 degrees, maka akan menghasilkan tampilan pada gambar di bawah ini dengan Nomor. ...
- A.
Gambar No.1
- B.
Gambar No.2
- C.
Gambar No.3
- D.
Gambar No.4
- E.
Gambar No.5
Correct Answer
B. Gambar No.2 -
- 15.
Jika pada suatu Cell, kita mengetikkan angka “2000” dan di lakukan format angka, dengan Categori =Number dan Decimal place = 2, maka akan menghasilkan tampilan sebagai berikut. ...
- A.
2000
- B.
2.000
- C.
2000,00
- D.
2.000,00
- E.
2,000
Correct Answer
D. 2.000,00Explanation
The correct answer is "2.000,00" because when the number "2000" is formatted as a number with 2 decimal places, it will be displayed with a comma as the thousand separator and a dot as the decimal separator. Therefore, the number will be displayed as "2.000,00".Rate this question:
-
- 16.
Untuk melebarkan kolom C, arahkan pointer ke atas kolom C dan D hingga pointer tersebut berbentuk +, lalu lakukan. ...
- A.
Klik
- B.
Double clik
- C.
Klik kanan
- D.
Drag
- E.
Scroll
Correct Answer
D. DragExplanation
To widen column C, the user needs to drag the pointer from the top of column C and D until the pointer changes to a plus sign. This action allows the user to adjust the width of the column by dragging it to the desired size.Rate this question:
-
- 17.
Home " Forma t" RowHeight ......... "Ok, adalah serangkaian perintah yang digunakan untuk. ...
- A.
Mengubah lebar kolom
- B.
Menghapus kolom
- C.
Mengubah tinggi baris
- D.
Menghapus baris
- E.
Menyisipkan baris
Correct Answer
C. Mengubah tinggi barisExplanation
The given correct answer for this question is "Mengubah tinggi baris" which means "Changing the row height" in English. This is the correct answer because the question is asking for a command that is used to modify the height of rows in a spreadsheet or table. Therefore, "Mengubah tinggi baris" accurately describes the action of adjusting the height of rows.Rate this question:
-
- 18.
Untuk menuliskan suatu fungsi dalam Excel, diawali dengan tanda. ...
- A.
#
- B.
%
- C.
*
- D.
@
- E.
=
Correct Answer
E. =Explanation
The correct answer is "=" because in Excel, to write a function, it is always preceded by the "=" sign. This indicates to Excel that the following input should be interpreted as a formula or function rather than a regular text entry. The "=" sign is used to distinguish between regular data and formulas in Excel, allowing users to perform calculations and manipulate data effectively.Rate this question:
-
- 19.
Ada lima sel baris angka, berturut-turut sebagai berikut : A1=4, A2=5, A3=6, A4=7, A5=8. Jika pada sel A6 kita tiliskan =AVERAGE(A1:A5). Ketika kita menekan tombol Enter maka sel A6 akan berisi angka. ...
- A.
6
- B.
4
- C.
8
- D.
7
- E.
5
Correct Answer
A. 6Explanation
The answer is 6 because the AVERAGE function calculates the average of the numbers in the range A1:A5, which are 4, 5, 6, 7, and 8. The average of these numbers is 6.Rate this question:
-
- 20.
Ada lima sel baris angka, berturut-turut sebagai berikut : A1=4, A2=5, A3=6, A4=7, A5=8. Jika pada sel A6 kita tiliskan =COUNT(A1:A5). Ketika kita menekan tombol Enter maka sel A6 akan berisi angka. ...
- A.
6
- B.
4
- C.
8
- D.
5
- E.
7
Correct Answer
D. 5Explanation
The correct answer is 5 because the formula "=COUNT(A1:A5)" counts the number of cells in the range A1 to A5 that contain numbers. In this case, there are 5 cells that contain numbers, which are 4, 5, 6, 7, and 8. Therefore, the result of the formula is 5.Rate this question:
-
- 21.
Untuk merubah tampilan 8000 menjadi Rp. 8000 dalam Ms. Excel di gunakan format Cell. ...
- A.
Genera
- B.
Number
- C.
Cureency
- D.
Date
- E.
Scientific
Correct Answer
C. CureencyExplanation
To change the appearance of the number 8000 to Rp. 8000 in Microsoft Excel, the "Currency" format is used. This format allows the user to display numbers as currency, with the appropriate currency symbol and decimal places.Rate this question:
-
- 22.
Pertemuan antara kolom dan baris pada Ms Excel disebut. ...
- A.
Row
- B.
Range
- C.
Coloumn
- D.
Cell
- E.
Marge Cell
Correct Answer
D. CellExplanation
In Microsoft Excel, the intersection point between a column and a row is called a cell. Cells are the basic units of a spreadsheet and are used to store data or formulas. They are identified by their unique combination of column and row references, such as A1 or B5. Cells can contain various types of data, including numbers, text, dates, or formulas, and they can be formatted and manipulated in different ways to perform calculations or display information.Rate this question:
-
- 23.
Untuk menghitung Jumlah Data dalam dalam suatu range di gunakan fungsi. ...
- A.
SUM
- B.
Count
- C.
Average
- D.
Max
- E.
Count IF
Correct Answer
B. CountExplanation
The correct answer is "Count". Count is used to calculate the total number of data points in a given range. It does not consider the values of the data, only the quantity.Rate this question:
-
- 24.
Jika anda ingin memperbesar sebuh jendela penuh layar, maka tombol yang akan diklik adalah. ...
- A.
Minimize
- B.
Maximize
- C.
Close
- D.
Restore Down
- E.
Exit
Correct Answer
B. MaximizeExplanation
To enlarge a window to full screen, the correct button to click is "Maximize." This button expands the window to fill the entire screen, allowing for a better viewing experience. The other options listed, such as "Minimize," "Close," "Restore Down," and "Exit," do not have the same function of maximizing the window to full screen.Rate this question:
-
- 25.
Menutup dokumen pada lembar sebar pada MS Excel 2007 dapat dilakukan dengan. ...
- A.
Klik tab Home, kemudian pilih sub menu Exit
- B.
Klik Tab Home, kemudian pilih sub menu Close
- C.
Klik Office Button, kemudian pilih sub menu Save
- D.
Klik Office Button, kemudian pilih sub menu Close
- E.
Klik Office Button, kemudian pilih sub menu Print
Correct Answer
D. Klik Office Button, kemudian pilih sub menu CloseExplanation
The correct answer is "Klik Office Button, kemudian pilih sub menu Close". In MS Excel 2007, the Office Button is located in the top left corner of the window and acts as a central hub for various functions. By clicking on the Office Button and selecting the Close option, you can effectively close the document in the spreadsheet. This is different from the Save option, which allows you to save any changes made to the document before closing it. The other options mentioned in the question, such as Exit and Print, are not relevant to closing the document.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
-
Jul 22, 2024Quiz Edited by
ProProfs Editorial Team -
Mar 31, 2014Quiz Created by
Adhie0975
Back to top