1.
Print preview digunakan untuk
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.
2.
Untuk membuat nama dari suatu cell atau range, kita bisa menggunakan tombol....
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.
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 ...
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.
4.
Untuk membuat tombol drop-down pada lembar kerja excel, kita bisa mengunakan tombol ...
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.
5.
Untuk menampilkan rumus pada suatu cell, kita bisa mengunakan tombol ...
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.
6.
Fungsi yang digunakan untuk menghitung penjumlahan data angka adalah ....
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.
7.
Fungsi yang digunakan untuk menghitung nilai terbesar data angka adalah ....
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.
8.
Microsoft Excel merupakan salah satu program aplikasi ....
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".
9.
Fungsi yang digunakan untuk menghitung banyak data dengan kriteria tertentu dalam range tertentu adalah ....
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.
10.
Print preview digunakan untuk
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.
11.
Salah satu cara yang praktis untuk membuat Absolut suatu sel atau range rujukan (memunculkan simbol "$") pada suatu rumus, yaitu dengan menekan tombol...
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.
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....
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.
13.
=HLOOKUP(Lookup_Value;Table_Array;Col_Index_Num;[Range_Lookup]). Dari rumus tersebut, yang dimaksud "Table Array" adalah...
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.
14.
Untuk memperbaiki data atau rumus pada suatu cell adalah dengan cara mengklik atau menekan tombol ....
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.
15.
Tombol berfungsi untuk memberi informasi tentang data di dalam sel, terutama data-data yang memiliki kriteria khusus atau kondisi khusus, disebut tombol....
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.
16.
Tombol Paste yang berfungsi untuk menyalin data saja, termasuk data hasil perhitungan dari suatu rumus, tanpa disertai penyalinan rumusnya, disebut tombol....
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.
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...
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.
18.
Fungsi yang digunakan untuk menghitung banyaknya sel yang berisi data tanpa memperhatikan tipe data (angka, huruf atau karakter lain), adalah ...
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.
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 ....
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".
20.
Fungsi yang digunakan untuk menggabungkan data antar-kolom disebut ....
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.
21.
Perintah yang digunakan untuk menggandakan data adalah
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.
22.
Proses klik, tahan dan geser pointer dari satu posisi ke posisi yang lainnya disebut ...
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.
23.
Posisi pointer berbentuk "+" pada sudut kiri-bawah dari range sel, disebut ...
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.
24.
Tombol Paste yang berfungsi untuk menyalin data berupa data input maupun rumus, disebut tombol....
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.
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 ....
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".
26.
Berikut ini ekstensi suatu file yang tidak dapat dibuka dengan Ms. excel adalah...
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.
27.
Toolbar Format Cell pada Excel ditampilkan di menu....
Correct Answer
A. Home
Explanation
The correct answer is "Home". The toolbar for formatting cells in Excel is displayed in the Home menu.
28.
Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah
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.
29.
Bagian excel yang digunakan untuk menggerakkan lembaran kerja dalam arah horizontal adalah
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.
30.
Tombol-tombol yang digunakan untuk menjalankan sebuah perintah terletak pada ...
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.
31.
Fungsi yang digunakan untuk mengambil bagian tengah dari data teks sebanyak karakter tertentu adalah....
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.
32.
Untuk mengatur tinggi baris table menggunakan perintah....
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.
33.
Perintah untuk membukan lembar kerja excel yang baru dengan menekan tombol....
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.
34.
Untuk mengatur lebar kolom table menggunakan perintah....
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.
35.
Berikut ini yang bukan termasuk kelompok program Microsoft office adalah....
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.
36.
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu adalah....
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.
37.
Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu adalah....
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.
38.
Di bawah ini adalah fungsi logika, kecuali …
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.
39.
Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu ...
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.
40.
Fungsi yang digunakan untuk menghitung nilai terkecil data angka adalah ....
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.