Uts Mata Kuliah Pengantar Aplikasi Komputer
Mata Kuliah : Pengantar Aplikasi Komputer SKS : 2 (dua) Dosen : D. Juanda N, S.Pd., MM
Questions and Answers
- 1.
Fungsi yang digunakan untuk menghitung penjumlahan data angka adalah ....
- A.
SUM
- B.
MAX
- C.
MIN
- D.
AVERAGE
Correct Answer
A. SUMExplanation
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.Rate this question:
-
- 2.
Fungsi yang digunakan untuk menghitung nilai terbesar data angka adalah ....
- A.
SUM
- B.
MIN
- C.
MAX
- D.
AVERAGE
Correct Answer
C. MAXExplanation
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.Rate this question:
-
- 3.
2. 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 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.Rate this question:
-
- 4.
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 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".Rate this question:
-
- 5.
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 occurrences of a certain value or values that satisfy a particular condition.Rate this question:
-
- 6.
Fungsi yang digunakan untuk menghitung rata-rata data angka adalah ....
- A.
SUM
- B.
MIN
- C.
MAX
- D.
AVERAGE
Correct Answer
D. AVERAGEExplanation
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.Rate this question:
-
- 7.
Di bawah ini adalah fungsi logika, kecuali …
- A.
Hlookup
- B.
If
- C.
Not
- D.
And
Correct Answer
A. HlookupExplanation
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.Rate this question:
-
- 8.
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 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.Rate this question:
-
- 9.
Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu ...
- A.
Tabel
- B.
Data
- C.
Grafik
- D.
Rumus
Correct Answer
A. TabelExplanation
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.Rate this question:
-
- 10.
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 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.Rate this question:
-
- 11.
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 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.Rate this question:
-
- 12.
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 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.Rate this question:
-
- 13.
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 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.Rate this question:
-
- 14.
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 to adjust the width of a column in a table, the "format" command is used, followed by specifying the "column" and the desired "width".Rate this question:
-
- 15.
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 included in the Microsoft Office suite.Rate this question:
-
- 16.
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" because ".xl" is not a valid file extension for Microsoft Excel. The valid file extensions for Excel are ".xlsx", ".xlsm", and ".xls".Rate this question:
-
- 17.
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" 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.Rate this question:
-
- 18.
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. 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.Rate this question:
-
- 19.
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 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.Rate this question:
-
- 20.
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 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.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 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.Rate this question:
-
- 22.
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 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.Rate this question:
-
- 23.
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, 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.Rate this question:
-
- 24.
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 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.Rate this question:
-
- 25.
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" 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.Rate this question:
-
- 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 ...
- 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, 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.Rate this question:
-
- 27.
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 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.Rate this question:
-
- 28.
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." 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.Rate this question:
-
- 29.
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". 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.Rate this question:
-
- 30.
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. 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.Rate this question:
-
- 31.
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" 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.Rate this question:
-
- 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...
- A.
Data bars
- B.
Hightlight cell rules
- C.
Color Scale
- D.
Icon sets
Correct Answer
D. Icon setsExplanation
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.Rate this question:
-
- 33.
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
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.Rate this question:
-
- 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 ....
- 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 row, is called "Absolute".Rate this question:
-
- 35.
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 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.Rate this question:
-
- 36.
=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
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".Rate this question:
-
- 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....
- A.
If - Match
- B.
Match - Index
- C.
Index - Match
- D.
If - Index
Correct Answer
C. Index - MatchExplanation
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.Rate this question:
-
- 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 ....
- 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 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.Rate this question:
-
- 39.
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 button. This function allows you to edit the contents of a cell directly, making it easier to correct any errors or modify the formulas.Rate this question:
-
- 40.
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 and display the "$" symbol, you can press the F4 key.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 14, 2014Quiz Created by
Dikdikjuanda
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Back to top