Ujian Online Microsoft Excel 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Susiantoro2012
S
Susiantoro2012
Community Contributor
Quizzes Created: 4 | Total Attempts: 30,577
| Attempts: 11,565
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/40 Pertanyaan

    Untuk memasukkan rumus / formula diawali dengan ....

    • -
    • =
    • *
    • +
    • %
Please wait...

Quiz Preview

  • 2. 

    Fungsi statistik yang digunakan untuk mencari nilai rata-rata pada suatu range adalah …

    • MAX

    • AVERAGE

    • AUTOSUM

    • MIN

    • SUM

    Correct Answer
    A. AVERAGE
    Explanation
    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:

  • 3. 

    =LEFT(“INDONESIA”,3) menghasilkan ….

    • IND

    • DON

    • NES

    • SIA

    • NDO

    Correct Answer
    A. IND
    Explanation
    The function "=LEFT("INDONESIA",3)" in Excel extracts the first three characters from the word "INDONESIA", resulting in the output "IND".

    Rate this question:

  • 4. 

    Pada waktu memasukkan rumus atau data jika kolomnya kurang lebar, maka tampilan isi sel tersebut adalah …

    • XXXXXXXX

    • @@@@@

    • &&&&&&&

    • ########

    • !!!!!!!!!!!!!!!!!!

    Correct Answer
    A. ########
    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:

  • 5. 

    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 …

    • =MAX(B2:D2)

    • =SUM(B2:C2)

    • =COUNT(D2:C2)

    • =MIN(B2:D2)

    • =AVERAGE(B2:D2)

    Correct Answer
    A. =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:

  • 6. 

    Fungsi pembacaan table secara Horizontal disebut ...

    • LOOKUP

    • FIND

    • Searching

    • HLOOKUP

    • VLOOKUP

    Correct Answer
    A. HLOOKUP
    Explanation
    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:

  • 7. 

    Untuk membuat Grafik, perintah yang digunakan adalah …..

    • Insert Chart

    • View Chart

    • Review Chart

    • Data Sort

    • Formula

    Correct Answer
    A. Insert Chart
    Explanation
    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:

  • 8. 

    Penulisan rumus yang benar untuk menjumlahkan data yang berada pada range E5 sampai E9 adalah

    • SUM(E5:E9)

    • AVERAGE (E5:E9)

    • =SUM(E5:E9)

    • =AVERAGE(E5:E9)

    • =MAX(E5:E9)

    Correct Answer
    A. =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:

  • 9. 

    Pilihan untuk lambang Rp terdapat pada …

    • Enter

    • Insert

    • Bottom

    • Percentage

    • Currency

    Correct Answer
    A. Currency
    Explanation
    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:

  • 10. 

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

    • 57

    • 50

    • 43

    • 14

    • 64

    Correct Answer
    A. 43
    Explanation
    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:

  • 11. 

    Perpotongan antara baris dan kolom disebut ....

    • Row

    • Cell

    • Column

    • Sheet

    • Range

    Correct Answer
    A. Cell
    Explanation
    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:

  • 12. 
    Type Grafik dibawah ini adalah ... - ProProfs

    Type Grafik dibawah ini adalah ...

    • Column

    • Bar

    • Pie

    • X Y

    • Area

    Correct Answer
    A. Pie
    Explanation
    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:

  • 13. 

    Microsoft Excel adalah sebuah program aplikasi ...

    • Pengolah kata

    • Pengolah data

    • Pengolah Animasi

    • Pengolah Angka

    • Pengolah gambar

    Correct Answer
    A. Pengolah Angka
    Explanation
    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:

  • 14. 

    Jika kita salah mengetikkan data, maka untuk memperbaikinya dapat menekan tombol …

    • F2

    • F3

    • F4

    • F5

    • F6

    Correct Answer
    A. F2
    Explanation
    To correct a mistyped data, you can press the F2 key.

    Rate this question:

  • 15. 

    Sel A1 berisi 2500, sel B1 berisi 3500 dan sel C1 berisi 1500. Jika sel A5 berisi =MAX(A1:C1), maka hasilnya ….

    • 7500

    • 6000

    • 5000

    • 3500

    • 1500

    Correct Answer
    A. 3500
    Explanation
    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:

  • 16. 

    Untuk operator * disebut dengan ....

    • Divide

    • Add

    • Multiply

    • Ampersand

    • Eksponen

    Correct Answer
    A. Multiply
    Explanation
    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:

  • 17. 

    Penulisan perintah logika berikut ini yang benar adalah ...

    • =IF(A5>5)5,A1=200

    • =IF(A1>5,A1)=”LULUS”,B1=”TIDAK”

    • =IF(A1>5,”SARJANA”,”SMA”)

    • =IF(A1>5)=”LULUS”,B1=”TIDAK”

    • =IF(A1>5,A1*B1,A1…B1)

    Correct Answer
    A. =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:

  • 18. 

    =IF(Mid(Kode,2,2)=”SM”,”Semen”,… Petikan rumus di atas dibaca ….

    • Jika kode huruf kiri = SM maka Semen

    • Jika kode huruf ke-2 sebanyak 1 = SM maka Semen

    • Jika kode huruf ke-1 sebanyak 2 = SM maka Semen

    • Jika kode huruf ke-2 sebanyak 2 = SM maka Semen

    • Jika kode huruf kanan = SM maka Semen

    Correct Answer
    A. Jika kode huruf ke-2 sebanyak 2 = SM maka Semen
    Explanation
    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:

  • 19. 
    Perhatikan tabel: Hasil fungsi diatas  =VLOOKUP(B30,$B$36:$D$40,2) adalah : ... - ProProfs

    Perhatikan tabel: Hasil fungsi diatas  =VLOOKUP(B30,$B$36:$D$40,2) adalah : ...

    • C

    • D

    • Jelek

    • Baik

    • Emas

    Correct Answer
    A. Jelek
    Explanation
    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:

  • 20. 

    Untuk membuat sel absolut menggunakan tanda …

    • =

    • &

    • +

    • @

    • $

    Correct Answer
    A. $
    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:

  • 21. 

    Pada B3 tertulis (SMA UNGGULAN) dan ada fungsi =RIGHT(B3,2) maka akan memberikan hasil ....

    • SM

    • UN

    • AN

    • SA

    • MA

    Correct Answer
    A. AN
    Explanation
    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:

  • 22. 

    Fungsi logika yang digunakan untuk mencari banyaknya data pada suatu range adalah ….

    • SUM

    • MAX

    • AUTOSUM

    • COUNT

    • AVERAGE

    Correct Answer
    A. COUNT
    Explanation
    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:

  • 23. 

    Untuk menampilkan data dengan posisi di tengah beberapa kolom tertentu dilakukan dengan perintah …

    • Center

    • Justify

    • Left

    • General

    • Merger and Center

    Correct Answer
    A. Merger and Center
    Explanation
    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:

  • 24. 

    Descending adalah mengurutkan data dengan cara ….

    • Dari besar ke kecil

    • Dari kecil ke besar

    • Acak

    • Berurutan

    • Berkurang

    Correct Answer
    A. Dari besar ke kecil
    Explanation
    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:

  • 25. 

    Berikut ini fasilitas Format Cells, kecuali,...

    • Number

    • Aligment

    • Border

    • Pattern

    • Paragraph

    Correct Answer
    A. Paragraph
    Explanation
    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:

  • 26. 

    Pada sel A2 terisi 75 dan terdapat fungsi  =IF(A2<65,”C”,IF(A2<75,”B”,”A”)) maka akan memberikan hasil ….

    • C

    • A

    • B

    • A atau B

    • B atau C

    Correct Answer
    A. A
    Explanation
    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:

  • 27. 
    Gambar ikon dibawah digunakan untuk ... - ProProfs

    Gambar ikon dibawah digunakan untuk ...

    • Merubah susunan data ke bentuk semula

    • Menyusun data secara acak

    • Menyusun data secara Descending

    • Menyusun data secara Ascending

    • Mencari data secara berurutan

    Correct Answer
    A. Menyusun data secara Ascending
    Explanation
    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:

  • 28. 

    Autofilter adalah ....

    • Menggunakan data dari besar ke kecil

    • Menggunakan data dari kecil ke besar

    • Menampilkan data dengan syarat tertentu

    • Membuang data dengan syarat tertentu

    • Menduplikasi data dengan syarat tertentu

    Correct Answer
    A. Menampilkan data dengan syarat tertentu
    Explanation
    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:

  • 29. 

    Jika anda membuat formula =10+6/2*3, maka di Ms. Excel jika di kerjakan akan mendapat hasil …

    • 24

    • 22

    • 19

    • 14

    • 11

    Correct Answer
    A. 19
    Explanation
    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:

  • 30. 
    Perhatikanlah tabel data berikut ini Fungsi yang tepat untuk menghitung jumlah produksi mobil sedan selama 3 tahun terakhir pada kolom Jumlah adalah… - ProProfs

    Perhatikanlah tabel data berikut ini Fungsi yang tepat untuk menghitung jumlah produksi mobil sedan selama 3 tahun terakhir pada kolom Jumlah adalah…

    • =SUM(B3:D6)

    • =MAX(B3:D6)

    • =COUNT(B3:D3)

    • =AVERAGE(B3:D3)

    • =SUM(B3:D3)

    Correct Answer
    A. =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:

  • 31. 

    Jika A3 lebih besar dari 100, maka diberi keterangan Door Prize, selain itu akan diberi keterangan Kasihan Deh Lo, maka bentuk rumusnya adalah ….

    • =IF(A3>100,”=,”Door Prize”,”Kasihan Deh Lo”)

    • =IF(A3>=100,”Door Prize”,”Kasihan Deh Lo”)

    • =IF(A3>100,”Door Prize”,”Kasihan Deh Lo”)

    • .=IF(A3=100,”Door Prize”,”Kasihan Deh Lo”)

    • =IF(A3

    Correct Answer
    A. =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:

  • 32. 

    Jika rumus =B4*D4 di sel F5 kemudian dicopy ke sel F10, maka rumus di F10 adalah …

    • =B4*D4

    • =B11*E11

    • =C9*E11

    • =C11*E9

    • =B9*D9

    Correct Answer
    A. =B9*D9
    Explanation
    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:

  • 33. 

    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,….

    • False

    • Anjing

    • Bebek

    • Cicak

    • Kuda

    Correct Answer
    A. Kuda
    Explanation
    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:

  • 34. 

    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  …

    • 49

    • 50

    • 100

    • 200

    • 300

    Correct Answer
    A. 200
    Explanation
    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:

  • 35. 

    Untuk menghasilkan ONE dari tulisan INDONESIA, perintahnya adalah ….

    • =MID(”INDONESIA”,1,3)

    • =MID(”INDONESIA”,3,3)

    • =MID(”INDONESIA”,4,3)

    • =LEFT(”INDONESIA”,3,3)

    • =RIGHT(”INDONESIA”,4,3)

    Correct Answer
    A. =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:

  • 36. 
    Untuk membuat Grafik batang, tipe yang dipilih - ProProfs

    Untuk membuat Grafik batang, tipe yang dipilih

    • Column

    • Bar

    • Pie

    • X Y

    • Area

    Correct Answer
    A. Bar
    Explanation
    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:

  • 37. 

    Untuk mengurutkan data menggunakan menu ….

    • Insert

    • Formulas

    • Review

    • View

    • Data

    Correct Answer
    A. Data
    Explanation
    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:

  • 38. 
    Perhatikan tabel : Untuk memunculkan kata Melompong di kolom D30, maka perintahnya .... - ProProfs

    Perhatikan tabel : Untuk memunculkan kata Melompong di kolom D30, maka perintahnya ....

    • =HLOOKUP(B29,$B$30:$E$34,1)

    • =HLOOKUP(B30,$B$36:$D$40,2)

    • =VLOOKUP(B29,$B$30:$D$34,1)

    • =VLOOKUP(B30,$B$36:$D$40,2)

    • =VLOOKUP(B30,$B$36:$D$40,3)

    Correct Answer
    A. =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:

  • 39. 
    Perhatikan tabel : Untuk mengisi kolom keterangan rumus yang tepat adalah …. - ProProfs

    Perhatikan tabel : Untuk mengisi kolom keterangan rumus yang tepat adalah ….

    • =IF(C7>=70,”LULUS”,”REMIDIAL”)

    • =IF(B7

    • =IF(C7>70,”LULUS”,”REMIDIAL”)

    • =IF(B7>70,”LULUS”,”REMIDIAL”)

    • =IF(B7>=70,”LULUS”,”REMIDIAL”)

    Correct Answer
    A. =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:

  • 40. 

    =IF(B6=”J”,”JAKARTA”,….=”B”,”BANDUNG”,”SEMARANG”)) Untuk melengkapi titik-titik pada rumus di atas maka digunakan …

    • =IF(

    • IF(B6

    • B6

    • IF

    • =IF(B6

    Correct Answer
    A. =IF(B6

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 28, 2013
    Quiz Created by
    Susiantoro2012
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.