My Microsoft Excel 2007

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 Smpn26
S
Smpn26
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,281
| Attempts: 1,281
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/50 Questions

    Karakter yang digunakan untuk menandai sel Absolut/Semi absolut adalah : 

    • $
    • ^
    • *
    • #
    • !
Please wait...
My Microsoft Excel 2007 - Quiz

Quiz Preview

  • 2. 

    Untuk memisahkan angka ribuan, digunakan langkah-langkah : 

    • Centang use 1000 separator (,)

    • Ubah Decimal Places menjadi 3

    • Centang Wrap Text

    • Pada Text Direction pilih Context

    • Klik Merge Cels

    Correct Answer
    A. Centang use 1000 separator (,)
    Explanation
    The correct answer is "Centang use 1000 separator (,)". This means that to separate thousands, the option of using a comma (,) as a separator should be checked.

    Rate this question:

  • 3. 

    Mengambil sejumlah data karakter yg telah ditentukan mulai dari tengah dalam suatu cells adalah merupakan salah satu fungsi text berikut …

    • MID

    • LEFT

    • RiIGHT

    • RIGHT

    • LEVT

    Correct Answer
    A. MID
    Explanation
    The correct answer is MID. 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 is used to extract a certain number of characters from the middle of a cell's data.

    Rate this question:

  • 4. 

    Terdapat fungsi =if(D4<=55,”Koplak”,”Tidak Koplak”). Apabila D4 bernilai 55, maka output yang dihasilkan adalah : 

    • Lulus

    • Tidak Lulus

    • Koplak

    • Tidak Koplak

    • Bingung

    Correct Answer
    A. Koplak
    Explanation
    The given formula is an IF function that checks if the value in cell D4 is less than or equal to 55. If it is true, the output will be "Koplak". Since the value in D4 is 55, which is equal to 55, the condition is true and the output will be "Koplak".

    Rate this question:

  • 5. 

    Salah satu peripheral input Device adalah 

    • Printer

    • Monitor

    • Mouse

    • LCD Proyektor

    • Speaker

    Correct Answer
    A. Mouse
    Explanation
    A mouse is considered a peripheral input device because it allows users to interact with a computer by moving a cursor on the screen and selecting or clicking on items. It is an external device that connects to the computer and provides input by detecting the movement and clicks of the user's hand. This input is then transmitted to the computer, allowing the user to control and navigate through various applications and programs.

    Rate this question:

  • 6. 

    Fungsi yang digunakan untuk menentukan berapa banyak data yang terdapat dalam range adalah :

    • Count

    • Max

    • Min

    • Sum

    • Average

    Correct Answer
    A. Count
    Explanation
    The function "Count" is used to determine the number of data points within a given range. It calculates the total count of values present in the range, regardless of their specific values or order. This function is particularly useful for analyzing data sets and determining the size or magnitude of a particular range.

    Rate this question:

  • 7. 

    Mengambil sejumlah data karakter yg telah ditentukan mulai dari Kiri dalam suatu cells adalah merupakan salah satu fungsi text berikut …

    • MID

    • LEFT

    • RIGHT

    • LEVT

    • RIHGT

    Correct Answer
    A. LEFT
    Explanation
    The correct answer is "LEFT". The LEFT function is used to extract a specified number of characters from the left side of a text string. In this case, it is used to extract a certain number of characters from the left side of a cell.

    Rate this question:

  • 8. 

    Versi terbaru dari microsoft office saat ini adalah : 

    • Microsoft Office 2014

    • Microsoft Office 2007

    • Microsoft Office 2013

    • Microsoft Office 2010

    • Microsoft Office 2011

    Correct Answer
    A. Microsoft Office 2013
    Explanation
    The correct answer is "Microsoft Office 2013" because it is stated in the given options that it is the latest version of Microsoft Office.

    Rate this question:

  • 9. 

                Berikut ini yang termasuk program aplikasi untuk melakukan pekerjaan perhitungan dan laporan keuangan adalah                  

    • Microsoft Word, Microsoft Excel

    • Lotus 123, Microsoft Power Point

    • Microsoft Power Point, Microsoft Word

    • Microsoft Excel, Lotus 123

    • Microsoft Excel, Microsoft Power Point

    Correct Answer
    A. Microsoft Excel, Lotus 123
    Explanation
    The correct answer is Microsoft Excel, Lotus 123. Microsoft Excel and Lotus 123 are both spreadsheet programs that are commonly used for calculations and financial reporting. These programs allow users to input and manipulate data, perform calculations, create charts and graphs, and generate reports. They are widely used in business and finance for tasks such as budgeting, financial analysis, and forecasting.

    Rate this question:

  • 10. 

    Yang bukan merupakan operator Relasi adalah :

    • =

    • >

    • >=

    • >>

    Correct Answer
    A. >>
    Explanation
    The given options consist of various relational operators, such as equal to (=), greater than (>), and greater than or equal to (>=). However, the ">>" operator is not a valid relational operator. It is actually the right shift operator used in programming languages for shifting the bits of a number to the right. Therefore, the correct answer is ">>" as it is not a relational operator.

    Rate this question:

  • 11. 
    Rumus  Upah Kerja = Jam Kerja * 4500 adalah - ProProfs

    Rumus  Upah Kerja = Jam Kerja * 4500 adalah

    • =B6*4500

    • B6*4500

    • =B7*4500

    • =B8*4500

    • =B9*4500

    Correct Answer
    A. =B6*4500
    Explanation
    The given equation is an example of a formula to calculate the wage for a certain amount of work hours. The formula multiplies the number of work hours (in cell B6) by the wage rate of 4500. This will give the total wage for the given number of work hours.

    Rate this question:

  • 12. 
    Rumus Upah Lembur = Jam Lembur * 2000 adalah - ProProfs

    Rumus Upah Lembur = Jam Lembur * 2000 adalah

    • =C6*2000

    • C6*2000

    • =C7*2000

    • =C7*2000

    • =C9*2000

    Correct Answer
    A. =C6*2000
    Explanation
    The given formula calculates the overtime pay by multiplying the number of overtime hours (cell C6) with the rate of 2000. This formula assumes that the rate for overtime pay is fixed at 2000 per hour.

    Rate this question:

  • 13. 

    Pada Sel A7 dituliskan sebuah rumus =MAX(A2:A6), jika A2=2, A3=4, A4=1, A5=0 dan A6=4, maka pada Sel A7 menghasilkan output

    • 2

    • 4

    • 1

    • 0

    • 3

    Correct Answer
    A. 4
    Explanation
    The formula =MAX(A2:A6) is used to find the maximum value among the numbers in cells A2 to A6. In this case, the numbers in those cells are 2, 4, 1, 0, and 4. The maximum value among these numbers is 4, so the output in cell A7 is 4.

    Rate this question:

  • 14. 

    Mengambil sejumlah data karakter yg telah ditentukan mulai dari Kanan dalam suatu cells adalah merupakan salah satu fungsi text berikut …

    • RIGHT

    • LEVT

    • RIHGT

    • MID

    • MIT

    Correct Answer
    A. RIGHT
    Explanation
    The correct answer is "RIGHT" because the function "RIGHT" is used to extract a specified number of characters from the right side of a text string. It is used in this case to extract a certain number of characters from the right side of a cell's data.

    Rate this question:

  • 15. 

    Pertemuan antara Kolom dan Baris yang membentuk sebuah kotak persegi panjang, adalah definisi dari : 

    • Workbook

    • Worsheet

    • Range

    • Sel

    • Sheet

    Correct Answer
    A. Range
    Explanation
    The correct answer is Range. A range refers to the intersection between a row and a column, forming a rectangular shape. It is used to define a group of cells in a spreadsheet. A range can be used to perform calculations, apply formatting, or manipulate data within the specified area.

    Rate this question:

  • 16. 

    Ascending adalah :

    • Mengurutkan data dari besar ke kecil

    • Mengurutkan data dari kecil ke besar

    • Mencari nilai paling besar

    • Mencari nilai paling kecil

    • Merubah semua huruf kecil menjadi huruf besar

    Correct Answer
    A. Mengurutkan data dari kecil ke besar
    Explanation
    Ascending adalah proses mengurutkan data dari kecil ke besar. Ini berarti bahwa data akan diatur dalam urutan menaik, dimulai dari nilai terkecil hingga nilai terbesar.

    Rate this question:

  • 17. 

    Berikut ini yang bukan merupakan Operator Aritmatik dalam Microsoft Excel adalah :

    • () , / , ^

    • + , - , *

    • * , x, -

    • ”” , - , *

    • * , + , -

    Correct Answer
    A. () , / , ^
    Explanation
    The given answer states that the operators () (parentheses), / (division), and ^ (exponentiation) are not arithmetic operators in Microsoft Excel. This is because parentheses are used for grouping and controlling the order of operations, while division and exponentiation are considered mathematical operations but not specifically arithmetic operations.

    Rate this question:

  • 18. 

    Yang tidak termasuk dalam kategori software operating system  adalah… .

    • Windows 98

    • LINUX

    • MAC OS

    • Microsoft Office

    • Free BSD

    Correct Answer
    A. Microsoft Office
    Explanation
    Microsoft Office tidak termasuk dalam kategori software operating system karena Microsoft Office adalah paket aplikasi produktivitas yang digunakan untuk membuat, mengedit, dan mengelola dokumen, spreadsheet, presentasi, dan database. Sementara itu, software operating system seperti Windows 98, LINUX, MAC OS, dan Free BSD adalah sistem operasi yang mengendalikan dan mengelola sumber daya komputer serta menyediakan antarmuka antara pengguna dan perangkat keras komputer.

    Rate this question:

  • 19. 

    Port PS/2 digunakan untuk peripheral.....

    • Speaker

    • Monitor

    • Mouse

    • Printer

    • LCD Proyektor

    Correct Answer
    A. Mouse
    Explanation
    The correct answer is "Mouse" because the PS/2 port is commonly used to connect a mouse to a computer. The PS/2 port is a round connector with six pins and is typically colored purple. It is an older type of port that has been largely replaced by USB ports, but some older computers and peripherals still use the PS/2 connection. Therefore, it is reasonable to assume that the PS/2 port mentioned in the question is used for connecting a mouse.

    Rate this question:

  • 20. 

    Descending adalah :

    • Mengurutkan data dari besar ke kecil

    • Mengurutkan data dari kecil ke besar

    • Mencari nilai paling besar

    • Mencari nilai paling keci

    • Merubah semua huruf besar menjadi huruf kecil

    Correct Answer
    A. Mengurutkan data dari besar ke kecil
    Explanation
    Descending adalah mengurutkan data dari besar ke kecil.

    Rate this question:

  • 21. 

    Contoh penulisan rumus yang benar adalah : 

    • Sum(D4:D9)

    • =If D4

    • =C3*D5

    • =sum C4,D4

    • =Avg (D6:D10)

    Correct Answer
    A. =C3*D5
    Explanation
    The given answer is an example of a correct formula. It multiplies the value in cell C3 with the value in cell D5. The "=" sign at the beginning indicates that it is a formula, and the "*" symbol is used for multiplication. This formula can be used in spreadsheet software to calculate the product of two numbers.

    Rate this question:

  • 22. 
    Rumus untuk PPH (pajak) = 10% * Total Upah Bruto adalah - ProProfs

    Rumus untuk PpH (pajak) = 10% * Total Upah Bruto adalah

    • =10%*F6

    • 10%*F6

    • =10%*E6

    • =10%*G6

    • =10%*B6

    Correct Answer
    A. =10%*F6
    Explanation
    The given answer is the correct formula to calculate the PPH (pajak) or tax, which is 10% multiplied by the value in cell F6.

    Rate this question:

  • 23. 

    Yang termasuk golongan software multimedia adalah seperti dibawah ini, kecuali… .

    • Winamp

    • Media Player

    • XIne

    • Power DVD

    • Open Office

    Correct Answer
    A. Open Office
    Explanation
    Open Office is not a multimedia software. It is an open-source office suite that includes word processing, spreadsheet, presentation, and database applications. On the other hand, Winamp, Media Player, XIne, and Power DVD are all multimedia software that are used for playing audio or video files.

    Rate this question:

  • 24. 

    Alamat yang selalu tetap pada setiap perpindahan sel disebut

    • Sel Semi absolut

    • Sel absolut

    • Sel Full absolut

    • Range

    • Sel Relatif

    Correct Answer
    A. Sel absolut
    Explanation
    Sel absolut adalah alamat yang selalu tetap pada setiap perpindahan sel. Selain itu, sel absolut juga tidak berubah meskipun terjadi perubahan pada baris atau kolom di sekitarnya.

    Rate this question:

  • 25. 

    Berikut ini yang bukan termasuk tipe data Numerik (angka), adalah : 

    • String

    • Integer

    • Float

    • Double Integer

    • Decimal

    Correct Answer
    A. Double Integer
    Explanation
    The term "Double Integer" does not belong to the numeric data types. It is not a commonly used or recognized data type in programming languages. The other options, String, Integer, Float, and Decimal, are all valid numeric data types commonly used to store numerical values.

    Rate this question:

  • 26. 
    Rumus Menghitung Total Bayar adalah - ProProfs

    Rumus Menghitung Total Bayar adalah

    • =(D7*F7)-G7

    • (D7*F7)-G7

    • =(D7xF7)-G7

    • =D7*F7-G7

    • =(D7*F7)-E7

    Correct Answer
    A. =(D7*F7)-G7
    Explanation
    The given answer is the correct formula to calculate the total payment. It multiplies the value in cell D7 with the value in cell F7, and then subtracts the value in cell G7 from the result. This formula accurately calculates the total payment based on the given values in the cells.

    Rate this question:

  • 27. 

    Berapa banyak sel yang dijumlahkan pada penulisan fungsi =sum(T11:AE11) ?

    • 10

    • 11

    • 12

    • 13

    • 14

    Correct Answer
    A. 12
    Explanation
    The correct answer is 12 because the function =sum(T11:AE11) is used to add up the values in the range T11 to AE11. Since there are 12 cells in this range, the sum will be equal to the sum of the values in those 12 cells.

    Rate this question:

  • 28. 
    Rumus untuk menentukan Angkatan  adalah - ProProfs

    Rumus untuk menentukan Angkatan  adalah

    • =MID(A6;3;2)

    • MID(A6;3;2)

    • =MID(A8;3;2)

    • =MID(A9;3;2)

    • =LEFT(A6;3;2)

    Correct Answer
    A. =MID(A6;3;2)
    Explanation
    The correct answer is "=MID(A6;3;2)". This formula uses the MID function in Excel to extract a substring from cell A6. The parameters "3" and "2" indicate that the substring should start at the 3rd character and have a length of 2 characters. This formula is used to determine the Angkatan, which is likely a specific value or code within the text in cell A6.

    Rate this question:

  • 29. 
    Rumus  Biaya dibayar =(TARIP SEWA – DISCOUNT) * LAMA SEWA - ProProfs

    Rumus  Biaya dibayar =(TARIP SEWA – DISCOUNT) * LAMA SEWA

    • =(F7*E7)-F7

    • =(D7*E7)-F7

    • =(D7*E7)-E7

    • (D7*E7)-F7

    • =(D7*E7)-D7

    Correct Answer
    A. =(D7*E7)-F7
    Explanation
    The given formula calculates the amount to be paid by subtracting the discount from the rental rate and then multiplying it by the duration of the rental. In this case, the correct answer is =(D7*E7)-F7, which means that the rental rate (D7) multiplied by the duration of the rental (E7) is subtracted by the discount (F7) to calculate the amount to be paid.

    Rate this question:

  • 30. 
    Rumus Discount ditentukan sebagai berikut : Jika lama pinjam lebih besar dari 5 hari maka discount sebesar 10% dari tarip sewa - ProProfs

    Rumus Discount ditentukan sebagai berikut : Jika lama pinjam lebih besar dari 5 hari maka discount sebesar 10% dari tarip sewa

    • =HLOOKUP(D7>5;10%*E7;0)

    • IF(D7>5;10%*E7;0)

    • =IF(D7>5;10%*E7;0)

    • =IF(E7>5;10%*E7;0)

    • =IFF(D7>5;10%*E7;0)

    Correct Answer
    A. =IF(D7>5;10%*E7;0)
    Explanation
    The correct answer is =IF(D7>5;10%*E7;0). This formula is using the IF function to check if the value in cell D7 is greater than 5. If it is, then it multiplies the value in cell E7 by 10% (which is equivalent to 0.1) and returns the result. If the value in cell D7 is not greater than 5, it returns 0. This formula is calculating the discount amount based on the condition stated in the given explanation.

    Rate this question:

  • 31. 
    Rumus untuk  Bayar Diambil Dari Kode (JIka Kode CS=Cash,CT=Credit) adalah - ProProfs

    Rumus untuk  Bayar Diambil Dari Kode (JIka Kode CS=Cash,CT=Credit) adalah

    • =IF(RIGHT(B6;2)="CS";"CASH";"CREDIT")

    • =IF(RIGHT(B6;2)="CS";"CASH";IF(RIGHT(B6;2)="CT";"CREDIT";0))

    • IF(RIGHT(B6;2)="CS";"CASH";IF(RIGHT(B6;2)="CT";"CREDIT";0))

    • A dan B Benar

    • A B C Benar

    Correct Answer
    A. A dan B Benar
    Explanation
    The correct answer is A dan B Benar. The formula is checking the last two characters of cell B6. If the last two characters are "CS", it returns "CASH". If the last two characters are "CT", it returns "CREDIT". If neither of these conditions is met, it returns 0. Both options A and B correctly implement this logic.

    Rate this question:

  • 32. 

    Pada Sel A7 dituliskan sebuah rumus =SUM(A2:A6), jika A2=2, A3=4, A4=1, A5=0 dan A6=4, maka pada Sel A7 menghasilkan output

    • 11

    • 5

    • 4

    • 9

    • Salah semua

    Correct Answer
    A. 11
    Explanation
    The formula =SUM(A2:A6) calculates the sum of the values in cells A2 to A6. Given that A2=2, A3=4, A4=1, A5=0, and A6=4, the sum of these values is 2+4+1+0+4=11. Therefore, the correct answer is 11.

    Rate this question:

  • 33. 
    Rumus Harga Satuan  adalah - ProProfs

    Rumus Harga Satuan  adalah

    • =VLOOKUP(LEFT(B6;2);$C$25:$F$27;3)

    • =HLOOKUP(LEFT(B6;2);$C$25:$F$27;3)

    • =HLOOKUP(LEFT(Sheet1!B6;2);Sheet1!$C$25:$F$27;3)

    • =HLOOKUP(LEFT(Sheet2!B6;2);$C$25:$F$27;3)

    • HLOOKUP(LEFT(Sheet1!B6;2);Sheet1!$C$25:$F$27;3)

    Correct Answer
    A. =HLOOKUP(LEFT(B6;2);$C$25:$F$27;3)
    Explanation
    The correct answer is =HLOOKUP(LEFT(B6;2);$C$25:$F$27;3). This formula uses the HLOOKUP function to search for a value in the first row of a table and returns a value in the same column from a specified row in the table. In this case, it is searching for the leftmost two characters of the value in cell B6, and looking for a match in the range $C$25:$F$27. It will return the value in the third row of the matching column.

    Rate this question:

  • 34. 
    Rumus Nama Bunga adalah - ProProfs

    Rumus Nama Bunga adalah

    • =HLOOKUP(LEFT(B6;2);$C$25:$F$27;2)

    • =HLOOKUP(LEFT(B6;2);Sheet2!$C$25:$F$27;2)

    • =VLOOKUP(LEFT(B6;2);Sheet1!$C$25:$F$27;2)

    • =HLOOKUP(LEFT(B6;2);Sheet1!$C$25:$F$27;2)

    • =HLOOKUP(MID(B6;2);Sheet1!$C$25:$F$27;2)

    Correct Answer
    A. =HLOOKUP(LEFT(B6;2);$C$25:$F$27;2)
  • 35. 
    Rumus Upah Bruto = Upah Kerja + Upah Lembur (gunakan rumus atau fungsi SUM) adalah - ProProfs

    Rumus Upah Bruto = Upah Kerja + Upah Lembur (gunakan rumus atau fungsi SUM) adalah

    • =D6+E6

    • =SUM(D6:E6)

    • =SUM(D6;E6)

    • =SUM(D6:F6)

    • =SUM(D6:G6)

    Correct Answer
    A. =SUM(D6:E6)
    Explanation
    The correct answer is =SUM(D6:E6). This is because the question asks for the formula to calculate the gross wage, which is the sum of the regular wage (D6) and overtime wage (E6). The SUM function in Excel is used to add up values, and in this case, it is used to add D6 and E6 to get the total gross wage.

    Rate this question:

  • 36. 
    Rumus untuk Mencari Tarif Kamar  adalah   * Jika Kelas = Ekonomi, Tarif = 25000                             * Jika Kelas = Utama, Tarif = 50000                             * Jika Kelas = V.I.P, Tarif = 75000 - ProProfs

    Rumus untuk Mencari Tarif Kamar  adalah   * Jika Kelas = Ekonomi, Tarif = 25000                             * Jika Kelas = Utama, Tarif = 50000                             * Jika Kelas = V.I.P, Tarif = 75000

    • =IF(D9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))

    • IF(D9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))

    • =IF(B9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))

    • =IF(A9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))

    • =IF(F9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))

    Correct Answer
    A. =IF(D9="EKONOMI";25000;IF(D9="UTAMA";50000;75000))
    Explanation
    The given correct answer is a formula in Excel that uses the IF function to determine the tariff rate based on the value in cell D9. If the value in D9 is "EKONOMI", the tariff rate is set to 25000. If the value in D9 is "UTAMA", the tariff rate is set to 50000. If the value in D9 is neither "EKONOMI" nor "UTAMA", the tariff rate is set to 75000. This formula allows for the calculation of the tariff rate based on the specified conditions.

    Rate this question:

  • 37. 
    Rumus untuk menentukan Jurusan adalah - ProProfs

    Rumus untuk menentukan Jurusan adalah

    • VLOOKUP(LEFT(A6;2);$H$8:$I$12;2)

    • =VLOOKUP(LEFT(A6;2);$H$8:$I$12;2)

    • =VLOOKUP(A6;2);$H$8:$I$12;2)

    • =HLOOKUP(LEFT(A6;2);$H$8:$I$12;2)

    • =VLOOKUP(MID(A6;2);$H$8:$I$12;2)

    Correct Answer
    A. =VLOOKUP(LEFT(A6;2);$H$8:$I$12;2)
    Explanation
    The correct answer is =VLOOKUP(LEFT(A6;2);$H$8:$I$12;2). This formula is used to search for a value in the leftmost column of a table and return the corresponding value from a specified column. In this case, the formula is looking for the first two characters of the value in cell A6 and searching for it in the range $H$8:$I$12. It will return the value from the second column of that range.

    Rate this question:

  • 38. 

    Pada Sel A7 dituliskan sebuah rumus =COUNT(A2:A6), jika A2=2, A3=4, A4=1, A5=0 dan A6=4, maka pada Sel A7 menghasilkan output

    • 5

    • 11

    • 9

    • 10

    • 15

    Correct Answer
    A. 5
    Explanation
    The formula =COUNT(A2:A6) counts the number of cells in the range A2 to A6 that contain numeric values. In this case, the values in those cells are 2, 4, 1, 0, and 4, so there are 5 cells with numeric values. Therefore, the output in cell A7 is 5.

    Rate this question:

  • 39. 
    Rumus untuk Alamat adalah - ProProfs

    Rumus untuk Alamat adalah

    • =VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)

    • =VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;3)

    • VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)

    • =HLOOKUP(MID(B6;4;3);Sheet1!$H$25:$K$29;3)

    • =VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;3)

    Correct Answer
    A. =VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
    Explanation
    The correct answer is "=VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)". This formula uses the VLOOKUP function to search for a value in the range $H$25:$K$29 based on the middle three characters of cell B6. It will return the corresponding value from the third column of the range. This formula is correct because it follows the syntax and logic of the VLOOKUP function.

    Rate this question:

  • 40. 
    Rumus untuk mencari Kota adalah - ProProfs

    Rumus untuk mencari Kota adalah

    • VLOOKUP(MID(B6;4;3);$H$25:$K$29;4)

    • =VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;4)

    • =VLOOKUP(MID(B6;4;3);$H$25:$K$29;4)

    • =HLOOKUP(MID(B6;4;3);Sheet1!$H$25:$K$29;4)

    • =VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;4)

    Correct Answer
    A. =VLOOKUP(MID(B6;4;3);$H$25:$K$29;4)
    Explanation
    The correct answer is =VLOOKUP(MID(B6;4;3);$H$25:$K$29;4). This formula is used to perform a vertical lookup in Excel. It searches for a value in the first column of a specified range and returns a corresponding value from a different column in the same row. In this case, the formula is looking for a value extracted from cell B6 using the MID function, and searching for it in the range $H$25:$K$29. It then returns the value from the fourth column of that range.

    Rate this question:

  • 41. 
    Rumus untuk mencari KETERANGAN adalah     LULUS ; JIKA NILAI HURUF A,B DAN  C     MENGULANG JIKA NILAI D     GAGAL JIKA NILAI E - ProProfs

    Rumus untuk mencari KETERANGAN adalah     LULUS ; JIKA NILAI HURUF A,B DAN  C     MENGULANG JIKA NILAI D     GAGAL JIKA NILAI E

    • =IF(L6="E";"GAGAL";IF(L6="D";"MENGULANG";"LULUS"))

    • IF(L6="E";"GAGAL";IF(L6="D";"MENGULANG";"LULUS"))

    • =IF(L6"E";"GAGAL";IF(L6="D";"MENGULANG";"LULUS"))

    • =IF(L6="E";"GAGAL";IF(L6="D";MENGULANG","LULUS"))

    • =IF(L6="E";"GAGAL";IF(L6="D";"MENGULANG";LULUS))

    Correct Answer
    A. =IF(L6="E";"GAGAL";IF(L6="D";"MENGULANG";"LULUS"))
    Explanation
    The given formula is an Excel formula used to determine the result based on the value in cell L6. If the value in L6 is "E", the result will be "GAGAL". If the value is "D", the result will be "MENGULANG". For any other value, the result will be "LULUS".

    Rate this question:

  • 42. 
     Tarif sewa diambil dari tabel dengan menggunakan fungsi apa - ProProfs

     Tarif sewa diambil dari tabel dengan menggunakan fungsi apa

    • =HLOOKUP(E7;$C$20:$F$21;2;0)

    • =HLOOKUP(D7;$C$20:$F$21;2;0)

    • HLOOKUP(C7;$C$20:$F$21;2;0)

    • =VLOOKUP(C7;$C$20:$F$21;2;0)

    • =HLOOKUP(C7;$C$20:$F$21;2;0)

    Correct Answer
    A. =HLOOKUP(C7;$C$20:$F$21;2;0)
    Explanation
    The correct answer is =HLOOKUP(C7;$C$20:$F$21;2;0). This is because the HLOOKUP function is used to retrieve data from a specific row in a table. In this case, the function is looking up the value in cell C7 and searching for it in the range $C$20:$F$21. It will then return the value from the second row of the table.

    Rate this question:

  • 43. 
    Rumus Untuk Harga Satuan ditentukan sebagai berikut : §         Jika Kode Barang = “A”, Harga Satuan Rp 1000,- §         Jika Kode Barang = “B”, Harga Satuan Rp 2000,- §         Jika Kode Barang = “C”, Harga Satuan Rp 3000,- §         Jika Kode Barang selain diatas Harga Satuan = 0 - ProProfs

    Rumus Untuk Harga Satuan ditentukan sebagai berikut : §         Jika Kode Barang = “A”, Harga Satuan Rp 1000,- §         Jika Kode Barang = “B”, Harga Satuan Rp 2000,- §         Jika Kode Barang = “C”, Harga Satuan Rp 3000,- §         Jika Kode Barang selain diatas Harga Satuan = 0

    • =IF(E7="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))

    • IF(E7="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))

    • =IF(E6="A";1000;IF(E6="B";2000;IF(E6="C";3000;0)))

    • =IF(E6="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))

    • =IF(E7="A";1000;IF(E7="B";2000;IF(E8="C";3000;0)))

    Correct Answer
    A. =IF(E7="A";1000;IF(E7="B";2000;IF(E7="C";3000;0)))
    Explanation
    The given answer is a formula in Excel that calculates the unit price based on the code of the item. It uses the IF function to check the value of cell E7. If the value is "A", it returns 1000. If the value is "B", it returns 2000. If the value is "C", it returns 3000. If the value is anything else, it returns 0. This formula allows for easy calculation of unit prices based on the item code.

    Rate this question:

  • 44. 
    Rumus  Untuk menghitung potongan ditentukan sebagai berikut : §         Jika Kode Pembeli = 1, maka Potongan = 10% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli = 2, maka Potongan = 7.5% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli = 3, maka Potongan = 5% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli selain diatas, maka potongan = 0 - ProProfs

    Rumus  Untuk menghitung potongan ditentukan sebagai berikut : §         Jika Kode Pembeli = 1, maka Potongan = 10% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli = 2, maka Potongan = 7.5% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli = 3, maka Potongan = 5% * Jumlah Barang * Harga Satuan §         Jika Kode Pembeli selain diatas, maka potongan = 0

    • IF(C7=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))

    • =IF(C7=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))

    • =IF(C6=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))

    • =IF(C9=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))

    • =IF(C7=1;10%*D7*F7;IF(C8=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))

    Correct Answer
    A. =IF(C7=1;10%*D7*F7;IF(C7=2;7,5%*D7*F7;IF(C7=3;5%*D7*F7;0)))
    Explanation
    The given answer is a formula that calculates the discount based on the value in cell C7 (the code for the buyer), the value in cell D7 (the quantity of items), and the value in cell F7 (the unit price). If the code is 1, the discount is 10% of the quantity multiplied by the unit price. If the code is 2, the discount is 7.5% of the quantity multiplied by the unit price. If the code is 3, the discount is 5% of the quantity multiplied by the unit price. For any other code, the discount is 0.

    Rate this question:

  • 45. 
    Rumus Untuk mencari Kelas adalah      * Jika Kode Kamar = AA, Maka Kelas = Ekonomi.                * Jika Kode Kamar = AB, Maka Kelas = Utama                * Jika Kode Kamar = AC, Maka Kelas = V.I.P. - ProProfs

    Rumus Untuk mencari Kelas adalah      * Jika Kode Kamar = AA, Maka Kelas = Ekonomi.                * Jika Kode Kamar = AB, Maka Kelas = Utama                * Jika Kode Kamar = AC, Maka Kelas = V.I.P.

    • IF(B9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))

    • =IF(E9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))

    • =IF(C9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))

    • =IF(C9="AA";"EKONOMI";IF(D9="AB";"UTAMA";IF(C9="AC";"VIP";0)))

    • =IF(C9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(G9="AC";"VIP";0)))

    Correct Answer
    A. =IF(C9="AA";"EKONOMI";IF(C9="AB";"UTAMA";IF(C9="AC";"VIP";0)))
    Explanation
    The given correct answer is a formula that uses nested IF statements to determine the value of the "Kelas" (Class) based on the value of "Kode Kamar" (Room Code). The formula checks if the value in cell C9 is "AA" and if so, it returns "EKONOMI" as the class. If the value in cell C9 is "AB", it returns "UTAMA" as the class. And if the value in cell C9 is "AC", it returns "VIP" as the class. If none of these conditions are met, it returns 0.

    Rate this question:

  • 46. 
    Rumus untuk menentukan Biaya Per SKS adalah - ProProfs

    Rumus untuk menentukan Biaya Per SKS adalah

    • VLOOKUP(LEFT(A6;2);$H$8:$J$12;3)

    • =HLOOKUP(LEFT(A6;2);$H$8:$J$12;3)

    • =VLOOKUP(MID(A6;2);$H$8:$J$12;3)

    • =VLOOKUP(LEFT(A6;2);$H$8:$J$12;3)

    • =HLOOKUP(LEFT(A6;2);$H$8:$J$12;3)

    Correct Answer
    A. =VLOOKUP(LEFT(A6;2);$H$8:$J$12;3)
    Explanation
    The correct answer is =VLOOKUP(LEFT(A6;2);$H$8:$J$12;3). This formula is using the VLOOKUP function to search for a value in the leftmost column of a table array and return a corresponding value from a specified column. In this case, it is looking for the first 2 characters of the value in cell A6, searching in the range $H$8:$J$12, and returning the value in the third column of that range. This formula is used to determine the cost per credit hour (Biaya Per SKS) based on the code in cell A6.

    Rate this question:

  • 47. 
    Rumus Untuk Discount Jika Kelas = V.I.P atau Lama Tinggal>5, maka Discount = 10% dari Lama Tinggal * Tarif Kamar                          * Selain Ketentuan diatas tidak mendapatkan Discount. - ProProfs

    Rumus Untuk Discount Jika Kelas = V.I.P atau Lama Tinggal>5, maka Discount = 10% dari Lama Tinggal * Tarif Kamar                          * Selain Ketentuan diatas tidak mendapatkan Discount.

    • =IF(OR(D9="VIP";G9>5);10%*G9*H9;0)

    • IF(OR(D9="VIP";G9>5);10%*G9*H9;0)

    • =IF(AND(D9="VIP";G9>5);10%*G9*H9;0)

    • =IF(OR(E9="VIP";G9>5);10%*G9*H9;0)

    • =IF(OR(D9=VIP;G9>5);10%*G9*H9;0)

    Correct Answer
    A. =IF(OR(D9="VIP";G9>5);10%*G9*H9;0)
    Explanation
    The correct answer is =IF(OR(D9="VIP";G9>5);10%*G9*H9;0). This formula is checking two conditions using the OR function. If either condition is true (D9="VIP" or G9>5), then the formula will calculate the discount by multiplying 10% of the stay duration (G9) with the room rate (H9). If both conditions are false, the formula will return 0, indicating that no discount is applicable.

    Rate this question:

  • 48. 
    Untuk rumus Discount Jika Bayar CASH   20% X Nilai                                      Jika Bayar CREDIT  5% x Nilai adalah - ProProfs

    Untuk rumus Discount Jika Bayar CASH   20% X Nilai                                      Jika Bayar CREDIT  5% x Nilai adalah

    • =IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0))

    • IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0))

    • =IF(I6="CASH";20%*J6;"CREDIT")

    • =IF(I6="CASH";20%*J6;"CREDIT") IF(I6="CASH";20%*J6;"CREDIT")

    • A dan B Benar

    Correct Answer
    A. =IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0))
    Explanation
    The correct answer is =IF(I6="CASH";20%*J6;IF(I6="CREDIT";5%*J6;0)). This formula is used to calculate the discount based on the payment method. If the payment method is "CASH", it will apply a 20% discount on the value (J6). If the payment method is "CREDIT", it will apply a 5% discount on the value (J6). If the payment method is neither "CASH" nor "CREDIT", it will return 0.

    Rate this question:

  • 49. 
    Rumus Untuk Nama Toko adalah - ProProfs

    Rumus Untuk Nama Toko adalah

    • =VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)

    • =VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)

    • =VLOOKUP(LEFT(B6;4;3);$H$25:$K$29;3)

    • =VLOOKUP(MID(B6;4;3);Sheet2!$H$25:$K$29;3)

    • =HLOOKUP(MID(B6;4;3);$H$25:$K$29;3)

    Correct Answer
    A. =VLOOKUP(MID(B6;4;3);$H$25:$K$29;3)
    Explanation
    The given correct answer is the VLOOKUP function with the parameters MID(B6;4;3), $H$25:$K$29, and 3. This formula is used to retrieve the value from the third column in the range $H$25:$K$29, based on the three characters extracted from cell B6 starting from the fourth position. The MID function is used to extract the desired characters from B6, and the VLOOKUP function is used to search for a match in the first column of the range and return the corresponding value from the third column.

    Rate this question:

Quiz Review Timeline (Updated): Jul 22, 2024 +

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

  • Current Version
  • Jul 22, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 17, 2014
    Quiz Created by
    Smpn26
Back to Top Back to top
Advertisement