Ujian Online Microsoft Excel 1
PETUNJUK MENGERJAKAN 1. Jumlah soal : 40 butir, waktu : 45 menit 2. Pilihlah ( klik ) Jawaban A, B, C, D atau E yang paling Benar 3. Tulislah Nama lengkap dan E-mail Anda pada kotak yang tersedia 4. Selesai mengerjakan soal, Downloadlah Sertifikatnya , kemudian di cetak tunjukkan pada P. Susiantoro 4. Bacalah Basmallah lebih dulu sebelum mengerjakan 5. Selamat Mengerjakan
Questions and Answers
- 1.
Microsoft Excel adalah sebuah program aplikasi ...
- A.
Pengolah kata
- B.
Pengolah data
- C.
Pengolah Animasi
- D.
Pengolah Angka
- E.
Pengolah gambar
Correct Answer
D. Pengolah AngkaExplanation
The correct answer is "Pengolah Angka" because Microsoft Excel is a spreadsheet program that is primarily used for organizing, analyzing, and manipulating numerical data. It allows users to perform calculations, create charts and graphs, and store large amounts of numerical information in a structured and organized manner. Therefore, it is most commonly used as a tool for working with numbers and performing mathematical operations.Rate this question:
-
- 2.
Perpotongan antara baris dan kolom disebut ....
- A.
Row
- B.
Cell
- C.
Column
- D.
Sheet
- E.
Range
Correct Answer
B. CellExplanation
A cell is the intersection point between a row and a column in a spreadsheet or a table. It is the basic unit of data storage in a spreadsheet, where data can be entered, edited, and manipulated. Cells allow for the organization and presentation of data in a structured manner.Rate this question:
-
- 3.
Pada sel A2 terisi 75 dan terdapat fungsi =IF(A2<65,”C”,IF(A2<75,”B”,”A”)) maka akan memberikan hasil ….
- A.
C
- B.
A
- C.
B
- D.
A atau B
- E.
B atau C
Correct Answer
B. AExplanation
The correct answer is A because the function in cell A2 is an IF statement that checks if the value in A2 is less than 65. If it is, it returns "C". If not, it checks if the value is less than 75. If it is, it returns "B". If neither condition is met, it returns "A". Since the value in A2 is 75, it is not less than 65 or 75, so the function will return "A".Rate this question:
-
- 4.
Untuk operator * disebut dengan ....
- A.
Divide
- B.
Add
- C.
Multiply
- D.
Ampersand
- E.
Eksponen
Correct Answer
C. MultiplyExplanation
The correct answer is "Multiply" because the question is asking for the term used to refer to the * operator. In mathematics and programming, the * operator is commonly used to perform multiplication between two numbers. Therefore, "Multiply" is the appropriate term to describe the * operator.Rate this question:
-
- 5.
Berikut ini fasilitas Format Cells, kecuali,...
- A.
Number
- B.
Aligment
- C.
Border
- D.
Pattern
- E.
Paragraph
Correct Answer
E. ParagraphExplanation
The correct answer is "Paragraph". The other options listed (Number, Alignment, Border, Pattern) are all features or settings that can be found in the Format Cells menu. However, "Paragraph" is not a feature or setting that is typically included in the Format Cells menu. It is more commonly found in word processing programs or text editors, where it is used to adjust the formatting and layout of paragraphs of text.Rate this question:
-
- 6.
Untuk memasukkan rumus / formula diawali dengan ....
- A.
-
- B.
=
- C.
*
- D.
+
- E.
%
Correct Answer
B. =Explanation
The correct answer is "=" because in order to input a formula or equation, it needs to be preceded by the equal sign. This is a common convention in many spreadsheet programs and mathematical software, indicating that the following characters are part of a calculation rather than plain text.Rate this question:
-
- 7.
Jika anda membuat formula =10+6/2*3, maka di Ms. Excel jika di kerjakan akan mendapat hasil …
- A.
24
- B.
22
- C.
19
- D.
14
- E.
11
Correct Answer
C. 19Explanation
The given formula is =10+6/2*3. According to the order of operations in mathematics, we need to perform the division first, then the multiplication, and finally the addition. So, 6 divided by 2 equals 3, and then 3 multiplied by 3 equals 9. Finally, adding 10 to 9 gives us the result of 19.Rate this question:
-
- 8.
Fungsi statistik yang digunakan untuk mencari nilai rata-rata pada suatu range adalah …
- A.
MAX
- B.
AVERAGE
- C.
AUTOSUM
- D.
MIN
- E.
SUM
Correct Answer
B. AVERAGEExplanation
The correct answer is AVERAGE. The AVERAGE function is used in statistics to calculate the mean or average value of a range of numbers. It adds up all the values in the range and divides the sum by the number of values to find the average.Rate this question:
-
- 9.
Fungsi pembacaan table secara Horizontal disebut ...
- A.
LOOKUP
- B.
FIND
- C.
Searching
- D.
HLOOKUP
- E.
VLOOKUP
Correct Answer
D. HLOOKUPExplanation
HLOOKUP is the correct answer because it is a function used in Excel to search for a value in the top row of a table and return a corresponding value from a specified row. It stands for "Horizontal Lookup" and is commonly used when the data is organized in a horizontal format. This function is useful for retrieving data from large tables or databases where the desired value is located in a specific row.Rate this question:
-
- 10.
Jika kita salah mengetikkan data, maka untuk memperbaikinya dapat menekan tombol …
- A.
F2
- B.
F3
- C.
F4
- D.
F5
- E.
F6
Correct Answer
A. F2Explanation
To correct a mistyped data, you can press the F2 key.Rate this question:
-
- 11.
Pada waktu memasukkan rumus atau data jika kolomnya kurang lebar, maka tampilan isi sel tersebut adalah …
- A.
XXXXXXXX
- B.
@@@@@
- C.
&&&&&&&
- D.
########
- E.
!!!!!!!!!!!!!!!!!!
Correct Answer
D. ########Explanation
When entering a formula or data, if the column width is too narrow, the contents of the cell will be displayed as "########".Rate this question:
-
- 12.
Penulisan rumus yang benar untuk menjumlahkan data yang berada pada range E5 sampai E9 adalah
- A.
SUM(E5:E9)
- B.
AVERAGE (E5:E9)
- C.
=SUM(E5:E9)
- D.
=AVERAGE(E5:E9)
- E.
=MAX(E5:E9)
Correct Answer
C. =SUM(E5:E9)Explanation
The correct answer is =SUM(E5:E9) because the question asks for the correct formula to sum the data in the range E5 to E9. The SUM function in Excel is used to add up numbers in a specified range, so =SUM(E5:E9) will give the sum of the values in that range.Rate this question:
-
- 13.
Pilihan untuk lambang Rp terdapat pada …
- A.
Enter
- B.
Insert
- C.
Bottom
- D.
Percentage
- E.
Currency
Correct Answer
E. CurrencyExplanation
The correct answer is "Currency" because the symbol "Rp" is commonly used to represent the currency of Indonesia, which is the Indonesian Rupiah. Therefore, it is logical to find the symbol for the currency under the option "Currency".Rate this question:
-
- 14.
Untuk menampilkan data dengan posisi di tengah beberapa kolom tertentu dilakukan dengan perintah …
- A.
Center
- B.
Justify
- C.
Left
- D.
General
- E.
Merger and Center
Correct Answer
E. Merger and CenterExplanation
The correct answer for this question is "Merger and Center". This option suggests that to display data with a position in the middle of certain columns, the command "Merger and Center" should be used. This command combines the selected cells and centers the content within them.Rate this question:
-
- 15.
Perhatikanlah tabel data berikut ini Fungsi yang tepat untuk menghitung jumlah produksi mobil sedan selama 3 tahun terakhir pada kolom Jumlah adalah…
- A.
=SUM(B3:D6)
- B.
=MAX(B3:D6)
- C.
=COUNT(B3:D3)
- D.
=AVERAGE(B3:D3)
- E.
=SUM(B3:D3)
Correct Answer
E. =SUM(B3:D3)Explanation
The correct answer is =SUM(B3:D3). This is because the SUM function is used to calculate the total sum of the values in a range of cells. In this case, the range B3:D3 represents the production of sedan cars for the past 3 years. By using the SUM function, we can add up the values in these cells to get the total production of sedan cars for the past 3 years.Rate this question:
-
- 16.
Penulisan perintah logika berikut ini yang benar adalah ...
- A.
=IF(A5>5)5,A1=200
- B.
=IF(A1>5,A1)=”LULUS”,B1=”TIDAK”
- C.
=IF(A1>5,”SARJANA”,”SMA”)
- D.
=IF(A1>5)=”LULUS”,B1=”TIDAK”
- E.
=IF(A1>5,A1*B1,A1…B1)
Correct Answer
C. =IF(A1>5,”SARJANA”,”SMA”)Explanation
The correct answer is "=IF(A1>5,”SARJANA”,”SMA”)". This is because the IF function in Excel is used to perform a logical test and return different values based on the result of the test. In this case, the logical test is whether the value in cell A1 is greater than 5. If it is, the function will return "SARJANA", otherwise it will return "SMA". This formula is correctly written with the correct syntax and quotation marks for the text values.Rate this question:
-
- 17.
Sel A1 berisi 2500, sel B1 berisi 3500 dan sel C1 berisi 1500. Jika sel A5 berisi =MAX(A1:C1), maka hasilnya ….
- A.
7500
- B.
6000
- C.
5000
- D.
3500
- E.
1500
Correct Answer
D. 3500Explanation
The correct answer is 3500 because the formula =MAX(A1:C1) calculates the maximum value from cells A1, B1, and C1. In this case, the maximum value is 3500, which is the content of cell B1.Rate this question:
-
- 18.
=LEFT(“INDONESIA”,3) menghasilkan ….
- A.
IND
- B.
DON
- C.
NES
- D.
SIA
- E.
NDO
Correct Answer
A. INDExplanation
The function "=LEFT("INDONESIA",3)" in Excel extracts the first three characters from the word "INDONESIA", resulting in the output "IND".Rate this question:
-
- 19.
Jika rumus =B4*D4 di sel F5 kemudian dicopy ke sel F10, maka rumus di F10 adalah …
- A.
=B4*D4
- B.
=B11*E11
- C.
=C9*E11
- D.
=C11*E9
- E.
=B9*D9
Correct Answer
E. =B9*D9Explanation
The correct answer is =B9*D9 because when the formula =B4*D4 is copied from cell F5 to cell F10, the formula adjusts automatically based on the relative position of the cells. In this case, since the formula is copied down, the row numbers in the formula also change accordingly. So, when copied to F10, the formula becomes =B9*D9.Rate this question:
-
- 20.
=IF(Mid(Kode,2,2)=”SM”,”Semen”,… Petikan rumus di atas dibaca ….
- A.
Jika kode huruf kiri = SM maka Semen
- B.
Jika kode huruf ke-2 sebanyak 1 = SM maka Semen
- C.
Jika kode huruf ke-1 sebanyak 2 = SM maka Semen
- D.
Jika kode huruf ke-2 sebanyak 2 = SM maka Semen
- E.
Jika kode huruf kanan = SM maka Semen
Correct Answer
D. Jika kode huruf ke-2 sebanyak 2 = SM maka SemenExplanation
The correct answer is that if the second letter of the code appears twice and is equal to "SM", then the output will be "Semen". This means that the formula is checking if the second letter of the code is "S" and the following letter is "M". If both conditions are met, the formula will return "Semen".Rate this question:
-
- 21.
=IF(B6=”J”,”JAKARTA”,….=”B”,”BANDUNG”,”SEMARANG”)) Untuk melengkapi titik-titik pada rumus di atas maka digunakan …
- A.
=IF(
- B.
IF(B6
- C.
B6
- D.
IF
- E.
=IF(B6
Correct Answer
E. =IF(B6 -
- 22.
Perhatikan tabel: Hasil fungsi diatas =VLOOKUP(B30,$B$36:$D$40,2) adalah : ...
- A.
C
- B.
D
- C.
Jelek
- D.
Baik
- E.
Emas
Correct Answer
C. JelekExplanation
The correct answer is "Jelek" because the VLOOKUP function is used to search for a value in the first column of a range and return a corresponding value from a different column. In this case, the function is searching for the value in cell B30 within the range B36:D40. The function will return the value in the second column of the range, which is "Jelek".Rate this question:
-
- 23.
Jika A3 lebih besar dari 100, maka diberi keterangan Door Prize, selain itu akan diberi keterangan Kasihan Deh Lo, maka bentuk rumusnya adalah ….
- A.
=IF(A3>100,”=,”Door Prize”,”Kasihan Deh Lo”)
- B.
=IF(A3>=100,”Door Prize”,”Kasihan Deh Lo”)
- C.
=IF(A3>100,”Door Prize”,”Kasihan Deh Lo”)
- D.
.=IF(A3=100,”Door Prize”,”Kasihan Deh Lo”)
- E.
=IF(A3
Correct Answer
C. =IF(A3>100,”Door Prize”,”Kasihan Deh Lo”)Explanation
The correct answer is =IF(A3>100,”Door Prize”,”Kasihan Deh Lo”). This formula is using the IF function in Excel to check if the value in cell A3 is greater than 100. If it is, it will display "Door Prize", otherwise it will display "Kasihan Deh Lo".Rate this question:
-
- 24.
Fungsi logika yang digunakan untuk mencari banyaknya data pada suatu range adalah ….
- A.
SUM
- B.
MAX
- C.
AUTOSUM
- D.
COUNT
- E.
AVERAGE
Correct Answer
D. COUNTExplanation
The correct answer is COUNT. COUNT is a logical function used to find the number of data within a specified range. It counts the number of cells in a range that contain numbers or values. This function is commonly used in data analysis and reporting to determine the total count of specific data points or to calculate frequencies.Rate this question:
-
- 25.
Perhatikan hal berikut ini. Di sel B2 berisi 57, di sel C2 berisi 43, dan sel D2 berisi 50. Untuk mencari rata-rata pada sel-sel di atas adalah …
- A.
=MAX(B2:D2)
- B.
=SUM(B2:C2)
- C.
=COUNT(D2:C2)
- D.
=MIN(B2:D2)
- E.
=AVERAGE(B2:D2)
Correct Answer
E. =AVERAGE(B2:D2)Explanation
The correct answer is =AVERAGE(B2:D2) because the AVERAGE function calculates the average of the values in the range B2 to D2, which are 57, 43, and 50.Rate this question:
-
- 26.
Perhatikan hal berikut ini. Di sel B2 berisi 57, di sel C2 berisi 43, dan sel D2 berisi 50. Jika kita menulis =MIN(B2:D3) hasilnya adalah ...
- A.
57
- B.
50
- C.
43
- D.
14
- E.
64
Correct Answer
C. 43Explanation
The correct answer is 43 because the MIN function is used to find the smallest value in a range of cells. In this case, the range is from cell B2 to cell D2. The smallest value in this range is 43, so that is the result of the MIN function.Rate this question:
-
- 27.
Perhatikan tabel : Untuk mengisi kolom keterangan rumus yang tepat adalah ….
- A.
=IF(C7>=70,”LULUS”,”REMIDIAL”)
- B.
=IF(B7
- C.
=IF(C7>70,”LULUS”,”REMIDIAL”)
- D.
=IF(B7>70,”LULUS”,”REMIDIAL”)
- E.
=IF(B7>=70,”LULUS”,”REMIDIAL”)
Correct Answer
E. =IF(B7>=70,”LULUS”,”REMIDIAL”)Explanation
The correct answer is "=IF(B7>=70,"LULUS","REMIDIAL")" because it uses the logical function IF to determine whether the value in cell B7 is greater than or equal to 70. If it is, the formula will return "LULUS", indicating that the student has passed. If it is not, the formula will return "REMIDIAL", indicating that the student needs to take remedial action.Rate this question:
-
- 28.
Jika pada sel C1 berisi formula =IF(AND(A1>50,A2<100),100,200). Sel A1 berisi nilai 49 dan sel A2 berisi nilaI 102, maka sel C1 berisi nilai …
- A.
49
- B.
50
- C.
100
- D.
200
- E.
300
Correct Answer
D. 200Explanation
The formula in cell C1 checks two conditions: if the value in cell A1 is greater than 50 and if the value in cell A2 is less than 100. In this case, the value in cell A1 is 49 and the value in cell A2 is 102, so both conditions are not met. Therefore, the formula will return the value 200, as specified in the formula.Rate this question:
-
- 29.
Pada suatu sel terdapat pernyataan =IF(B3=”A”,”Anjing”,IF(B3=”B”,”Bebek”,IF(B3=”C”,”Cicak”,”Kuda”))) jika pada B3 terdapat huruf “E” maka hasil yang muncul adalah,….
- A.
False
- B.
Anjing
- C.
Bebek
- D.
Cicak
- E.
Kuda
Correct Answer
E. KudaExplanation
The correct answer is "Kuda" because the given formula is an IF statement that checks the value in cell B3. If B3 is equal to "A", the result is "Anjing". If B3 is equal to "B", the result is "Bebek". If B3 is equal to "C", the result is "Cicak". If none of these conditions are met, the result is "Kuda". Since B3 contains the letter "E", which does not match any of the conditions, the result is "Kuda".Rate this question:
-
- 30.
Untuk membuat sel absolut menggunakan tanda …
- A.
=
- B.
&
- C.
+
- D.
@
- E.
$
Correct Answer
E. $Explanation
To create an absolute cell reference in a formula, the dollar sign ($) symbol is used. This symbol is placed in front of both the column letter and row number of the cell reference. By using the dollar sign, the cell reference will not change when the formula is copied or filled to other cells. Therefore, the correct answer is $ as it is the symbol used to create an absolute cell reference.Rate this question:
-
- 31.
Untuk menghasilkan ONE dari tulisan INDONESIA, perintahnya adalah ….
- A.
=MID(”INDONESIA”,1,3)
- B.
=MID(”INDONESIA”,3,3)
- C.
=MID(”INDONESIA”,4,3)
- D.
=LEFT(”INDONESIA”,3,3)
- E.
=RIGHT(”INDONESIA”,4,3)
Correct Answer
C. =MID(”INDONESIA”,4,3)Explanation
The correct answer is =MID("INDONESIA",4,3). This is because the MID function is used to extract a specific number of characters from a text string, starting from a specified position. In this case, the function will start at the 4th position of the word "INDONESIA" and extract 3 characters, resulting in the word "ONE".Rate this question:
-
- 32.
Pada B3 tertulis (SMA UNGGULAN) dan ada fungsi =RIGHT(B3,2) maka akan memberikan hasil ....
- A.
SM
- B.
UN
- C.
AN
- D.
SA
- E.
MA
Correct Answer
C. ANExplanation
The correct answer is "AN" because the =RIGHT(B3,2) function extracts the last two characters from the text in cell B3, which is "AN" in this case.Rate this question:
-
- 33.
Perhatikan tabel : Untuk memunculkan kata Melompong di kolom D30, maka perintahnya ....
- A.
=HLOOKUP(B29,$B$30:$E$34,1)
- B.
=HLOOKUP(B30,$B$36:$D$40,2)
- C.
=VLOOKUP(B29,$B$30:$D$34,1)
- D.
=VLOOKUP(B30,$B$36:$D$40,2)
- E.
=VLOOKUP(B30,$B$36:$D$40,3)
Correct Answer
E. =VLOOKUP(B30,$B$36:$D$40,3)Explanation
The correct answer is =VLOOKUP(B30,$B$36:$D$40,3). This is because the VLOOKUP function is used to search for a value in the first column of a range and return a corresponding value in a specified column. In this case, we want to search for the value in cell B30 and find the corresponding value in the third column of the range $B$36:$D$40, which is "Melompong".Rate this question:
-
- 34.
Untuk mengurutkan data menggunakan menu ….
- A.
Insert
- B.
Formulas
- C.
Review
- D.
View
- E.
Data
Correct Answer
E. DataExplanation
The correct answer is "Data" because to sort data, we need to access the data itself. The "Data" menu typically contains options such as sorting, filtering, and organizing data in a spreadsheet or database. Therefore, selecting the "Data" menu is the appropriate choice for sorting data.Rate this question:
-
- 35.
Descending adalah mengurutkan data dengan cara ….
- A.
Dari besar ke kecil
- B.
Dari kecil ke besar
- C.
Acak
- D.
Berurutan
- E.
Berkurang
Correct Answer
A. Dari besar ke kecilExplanation
The correct answer is "Dari besar ke kecil" which means "From large to small" in English. This means that when arranging or sorting data in descending order, the largest values will be placed first, followed by the smaller values.Rate this question:
-
- 36.
Gambar ikon dibawah digunakan untuk ...
- A.
Merubah susunan data ke bentuk semula
- B.
Menyusun data secara acak
- C.
Menyusun data secara Descending
- D.
Menyusun data secara Ascending
- E.
Mencari data secara berurutan
Correct Answer
D. Menyusun data secara AscendingExplanation
The given correct answer suggests that the icon is used to arrange data in ascending order. This means that the icon can be used to organize data in a way that starts with the lowest value and goes up to the highest value. It is a way to sort data in increasing order.Rate this question:
-
- 37.
Autofilter adalah ....
- A.
Menggunakan data dari besar ke kecil
- B.
Menggunakan data dari kecil ke besar
- C.
Menampilkan data dengan syarat tertentu
- D.
Membuang data dengan syarat tertentu
- E.
Menduplikasi data dengan syarat tertentu
Correct Answer
C. Menampilkan data dengan syarat tertentuExplanation
Autofilter adalah fitur yang digunakan untuk menampilkan data dengan syarat tertentu. Dengan menggunakan autofilter, pengguna dapat memfilter atau menyaring data berdasarkan kriteria tertentu, seperti nilai tertentu, teks tertentu, atau rentang tanggal tertentu. Autofilter memungkinkan pengguna untuk melihat hanya data yang relevan atau yang memenuhi kriteria yang ditentukan, sehingga memudahkan analisis dan pemrosesan data.Rate this question:
-
- 38.
Untuk membuat Grafik, perintah yang digunakan adalah …..
- A.
Insert Chart
- B.
View Chart
- C.
Review Chart
- D.
Data Sort
- E.
Formula
Correct Answer
A. Insert ChartExplanation
The correct answer is "Insert Chart" because to create a graph or chart, the command or option used is usually "Insert Chart." This command allows the user to select the desired chart type and input the data to be represented graphically. The other options listed, such as "View Chart," "Review Chart," "Data Sort," and "Formula," are not directly related to creating a chart.Rate this question:
-
- 39.
Untuk membuat Grafik batang, tipe yang dipilih
- A.
Column
- B.
Bar
- C.
Pie
- D.
X Y
- E.
Area
Correct Answer
B. BarExplanation
The correct answer is "Bar" because a bar chart is commonly used to compare different categories or groups. It uses rectangular bars of equal width to represent the data and the length of each bar corresponds to the value of the data. This type of chart is effective in visually displaying comparisons between different categories or groups.Rate this question:
-
- 40.
Type Grafik dibawah ini adalah ...
- A.
Column
- B.
Bar
- C.
Pie
- D.
X Y
- E.
Area
Correct Answer
C. PieExplanation
The given correct answer is "Pie". This suggests that the type of graph shown in the diagram is a pie chart. A pie chart is a circular statistical graphic that is divided into slices to represent numerical proportions. Each slice of the pie chart represents a different category or data point, and the size of each slice corresponds to the proportion of the whole.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 28, 2013Quiz Created by
Susiantoro2012
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