Soal Ulangan Online Smk Sari Putra Jakarta

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Adhie0975
A
Adhie0975
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,360
| Attempts: 1,360
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/25 Pertanyaan

    Software spreadsheet yang di produksi Oleh Microsoft adalah. ...

    • Microsoft Excel
    • Spreadsheet
    • Calc
    • Lotus
    • Accurate
Please wait...
Soal Ulangan Online Smk Sari Putra Jakarta - Quiz
About This Quiz

Ulangan Harian MID Semester Kelas X

Quiz Preview

  • 2. 

    Untuk membuka Microsoft Excel melalui fasilitas Run, Langkah-langkahnya adalah : Klik Star -> ........ . -> Run ðEnter atau Klik Ok.

    • Microsoft Excel

    • Ms Excel

    • MSEXCEL

    • Excel

    • M.Excel

    Correct Answer
    A. Excel
    Explanation
    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. ...

    • Sel

    • Kolom

    • Baris

    • Sheet

    • Workbook

    Correct Answer
    A. Sel
    Explanation
    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. ...

    • F1

    • F2

    • F4

    • F8

    • F12

    Correct Answer
    A. F12
    Explanation
    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. ... - ProProfs

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

    • Gambar 1

    • Gambar 2

    • Gambar 3

    • Gambar 4

    • Gambar 5

    Correct Answer
    A. Gambar 1
    Explanation
    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. ...

    • Alt + F + X

    • Alt + F + C

    • Alt + F + N

    • Ctrl + X

    • Ctrl + C

    Correct Answer
    A. Alt + F + C
    Explanation
    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. ...

    • 10

    • 11

    • 12

    • 13

    • 14

    Correct Answer
    A. 13
    Explanation
    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. ... - ProProfs

    Posisi Kata “MedalI” pada sel tergabung. Hal ini dapat terjadi setelah kita mengklik toolbar No Pada gambar di bawah ini. ...

    • No 1

    • No 2

    • No 3

    • No 4

    • No 5

    Correct Answer
    A. No 4
    Explanation
    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. ... - ProProfs

    Toolbar yang digunakan untuk membuat grafik, pada gambar di bawah ini terdapat pada No. ...

    • No. 1

    • No. 2

    • No. 4

    • No. 5

    • No. 6

    Correct Answer
    A. No. 4
    Explanation
    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. ...

    • Ctrl+X

    • Ctrl+C

    • Ctrl+A

    • Ctrl+N

    • Ctrl+S

    Correct Answer
    A. Ctrl+A
    Explanation
    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. ...

    • 1 sel di kanan Pointer

    • 1 sel di kiri Pointer

    • 1 sel di atas pointer

    • 1 sel di bawah pointer

    • 1 kolom perlayar ke atas

    Correct Answer
    A. 1 sel di atas pointer
    Explanation
    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. ...

    • Sel aktif pindah ke sel E8

    • Sel aktif pada dua tempat, yaitu di B2 dan E8

    • Terblok area sebanyak 7 sel, dari sel B2 hingga E8

    • Terblok area sebanyak 28 sel, dari sel B2 hingga E8

    • Terblok area sebanyak 4 sel, dari sel B2 hingga E8

    Correct Answer
    A. Terblok area sebanyak 28 sel, dari sel B2 hingga E8
    Explanation
    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. .... - ProProfs

    Perhatikan gambar berikut ! Kata “Lahir” tidak berada di sebelah kanan dari kata “Tanggal” karena. ....

    • Setelah menulis “tanggal” lalu Enter

    • Baris no 2 di lebarkan

    • Kolom B di persempit

    • Setelah menulis “tanggal” lalu kita tekan tombol panah ke bawah ()

    • Kita mengaktifkan Wrap text pada opsi Text Control

    Correct Answer
    A. Kita mengaktifkan Wrap text pada opsi Text Control
    Explanation
    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. ... - ProProfs

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

    • Gambar No.1

    • Gambar No.2

    • Gambar No.3

    • Gambar No.4

    • Gambar No.5

    Correct Answer
    A. 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. ... 

    • 2000

    • 2.000

    • 2000,00

    • 2.000,00

    • 2,000

    Correct Answer
    A. 2.000,00
    Explanation
    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. ...

    • Klik

    • Double clik

    • Klik kanan

    • Drag

    • Scroll

    Correct Answer
    A. Drag
    Explanation
    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. ...

    • Mengubah lebar kolom

    • Menghapus kolom

    • Mengubah tinggi baris

    • Menghapus baris

    • Menyisipkan baris

    Correct Answer
    A. Mengubah tinggi baris
    Explanation
    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. ...

    • #

    • %

    • *

    • @

    • =

    Correct Answer
    A. =
    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. ...

    • 6

    • 4

    • 8

    • 7

    • 5

    Correct Answer
    A. 6
    Explanation
    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. ...

    • 6

    • 4

    • 8

    • 5

    • 7

    Correct Answer
    A. 5
    Explanation
    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. ...

    • Genera

    • Number

    • Cureency

    • Date

    • Scientific

    Correct Answer
    A. Cureency
    Explanation
    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. ...

    • Row

    • Range

    • Coloumn

    • Cell

    • Marge Cell

    Correct Answer
    A. Cell
    Explanation
    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. ...

    • SUM

    • Count

    • Average

    • Max

    • Count IF

    Correct Answer
    A. Count
    Explanation
    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. ...

    • Minimize

    • Maximize

    • Close

    • Restore Down

    • Exit

    Correct Answer
    A. Maximize
    Explanation
    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. ...

    • Klik tab Home, kemudian pilih sub menu Exit

    • Klik Tab Home, kemudian pilih sub menu Close

    • Klik Office Button, kemudian pilih sub menu Save

    • Klik Office Button, kemudian pilih sub menu Close

    • Klik Office Button, kemudian pilih sub menu Print

    Correct Answer
    A. Klik Office Button, kemudian pilih sub menu Close
    Explanation
    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 (Updated): Jul 22, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jul 22, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 31, 2014
    Quiz Created by
    Adhie0975
Back to Top Back to top
Advertisement