Ujian Tengah Semester Sks : 2 Sks

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
Learn about Our Editorial Process
| Written by Didan
D
Didan
Community Contributor
Quizzes Created: 1 | Total Attempts: 478
Soalan: 40 | Attempts: 478

SettingsSettingsSettings
Ujian Tengah Semester Sks : 2 Sks - Quiz

Mata kuliah : Pengantar Aplikasi Komputer Dosen : D. Juanda Nugraha, MM


Questions and Answers
  • 1. 

    Print preview digunakan untuk

    • A. 

      Mencetak lembaran kerja

    • B. 

      Mencetak bagian lembaran kerja tertentu

    • C. 

      Melihat tampilan halaman sebelum dicetak

    • D. 

      Tidak ada jawaban benar

    Correct Answer
    C. Melihat tampilan halaman sebelum dicetak
    Explanation
    Print preview digunakan untuk melihat tampilan halaman sebelum dicetak. Dengan menggunakan fitur ini, pengguna dapat melihat bagaimana dokumen akan terlihat ketika dicetak, termasuk tata letak, teks, gambar, dan elemen lainnya. Hal ini memungkinkan pengguna untuk melakukan perubahan atau penyesuaian jika diperlukan sebelum mencetak dokumen secara final.

    Rate this question:

  • 2. 

    Untuk membuat nama dari suatu cell atau range, kita bisa menggunakan tombol....

    • A. 

      Show Formula

    • B. 

      Data Validation

    • C. 

      Define name

    • D. 

      Flash Fill

    Correct Answer
    C. Define name
    Explanation
    To create a name for a cell or range, we can use the "Define name" button. This feature allows us to assign a specific name to a cell or range of cells, making it easier to refer to them in formulas or when creating data validations. By defining a name, we can simplify our formulas and make them more understandable. This feature is particularly useful when working with large datasets or complex formulas.

    Rate this question:

  • 3. 

    Dalam membuat tombol aksi pada lembar kerja excel, untuk menghubungkan tombol aksi dengan cell, sheet, atau file tertentu yang ingin ditampilkan setelah tombol aksi tersebut diklik, kita gunakan tombol ...

    • A. 

      Pictures

    • B. 

      Pivot table

    • C. 

      Hyperlink

    • D. 

      Data Sort

    Correct Answer
    C. Hyperlink
    Explanation
    To connect an action button in an Excel worksheet with a specific cell, sheet, or file that needs to be displayed after clicking the action button, a hyperlink is used. A hyperlink allows the user to navigate to a different location within the same workbook, a different worksheet, or even to a different file or website. By setting up a hyperlink, the user can easily access the desired location or content by simply clicking the action button.

    Rate this question:

  • 4. 

    Untuk membuat tombol drop-down pada lembar kerja excel, kita bisa mengunakan tombol ...

    • A. 

      Show Formula

    • B. 

      Data Validation

    • C. 

      Define name

    • D. 

      Flash Fill

    Correct Answer
    B. Data Validation
    Explanation
    Data Validation is the correct answer because it allows us to create a drop-down list in an Excel worksheet. With data validation, we can specify a list of values that can be selected from a drop-down menu in a cell. This helps in ensuring data accuracy and consistency by limiting the options available for selection.

    Rate this question:

  • 5. 

    Untuk menampilkan rumus pada suatu cell, kita bisa mengunakan tombol ...

    • A. 

      Show Formula

    • B. 

      Data Validation

    • C. 

      Define name

    • D. 

      Flash Fill

    Correct Answer
    A. Show Formula
    Explanation
    To display the formula in a cell, we can use the "Show Formula" option. This option allows us to view the actual formula used in a cell instead of the resulting value. By selecting this option, we can easily check and verify the formulas used in our spreadsheet, which is helpful for troubleshooting and auditing purposes.

    Rate this question:

  • 6. 

    Fungsi yang digunakan untuk menghitung penjumlahan data angka adalah ....

    • A. 

      MIN

    • B. 

      SUM

    • C. 

      MAX

    • D. 

      AVERAGE

    Correct Answer
    B. SUM
    Explanation
    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 values in the range and provides the sum as the result. This function is commonly used in various mathematical calculations and data analysis tasks where the total sum of a set of numbers needs to be determined.

    Rate this question:

  • 7. 

    Fungsi yang digunakan untuk menghitung nilai terbesar data angka adalah ....

    • A. 

      SUM

    • B. 

      MAX

    • C. 

      MIN

    • D. 

      AVERAGE

    Correct Answer
    B. MAX
    Explanation
    The correct answer is MAX. The MAX function is used to calculate the largest value in a set of numerical data. It scans through the data and returns the highest value.

    Rate this question:

  • 8. 

    Microsoft Excel merupakan salah satu program aplikasi ....

    • A. 

      Wordprosessor

    • B. 

      Presentation

    • C. 

      Animation

    • D. 

      Spreadsheet

    Correct Answer
    D. Spreadsheet
    Explanation
    Microsoft Excel is a program application that is specifically designed for creating and managing spreadsheets. It allows users to input and manipulate data in a structured format, perform calculations, create charts and graphs, and analyze data. With its extensive range of functions and features, Excel is widely used in various industries and professions for tasks such as financial analysis, budgeting, project management, and data organization. Therefore, the correct answer for this question is "spreadsheet".

    Rate this question:

  • 9. 

    Fungsi yang digunakan untuk menghitung banyak data dengan kriteria tertentu dalam range tertentu adalah ....

    • A. 

      Count

    • B. 

      Acount

    • C. 

      Countif

    • D. 

      Counta

    Correct Answer
    C. Countif
    Explanation
    The correct answer is Countif because it is a function in Excel that allows you to count the number of cells within a range that meet specific criteria. It is commonly used when you want to count the number of cells that satisfy a certain condition or criteria, such as counting the number of cells with a value greater than a certain number or counting the number of cells that contain a specific text.

    Rate this question:

  • 10. 

    Print preview digunakan untuk

    • A. 

      Mencetak lembaran kerja

    • B. 

      Mencetak bagian lembaran kerja tertentu

    • C. 

      Melihat tampilan halaman sebelum dicetak

    • D. 

      Tidak ada jawaban benar

    Correct Answer
    C. Melihat tampilan halaman sebelum dicetak
    Explanation
    Print preview digunakan untuk melihat tampilan halaman sebelum dicetak. Dengan menggunakan fitur ini, pengguna dapat melihat bagaimana tampilan halaman akan terlihat saat dicetak, termasuk tata letak, teks, gambar, dan elemen lainnya. Hal ini memungkinkan pengguna untuk memeriksa dan melakukan perubahan jika diperlukan sebelum mencetak dokumen, sehingga menghindari kesalahan atau tampilan yang tidak diinginkan pada hasil cetakan.

    Rate this question:

  • 11. 

    Salah satu cara yang praktis untuk membuat Absolut suatu sel atau range rujukan (memunculkan simbol "$") pada suatu rumus, yaitu dengan menekan tombol...

    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

    • D. 

      F4

    Correct Answer
    D. F4
    Explanation
    To make a cell or range reference absolute in a formula, you can press the F4 key. This will add the dollar sign symbol ($) to the reference, indicating that it should not be adjusted when the formula is copied or filled to other cells.

    Rate this question:

  • 12. 

    Gabungan fungsi ...... dan ....... ini dapat diaplikasikan dalam membuat Struk/Billing yang mengacu pada suatu tabel data sebagai sumber. Fungsi yang tepat untuk mengisi titik-titik tersebut adalah....

    • A. 

      If - Match

    • B. 

      Match - Index

    • C. 

      Index - Match

    • D. 

      If - Index

    Correct Answer
    C. Index - Match
    Explanation
    The correct combination of functions to use in order to create a Struk/Billing that refers to a data table as a source is "Index - Match". The Index function is used to find the position of a value in a specified range, while the Match function is used to find the position of a value in a specified range and return its relative position. By combining these two functions, we can locate a specific value in a data table and retrieve the corresponding data from another column.

    Rate this question:

  • 13. 

    =HLOOKUP(Lookup_Value;Table_Array;Col_Index_Num;[Range_Lookup]). Dari rumus tersebut, yang dimaksud "Table Array" adalah...

    • A. 

      Nilai pencarian terhadap data pada kolom/baris yang sama dari tabel rujukan.

    • B. 

      Tabel yang dipakai sebagai rujukan pencarian.

    • C. 

      Menunjukkan kolom berapa yang nilainya akan diambil

    • D. 

      Nilai logika untuk menemukan kecocokan terdekat

    Correct Answer
    B. Tabel yang dipakai sebagai rujukan pencarian.
    Explanation
    In the HLOOKUP formula, the "Table Array" refers to the table that is used as a reference for the lookup. This means that the table mentioned in the "Table Array" is the one that will be searched for the lookup value. The other options mentioned in the question, such as "Nilai pencarian terhadap data pada kolom/baris yang sama dari tabel rujukan" (search value against data in the same column/row of the reference table) and "Menunjukkan kolom berapa yang nilainya akan diambil" (indicates which column the value will be taken from), do not accurately describe the meaning of "Table Array" in the HLOOKUP formula.

    Rate this question:

  • 14. 

    Untuk memperbaiki data atau rumus pada suatu cell adalah dengan cara mengklik atau menekan tombol ....

    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

    • D. 

      F4

    Correct Answer
    B. F2
    Explanation
    To fix data or formulas in a cell, you can click or press the F2 key. This key activates the edit mode in Excel, allowing you to make changes directly in the cell. By pressing F2, you can easily correct any errors or modify the content of the cell without having to navigate to the formula bar.

    Rate this question:

  • 15. 

    Tombol berfungsi untuk memberi informasi tentang data di dalam sel, terutama data-data yang memiliki kriteria khusus atau kondisi khusus, disebut tombol....

    • A. 

      Cell styles

    • B. 

      Format as table

    • C. 

      Conditional Formatting

    • D. 

      Format cell

    Correct Answer
    C. Conditional Formatting
    Explanation
    The correct answer is Conditional Formatting. Conditional Formatting allows users to apply formatting to cells based on certain criteria or conditions. This feature is useful for highlighting specific data that meets certain requirements or conditions, making it easier to analyze and interpret the data.

    Rate this question:

  • 16. 

    Tombol Paste yang berfungsi untuk menyalin data saja, termasuk data hasil perhitungan dari suatu rumus, tanpa disertai penyalinan rumusnya, disebut tombol....

    • A. 

      Paste

    • B. 

      Paste Values

    • C. 

      Paste Formulas

    • D. 

      Paste Values & Source Formatting

    Correct Answer
    B. Paste Values
    Explanation
    The correct answer is "Paste Values". This option allows you to copy only the data, including the results of calculations, without copying the formulas. This means that when you paste the copied data, it will not include any formulas, only the values themselves.

    Rate this question:

  • 17. 

    Tombol dalam Conditional Formatting yang digunakan untuk menampilkan data tabel dengan beragam simbol, dimana warna-warna dari simbol tersebut menunjukkan besar kecilnya nilai data, disebut...

    • A. 

      Data bars

    • B. 

      Hightlight cell rules

    • C. 

      Color Scale

    • D. 

      Icon sets

    Correct Answer
    D. Icon sets
    Explanation
    Icon sets digunakan dalam Conditional Formatting untuk menampilkan data tabel dengan beragam simbol. Setiap simbol memiliki warna yang berbeda untuk menunjukkan besar kecilnya nilai data.

    Rate this question:

  • 18. 

    Fungsi yang digunakan untuk menghitung banyaknya sel yang berisi data tanpa memperhatikan tipe data (angka, huruf atau karakter lain), adalah ...

    • A. 

      COUNT

    • B. 

      COUNTA

    • C. 

      COUNTIF

    • D. 

      SUMIF

    Correct Answer
    B. COUNTA
    Explanation
    COUNTA is the correct answer because it is a function that can be used to count the number of cells in a range that are not empty, regardless of the data type (numbers, letters, or other characters). It counts both text and numeric values in the range. This function is useful when you want to count the total number of cells that contain any type of data in a given range.

    Rate this question:

  • 19. 

    Istilah yang digunakan untuk menyatakan penguncian terhadap posisi kolom dan baris dari alamat suatu cell atau range yang ditandai dengan adanya tanda $ yang berada didepan Kolom dan didepan Baris, disebut ....

    • A. 

      Protect

    • B. 

      Currency

    • C. 

      Dollar

    • D. 

      Absolute

    Correct Answer
    D. Absolute
    Explanation
    The term used to indicate locking the position of a column and row in the address of a cell or range, marked by the presence of a $ sign in front of the column and in front of the row, is called "Absolute".

    Rate this question:

  • 20. 

    Fungsi yang digunakan untuk menggabungkan data antar-kolom disebut ....

    • A. 

      Concatenate

    • B. 

      Vlookup

    • C. 

      Average

    • D. 

      And

    Correct Answer
    A. Concatenate
    Explanation
    The correct answer is "Concatenate." Concatenate is a function used to combine or merge data from different columns into a single column. It is commonly used in spreadsheet software like Microsoft Excel to join text or numbers from multiple cells or columns together. This function helps in creating a unified and organized dataset by combining relevant information from different sources or columns.

    Rate this question:

  • 21. 

    Perintah yang digunakan untuk menggandakan data adalah

    • A. 

      Cut dan paste

    • B. 

      Copy dan cut

    • C. 

      Copy dan paste

    • D. 

      Select all dan copy

    Correct Answer
    C. Copy dan paste
    Explanation
    The correct answer is copy and paste. This is because the copy command allows you to duplicate selected data or files, while the paste command allows you to insert the duplicated data or files into a different location. By using the copy and paste commands, you can easily duplicate and transfer data or files within a computer system.

    Rate this question:

  • 22. 

    Proses klik, tahan dan geser pointer dari satu posisi ke posisi yang lainnya disebut ...

    • A. 

      Drag

    • B. 

      Droping drag

    • C. 

      Drop and drag

    • D. 

      Drag and drop

    Correct Answer
    D. Drag and drop
    Explanation
    The correct answer is "drag and drop." This refers to the action of clicking, holding, and moving the pointer from one position to another. It is commonly used when moving or rearranging objects or files on a computer screen.

    Rate this question:

  • 23. 

    Posisi pointer berbentuk "+" pada sudut kiri-bawah dari range sel, disebut ...

    • A. 

      Fill

    • B. 

      Fill handle

    • C. 

      Flash Fill

    • D. 

      Filling pointer

    Correct Answer
    B. Fill handle
    Explanation
    The correct answer is "Fill handle". A fill handle is a small square located in the bottom right corner of a selected cell or range of cells in Excel. It allows users to quickly fill data into adjacent cells by dragging the fill handle across the desired range. This feature is useful for automatically filling in a series of numbers, dates, or other repetitive data.

    Rate this question:

  • 24. 

    Tombol Paste yang berfungsi untuk menyalin data berupa data input maupun rumus, disebut tombol....

    • A. 

      Paste

    • B. 

      Paste Values

    • C. 

      Paste Formulas

    • D. 

      Paste Values & Source Formatting

    Correct Answer
    C. Paste Formulas
    Explanation
    The correct answer is "Paste Formulas" because this option allows the user to copy and paste not only the input data but also any formulas associated with the data. This is useful when you want to replicate a formula in multiple cells without having to manually input it each time.

    Rate this question:

  • 25. 

    Jika pada Cell A1 berisi data "Praktikum", dan pada Cell B1 diisi rumus fungsi =MID(A1;4;4), maka data yang akan muncul pada cel B1 adalah ....

    • A. 

      Prak

    • B. 

      Tikum

    • C. 

      Ktik

    • D. 

      Akti

    Correct Answer
    C. Ktik
    Explanation
    The MID function in Excel is used to extract a specific number of characters from a text string, starting at a specified position. In this case, the formula =MID(A1;4;4) is used to extract 4 characters from cell A1, starting at the 4th position. So, the data that will appear in cell B1 is "ktik".

    Rate this question:

  • 26. 

    Berikut ini ekstensi suatu file yang tidak dapat dibuka dengan Ms. excel adalah...

    • A. 

      *.xlsx

    • B. 

      *.xlsm

    • C. 

      *.xls

    • D. 

      *.xl

    Correct Answer
    D. *.xl
    Explanation
    The correct answer is "*.xl". This file extension is not compatible with Microsoft Excel. Excel can only open files with the extensions "*.xlsx", "*.xlsm", and "*.xls". The "*.xl" extension is not recognized by Excel, so it cannot be opened using this software.

    Rate this question:

  • 27. 

    Toolbar Format Cell pada Excel ditampilkan di menu....

    • A. 

      Home

    • B. 

      Data

    • C. 

      Format

    • D. 

      View

    Correct Answer
    A. Home
    Explanation
    The correct answer is "Home". The toolbar for formatting cells in Excel is displayed in the Home menu.

    Rate this question:

  • 28. 

    Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah

    • A. 

      Formula bar

    • B. 

      Status bar

    • C. 

      Name box

    • D. 

      Title bar

    Correct Answer
    C. Name box
    Explanation
    The name box in Excel displays the address of the active cell, which is the cell that is currently selected or being edited. It allows users to easily identify and reference specific cells in a worksheet. The formula bar is used to enter or edit formulas and functions, the status bar displays information about the current state of the worksheet, and the title bar shows the name of the workbook. However, only the name box specifically displays the address of the active cell.

    Rate this question:

  • 29. 

    Bagian excel yang digunakan untuk menggerakkan lembaran kerja dalam arah horizontal adalah

    • A. 

      Scroll bar vertical

    • B. 

      Scroll bar horizontal

    • C. 

      Control lembaran kerja

    • D. 

      Taks pane

    Correct Answer
    B. Scroll bar horizontal
    Explanation
    The correct answer is scroll bar horizontal. A scroll bar is a graphical control element that allows users to navigate through the content of a window or document that is too large to be displayed in its entirety. In this case, the scroll bar horizontal specifically allows the user to move the worksheet horizontally, allowing them to view different parts of the worksheet that may not fit within the visible area.

    Rate this question:

  • 30. 

    Tombol-tombol yang digunakan untuk menjalankan sebuah perintah terletak pada ...

    • A. 

      Menu bar

    • B. 

      Toolbar

    • C. 

      Statusbar

    • D. 

      Formula bar

    Correct Answer
    B. Toolbar
    Explanation
    The correct answer is toolbar. The toolbar is a graphical element that contains buttons or icons representing various commands or functions. It is typically located below the menu bar and provides quick access to frequently used commands. Users can click on the buttons or icons in the toolbar to execute a specific command without having to navigate through menus or type in commands manually.

    Rate this question:

  • 31. 

    Fungsi yang digunakan untuk mengambil bagian tengah dari data teks sebanyak karakter tertentu adalah....

    • A. 

      Right

    • B. 

      Left

    • C. 

      Mid

    • D. 

      Value

    Correct Answer
    C. Mid
    Explanation
    The correct answer is "mid". The "mid" function is used to extract a specified number of characters from the middle of a text string. It takes three arguments: the text string, the starting position, and the number of characters to extract. This function is commonly used in programming languages like Excel and VBA to manipulate and extract specific portions of text data.

    Rate this question:

  • 32. 

    Untuk mengatur tinggi baris table menggunakan perintah....

    • A. 

      Format, wide, height

    • B. 

      Format, row, height

    • C. 

      Format, coloum, autoselection

    • D. 

      Format, row, autoselection

    Correct Answer
    B. Format, row, height
    Explanation
    The correct answer is "format, row, height". This is because when formatting a table, the "row" option allows you to select the specific row that you want to modify, and the "height" option allows you to adjust the height of that selected row.

    Rate this question:

  • 33. 

    Perintah untuk membukan lembar kerja excel yang baru dengan menekan tombol....

    • A. 

      Ctrl+S

    • B. 

      Ctrl+N

    • C. 

      Ctrl+V

    • D. 

      Ctrl+A

    Correct Answer
    B. Ctrl+N
    Explanation
    The correct answer is Ctrl+N. This keyboard shortcut is commonly used to open a new worksheet or workbook in Excel. By pressing Ctrl+N, users can quickly create a blank spreadsheet without having to go through the traditional method of navigating through the File menu. This shortcut is efficient and time-saving, making it a convenient option for users who frequently need to create new Excel files.

    Rate this question:

  • 34. 

    Untuk mengatur lebar kolom table menggunakan perintah....

    • A. 

      Format, row, width

    • B. 

      Format, coloum, heigh

    • C. 

      Format, column, width

    • D. 

      Format, row, heigh

    Correct Answer
    C. Format, column, width
    Explanation
    The correct answer is "format, column, width" because when we want to adjust the width of a column in a table, we use the "format" command followed by "column" to specify the column we want to adjust, and then "width" to specify the desired width.

    Rate this question:

  • 35. 

    Berikut ini yang bukan termasuk kelompok program Microsoft office adalah....

    • A. 

      Microsoft excel

    • B. 

      Microsoft word

    • C. 

      Microsoft power point

    • D. 

      Microsoft windows Vista

    Correct Answer
    D. Microsoft windows Vista
    Explanation
    Microsoft Windows Vista is not a program in the Microsoft Office suite. It is an operating system developed by Microsoft. The other options, Microsoft Excel, Microsoft Word, and Microsoft PowerPoint, are all programs that are part of the Microsoft Office suite.

    Rate this question:

  • 36. 

    Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu adalah....

    • A. 

      Right

    • B. 

      Left

    • C. 

      Mid

    • D. 

      Value

    Correct Answer
    B. Left
    Explanation
    The correct answer is "left". The left function is used to extract a specified number of characters from the beginning (left side) of a text string. It is commonly used to extract the leftmost characters of a text, such as the first name from a full name or the first few digits of a phone number.

    Rate this question:

  • 37. 

    Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu adalah....

    • A. 

      Right

    • B. 

      Left

    • C. 

      Mid

    • D. 

      Value

    Correct Answer
    A. Right
    Explanation
    The right function is used to extract a specific number of characters from the right side of a text string. It takes two arguments: the text string and the number of characters to extract. In this case, the right function is the correct answer because it is the function that is used to extract the rightmost characters from the text data.

    Rate this question:

  • 38. 

    Di bawah ini adalah fungsi logika, kecuali

    • A. 

      Hlookup

    • B. 

      If

    • C. 

      Not

    • D. 

      And

    Correct Answer
    A. Hlookup
    Explanation
    The given options are hlookup, if, not, and. Among these options, hlookup is the only one that represents a logical function. Hlookup is used in Excel to search for a value in the top row of a table and return the corresponding value in a specified row. The other options (if, not, and) are not specific to logical operations and can be used in different contexts.

    Rate this question:

  • 39. 

    Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu ...

    • A. 

      Tabel

    • B. 

      Data

    • C. 

      Grafik

    • D. 

      Rumus

    Correct Answer
    A. Tabel
    Explanation
    The correct answer is "tabel". The Vlookup and Hlookup functions are used to read data from a table. These functions allow users to search for a specific value in a table and retrieve corresponding data from the same row (for Vlookup) or column (for Hlookup). By using these functions, users can easily extract information from a table without having to manually search for it.

    Rate this question:

  • 40. 

    Fungsi yang digunakan untuk menghitung nilai terkecil data angka adalah ....

    • A. 

      SUM

    • B. 

      MIN

    • C. 

      MAX

    • D. 

      AVERAGE

    Correct Answer
    B. MIN
    Explanation
    The correct answer is MIN. The MIN function is used to calculate the smallest value in a set of numeric data. It returns the minimum value from the given range of numbers.

    Rate this question:

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.