Ujian Tengah Semester Sks : 2 Sks
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 dicetakExplanation
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 nameExplanation
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. HyperlinkExplanation
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 ValidationExplanation
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 FormulaExplanation
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. SUMExplanation
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. MAXExplanation
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. SpreadsheetExplanation
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. CountifExplanation
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 dicetakExplanation
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. F4Explanation
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 - MatchExplanation
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. F2Explanation
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 FormattingExplanation
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 ValuesExplanation
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 setsExplanation
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. COUNTAExplanation
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. AbsoluteExplanation
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. ConcatenateExplanation
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 pasteExplanation
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 dropExplanation
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 handleExplanation
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 FormulasExplanation
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. KtikExplanation
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. *.xlExplanation
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. HomeExplanation
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 boxExplanation
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 horizontalExplanation
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. ToolbarExplanation
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. MidExplanation
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, heightExplanation
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+NExplanation
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, widthExplanation
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 VistaExplanation
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. LeftExplanation
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. RightExplanation
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. HlookupExplanation
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. TabelExplanation
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. MINExplanation
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