1.
Fungsi yang digunakan untuk menghitung penjumlahan data angka adalah ....
Correct Answer
A. SUM
Explanation
The correct answer is "SUM". This function is used to calculate the total sum of a set of numerical data. It adds up all the values in the data set to provide the cumulative sum.
2.
Fungsi yang digunakan untuk menghitung nilai terbesar data angka adalah ....
Correct Answer
C. MAX
Explanation
The correct answer is MAX. MAX is a function used to calculate the largest value in a set of numerical data. It returns the maximum value among the given numbers.
3.
2. 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 numerical data. It can be used to find the minimum value among a group of numbers, such as finding the lowest test score among a class of students. By using the MIN function, you can easily identify the smallest value in a dataset without having to manually search through the data.
4.
Microsoft Excel merupakan salah satu program aplikasi ....
Correct Answer
D. Spreadsheet
Explanation
Microsoft Excel is a program application that is widely used for creating and managing spreadsheets. It allows users to enter and manipulate data in a tabular format, perform calculations, create charts and graphs, and analyze data. Excel is commonly used in various industries and professions, such as finance, accounting, project management, and data analysis. It provides a range of functions and features that make it a powerful tool for organizing and analyzing data efficiently. Therefore, the correct answer is "spreadsheet".
5.
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 occurrences of a certain value or values that satisfy a particular condition.
6.
Fungsi yang digunakan untuk menghitung rata-rata data angka adalah ....
Correct Answer
D. AVERAGE
Explanation
The correct answer is AVERAGE because it is the function used to calculate the average of numerical data. The SUM function calculates the total sum of the data, the MIN function finds the smallest value, and the MAX function finds the largest value. However, in this case, we are specifically looking for the function that calculates the average.
7.
Di bawah ini adalah fungsi logika, kecuali …
Correct Answer
A. Hlookup
Explanation
The given options are all logical functions except for "hlookup". "if", "not", and "and" are all commonly used logical functions in programming and spreadsheet applications. However, "hlookup" is a specific function used in spreadsheet applications like Microsoft Excel to search for a value in the top row of a table and return a corresponding value from a specified row.
8.
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu adalah....
Correct Answer
B. Left
Explanation
The left function is used to extract a specified number of characters from the left side of a text string. It is commonly used to retrieve the leftmost characters of a string based on a given length. In this case, the left function would be the appropriate choice for extracting the left portion of the text data.
9.
Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu ...
Correct Answer
A. Tabel
Explanation
The Vlookup and Hlookup functions in Excel are used to search for a specific value in a table and retrieve the corresponding value from another column or row. These functions are commonly used for data analysis and organizing information in a structured manner. By using Vlookup and Hlookup, users can easily access and retrieve data from a table without manually searching for it. Therefore, the correct answer is "tabel" (table) as these functions are specifically designed to work with tables.
10.
Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu adalah....
Correct Answer
A. Right
Explanation
The correct answer is "right". The right function is used to extract a specific number of characters from the right side of a text string. It is commonly used when we want to retrieve the last few characters from a string or extract a specific portion of a text from the right side.
11.
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 specific 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 and data analysis tasks to manipulate and extract substrings from text data.
12.
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 in Excel. By pressing Ctrl+N, users can quickly create a new blank worksheet to start working on. This shortcut is efficient and saves time compared to manually navigating through the Excel menu to open a new worksheet.
13.
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 command "format" is used to modify its appearance. The "row" parameter specifies that the modification applies to the rows of the table. And the "height" parameter determines the height of the rows, allowing the user to adjust their size as needed.
14.
Untuk mengatur lebar kolom table menggunakan perintah....
Correct Answer
C. Format, column, width
Explanation
The correct answer is "format, column, width" because to adjust the width of a column in a table, the "format" command is used, followed by specifying the "column" and the desired "width".
15.
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 included in the Microsoft Office suite.
16.
Berikut ini ekstensi suatu file yang tidak dapat dibuka dengan Ms. excel adalah...
Correct Answer
D. *.xl
Explanation
The correct answer is "*.xl" because ".xl" is not a valid file extension for Microsoft Excel. The valid file extensions for Excel are ".xlsx", ".xlsm", and ".xls".
17.
Toolbar Format Cell pada Excel ditampilkan di menu....
Correct Answer
A. Home
Explanation
The correct answer is "Home" because the Toolbar Format Cell in Excel is displayed in the "Home" menu. This menu contains various formatting options for cells, such as changing the font style, applying borders, and adjusting the cell alignment. By selecting the "Home" menu, users can easily access and apply different formatting options to their Excel spreadsheets.
18.
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. It allows users to easily identify and navigate to specific cells in a worksheet by entering the cell reference or name directly into the name box. This feature is particularly useful when working with large spreadsheets or when needing to quickly jump to a specific cell without scrolling or searching through the entire worksheet.
19.
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 scroll through the content of a window or document. In this case, the scroll bar specifically refers to the horizontal scroll bar, which is used to move the worksheet horizontally. It allows users to navigate through the columns of a spreadsheet that may not be visible on the screen.
20.
Tombol-tombol yang digunakan untuk menjalankan sebuah perintah terletak pada ...
Correct Answer
B. Toolbar
Explanation
The correct answer is toolbar. The toolbar is a set of buttons or icons that provide quick access to commonly used commands or functions in a software application. It is usually located at the top or sides of the application window. By clicking on the buttons in the toolbar, users can easily execute commands or perform actions without having to navigate through menus or use keyboard shortcuts.
21.
Perintah yang digunakan untuk menggandakan data adalah
Correct Answer
C. Copy dan paste
Explanation
The correct answer is "copy dan paste". This is because the command "copy" allows the user to duplicate or copy selected data, while the command "paste" allows the user to insert the copied data into a new location. Therefore, using the "copy dan paste" commands together will result in the duplication of data.
22.
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 halaman akan terlihat saat dicetak, termasuk tata letak, teks, gambar, dan elemen lainnya. Hal ini memungkinkan pengguna untuk memeriksa apakah ada kesalahan atau perubahan yang perlu dilakukan sebelum mencetak dokumen.
23.
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, the correct option is "Define name". This feature allows users to assign a name to a specific cell or range of cells in order to easily refer to it in formulas or data analysis. By using the "Define name" feature, users can give a meaningful and descriptive name to a cell or range, making it easier to understand and work with the data.
24.
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 is a feature in Excel that allows users to create dropdown lists in cells. By using Data Validation, users can restrict the input in a cell to a pre-defined list of values, which can be easily selected from a dropdown menu. This helps in ensuring data accuracy and consistency in the Excel worksheet.
25.
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" button. This button allows us to view the actual formula entered in a cell instead of the calculated result. This can be helpful when we want to check or troubleshoot the formulas used in our spreadsheet. By clicking on the "Show Formula" button, the formula will be displayed in the cell, making it easier for us to review and verify the calculations.
26.
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, we use a hyperlink. A hyperlink is a clickable link that can be used to navigate to a different location within the same worksheet, a different worksheet within the same workbook, or even to an external file or website. By assigning a hyperlink to the action button, we can easily link it to the desired location or file.
27.
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 term refers to the action of clicking, holding, and moving the pointer from one position to another. It is commonly used in computer interfaces to move or rearrange items by dragging them with the mouse cursor and dropping them in a new location.
28.
Posisi pointer berbentuk "+" pada sudut kiri-bawah dari range sel, disebut ...
Correct Answer
B. Fill handle
Explanation
The correct answer is "Fill handle." The fill handle is a small square located in the bottom-right corner of a selected cell or range of cells in Microsoft Excel. It allows users to quickly fill a series of data or copy the contents of a cell to adjacent cells by dragging the handle across the desired range.
29.
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". This option is the most appropriate because it states that the Paste button is used to copy data in the form of input or formulas. This implies that when you use the Paste button, it will copy and paste the formulas from the source to the destination cells.
30.
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. The question states that the button is used to provide information about data in a cell, especially data that has specific criteria or conditions. Conditional Formatting is a feature in many spreadsheet programs that allows users to apply formatting to cells based on certain conditions or rules. This can be used to highlight cells that meet specific criteria, making it easier to analyze and interpret data.
31.
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" because it is the option that allows you to copy data only, without copying the formulas. This means that when you use the "Paste Values" option, you will paste the actual values of the cells, rather than the formulas that were used to calculate those values. This can be useful when you want to copy and paste data without changing the underlying formulas or when you want to remove the formulas and keep only the values.
32.
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 adalah tombol dalam Conditional Formatting yang digunakan untuk menampilkan data tabel dengan beragam simbol, dimana warna-warna dari simbol tersebut menunjukkan besar kecilnya nilai data. Dengan menggunakan icon sets, pengguna dapat dengan mudah melihat dan membandingkan nilai-nilai data dalam tabel berdasarkan simbol-simbol yang ditampilkan.
33.
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
The correct answer is COUNTA. COUNTA is a function used to count the number of cells that contain any type of data, regardless of whether it is a number, text, or any other character. It does not differentiate between different data types and counts all non-empty cells in a range.
34.
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 row, is called "Absolute".
35.
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 data from different columns into a single column. It is commonly used in spreadsheet programs like Microsoft Excel to merge text strings or cell values. By using the concatenate function, users can easily join multiple columns or cells and create a single string of data.
36.
=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
The term "Table Array" in the formula refers to the table that is used as a reference for the lookup. It is the range of cells that contains the data you want to search in. In the HLOOKUP function, the "Table Array" is the range of cells that contains the data in rows, and the function searches for a value in the first row of this table array. Therefore, the correct answer is "Tabel yang dipakai sebagai rujukan pencarian" which translates to "The table used as a reference for the lookup".
37.
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 answer is "Index - Match". This combination of functions is commonly used to retrieve data from a table by referencing another table. The INDEX function is used to find the value in a specific row and column of a table, while the MATCH function is used to find the position of a value in a specified range. By combining these two functions, we can locate a specific value in one table and use that information to retrieve data from another table.
38.
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 extracting 4 characters from the text in cell A1, starting from the 4th position. Since the text in cell A1 is "Praktikum", the characters "ktik" starting from the 4th position will be extracted and displayed in cell B1.
39.
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 button. This function allows you to edit the contents of a cell directly, making it easier to correct any errors or modify the formulas.
40.
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 and display the "$" symbol, you can press the F4 key.