# Uts Mata Kuliah Pengantar Aplikasi Komputer

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Dikdikjuanda
D
Dikdikjuanda
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,616
Pertanyaan: 40 | Attempts: 1,616

Settings

Mata Kuliah : Pengantar Aplikasi Komputer SKS : 2 (dua) Dosen : D. Juanda N, S.Pd., MM

• 1.

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

• A.

SUM

• B.

MAX

• C.

MIN

• D.

AVERAGE

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.

Rate this question:

• 2.

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

• A.

SUM

• B.

MIN

• C.

MAX

• D.

AVERAGE

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.

Rate this question:

• 3.

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

• A.

SUM

• B.

MIN

• C.

MAX

• D.

AVERAGE

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.

Rate this question:

• 4.

### Microsoft Excel merupakan salah satu program aplikasi ....

• A.

Wordprosessor

• B.

Presentation

• C.

Animation

• D.

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".

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

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.

Rate this question:

• 6.

### Fungsi yang digunakan untuk menghitung rata-rata data angka adalah ....

• A.

SUM

• B.

MIN

• C.

MAX

• D.

AVERAGE

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.

Rate this question:

• 7.

### Di bawah ini adalah fungsi logika, kecuali …

• A.

Hlookup

• B.

If

• C.

Not

• D.

And

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.

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

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.

Rate this question:

• 9.

### Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu ...

• A.

Tabel

• B.

Data

• C.

Grafik

• D.

Rumus

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.

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

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.

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

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.

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

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.

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

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.

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

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".

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

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.

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

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".

Rate this question:

• 17.

• A.

Home

• B.

Data

• C.

Format

• D.

View

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.

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

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.

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

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.

Rate this question:

• 20.

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

• A.

• B.

Toolbar

• C.

Statusbar

• D.

Formula bar

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.

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

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.

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.

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.

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

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.

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

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.

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

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.

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.

• D.

Data Sort

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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".

Rate this question:

• 35.

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

• A.

Concatenate

• B.

Vlookup

• C.

Average

• D.

And

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.

Rate this question:

• 36.

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

• A.

• B.

Tabel yang dipakai sebagai rujukan pencarian.

• C.

Menunjukkan kolom berapa yang nilainya akan diambil

• D.

Nilai logika untuk menemukan kecocokan terdekat

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

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.

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

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.

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

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.

Rate this question:

• 40.

• A.

F1

• B.

F2

• C.

F3

• D.

F4