Excel Adalah

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 Iptek99
I
Iptek99
Community Contributor
Quizzes Created: 1 | Total Attempts: 287
| Attempts: 287
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/20 Questions
             Simbol disamping merupakan simbol dari perangkat lunak lembar sebar ......                             - ProProfs

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

    • Microsoft Excel
    • Open Office Calc
    • Open Office Lembar Sebar
    • Microsoft Access
    • Microsoft Word
Please wait...
Excel Adalah - Quiz
About This Quiz

Quis ini digunakan untuk perbaikan nilai ( Remedial ) bagi siswa tingkat I atau kelas X SMK DRIEWANTI BEKASI

Quiz Preview

  • 2. 

    Program ( Sistem Operasi ) yang dibutuhkan untuk mengoperasikan program Excel adalah ....

    • Windows

    • Disk Operating System

    • Power Point

    • Access

    • Linux

    Correct Answer
    A. Windows
    Explanation
    The correct answer is Windows because it is the operating system that is commonly used to operate programs like Excel. Windows provides a user-friendly interface and a wide range of features and tools that make it suitable for running various applications, including Microsoft Excel.

    Rate this question:

  • 3. 

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

    • Ctrl + N

    • Ctrl + S

    • Ctrl + O

    • Ctrl + P

    • Ctrl + V

    Correct Answer
    A. Ctrl + N
    Explanation
    To quickly create a new worksheet, you can use the shortcut Ctrl + N. This combination of keys opens a new blank document or worksheet in various software applications, including Microsoft Excel, Word, and PowerPoint. It is a commonly used shortcut that allows users to save time and start working on a new project without having to go through the menu options to create a new document.

    Rate this question:

  • 4. 

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

    • Percentage

    • Time

    • Date

    • Number

    • Accounting

    Correct Answer
    A. Accounting
    Explanation
    The correct answer is Accounting. When selecting the "Format - Cell - Number" option in the dialog box, choosing the Accounting tab allows you to add the symbol Rp. to the worksheet, indicating the value as currency in Indonesian Rupiah.

    Rate this question:

  • 5. 

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

    • Matematika

    • Statistika

    • Finansial

    • String

    • Pembacaan tabel data

    Correct Answer
    A. Matematika
    Explanation
    The given question is asking for the category or type of functions that include multiplication, division, subtraction, and exponentiation. The correct answer is "Matematika" because these operations are fundamental mathematical functions that are commonly used in arithmetic and algebraic calculations.

    Rate this question:

  • 6. 
    Simbol disamping disebut dengan ............ - ProProfs

    Simbol disamping disebut dengan ............

    • Tombol Maximize

    • Tombol Minimize

    • Tombol Restore

    • Tombol Close

    • Tombol Close Windows

    Correct Answer
    A. Tombol Minimize
    Explanation
    The symbol mentioned next to it is called the "Tombol Minimize."

    Rate this question:

  • 7. 
    Gambar diatas dalam lembar sebar disebut ........ - ProProfs

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

    • Menu Bar

    • Title Bar

    • Toolbar

    • Cell Pointer

    • Scroll Bar

    Correct Answer
    A. Menu Bar
    Explanation
    The correct answer is Menu Bar. The given image is referring to the bar at the top of the screen that contains various menus, such as File, Edit, View, etc. This bar is commonly known as the Menu Bar, and it provides access to different functions and options within a software or application.

    Rate this question:

  • 8. 

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

    • 10 x 5

    • A1 * B1

    • = 10 x 5

    • = 10 * 5

    • = A1 * B1

    Correct Answer
    A. = A1 * B1
    Explanation
    The correct answer is "= A1 * B1" because the formula for multiplying the data in cells A1 and B1 is represented by the asterisk (*) symbol in Excel. The equal sign (=) at the beginning of the formula is used to indicate that it is a formula and not a regular text. Therefore, "= A1 * B1" is the correct way to write the formula for multiplying the values in cells A1 and B1.

    Rate this question:

  • 9. 

    Untuk menampilkan seluruh data pada Autofilter digunakan pilihan .....

    • Show All

    • General

    • Total Show

    • All Filter

    • Automatic

    Correct Answer
    A. Show All
    Explanation
    The correct answer is "Show All". This option is used to display all the data in the Autofilter. It allows the user to view the entire dataset without any filtering applied.

    Rate this question:

  • 10. 

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

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

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

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

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

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

    Correct Answer
    A. =IF(A1>5,"Sarjana","DO")
    Explanation
    The correct answer is =IF(A1>5,"Sarjana","DO"). This formula is written in the correct syntax for an IF statement 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:

  • 11. 

    Sewaktu akan mengurutkan data, " Header row " dipilih apabila ........

    • Baris paling atas dalam range merupakan judul pengurutan.

    • Data yang diurutkan merupakan data angka.

    • Range yang dipilih merupakan sebagian data yang diurutkan.

    • Data yang paling kiri merupakan judul kolom yang akan diurutkan.

    • Data yang akan dirutkan tidak perlu di range.

    Correct Answer
    A. Baris paling atas dalam range merupakan judul pengurutan.
    Explanation
    The "Header row" is selected when sorting data because it represents the title of the sorting. This means that the first row in the range is considered as the header row and contains the titles or labels for the data being sorted. By selecting the header row, the sorting algorithm understands that it should not include this row in the sorting process and only sort the actual data rows.

    Rate this question:

  • 12. 

    Menjalankan perangkat lunak lembar sebar di sistem operasi windows dengan cara mengklik Start pilih program kemudian pilih .......

    • Microsoft Excel

    • Open Office Calc

    • Open Office Lembar Sebar

    • Microsoft Access

    • Microsoft Word

    Correct Answer
    A. Microsoft Excel
    Explanation
    To run spreadsheet software on a Windows operating system, you would typically click on the Start button, then select a program. In this case, the correct answer is Microsoft Excel.

    Rate this question:

  • 13. 

    Jumlah lembar kerja dalam buku kerja terdiri dari ........

    • 256 Kolom dan 65536 Baris

    • 256 kolom dan 65789 Baris

    • 65536 Kolom dan 256 Baris

    • 67890 Baris + 345 Kolom

    • 345 Kolom dan 65545 Baris

    Correct Answer
    A. 256 Kolom dan 65536 Baris
    Explanation
    The correct answer is 256 Kolom dan 65536 Baris. This answer states that the number of columns in the workbook is 256, and the number of rows is 65536.

    Rate this question:

  • 14. 

    Garis-garis yang terdapat didalam area grafik bernama ..........

    • Category ( X ) axis

    • Value ( Y ) axis

    • Gridlines

    • Legend

    • Data Label

    Correct Answer
    A. Gridlines
    Explanation
    Gridlines are the lines that appear on a graph, which help in reading and interpreting the values accurately. They are used to visually represent the scale and divisions on both the X and Y axes, making it easier to understand the data plotted on the graph.

    Rate this question:

  • 15. 

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

    • Format, Cells, Protection, Ok

    • Tools, Options, Gridlines, Ok

    • Format, Cells, Borders,Ok

    • Format, Cells, Font, Ok

    • Format, Cells, Patterns, Ok

    Correct Answer
    A. Tools, Options, Gridlines, Ok
    Explanation
    The correct answer is "Tools, Options, Gridlines, Ok". This option suggests that in order to hide or display gridlines (column and row boundaries) on the screen, the user needs to go to the "Tools" menu, then select "Options", and finally choose "Gridlines". By clicking "Ok", the changes will be applied.

    Rate this question:

  • 16. 

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

    • Meninggikan baris

    • Melebarkan baris

    • Meninggikan kolom

    • Melebarkan kolom

    • Tidak ada pengaruh

    Correct Answer
    A. Meninggikan baris
    Explanation
    By clicking on the Format - Row - Height menu, you can increase the height of the rows in a document or spreadsheet. This option allows you to adjust the vertical size of the rows, making them taller.

    Rate this question:

  • 17. 

    Perintah untuk mengakhiri pemakaian program Excel adalah ..............

    • Restore

    • Close

    • Exit

    • Minimize

    • Start, Shutdown, Yes

    Correct Answer
    A. Exit
    Explanation
    The correct answer is "Exit". This is because "Exit" is the command used to end or terminate the usage of a program, including Excel. It is commonly used to close the program and any associated files or processes. The other options provided, such as "Restore", "Close", "Minimize", and "Start, Shutdown, Yes" are not specific commands to end the program, but rather actions related to manipulating the program window or system shutdown.

    Rate this question:

  • 18. 

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

    • Open

    • Toolbar Standard

    • Charter

    • Cut

    • Chart Wizard

    Correct Answer
    A. Chart Wizard
    Explanation
    The correct answer is "Chart Wizard" because the Chart Wizard is a tool used for creating graphs and charts. It provides a step-by-step guide to help users select the data they want to visualize and choose the appropriate chart type. The Chart Wizard is commonly found in spreadsheet software such as Microsoft Excel and Google Sheets, and it helps users create visually appealing and informative charts for data analysis and presentation purposes.

    Rate this question:

  • 19. 

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

    • File - Exit

    • File - Close

    • File - Print

    • File - Open

    • File - New

    Correct Answer
    A. File - Close
    Explanation
    The correct answer is "File - Close" because to close a spreadsheet, we use the "Close" command under the "File" menu. This command allows us to close the current spreadsheet without exiting the entire application.

    Rate this question:

  • 20. 

    Menjalankan perangkat lunak lembar sebar di sistem operasi Linux dengan cara mengklik Main menu pilih Open Office. org kemudian pilih ..........

    • Microsoft Excel

    • Open Oficce Calc

    • Open Office Lembar sebar

    • Microsoft Access

    • Microsoft Word

    Correct Answer
    A. Open Oficce Calc
    Explanation
    To run spreadsheet software on the Linux operating system, you would typically click on the Main menu and select Open Office.org. From there, you would choose Open Office Calc, which is the correct answer. Microsoft Excel, Microsoft Access, and Microsoft Word are not applicable options as they are software programs designed for the Microsoft Windows operating system.

    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
  • Jan 06, 2010
    Quiz Created by
    Iptek99
Back to Top Back to top
Advertisement