Remedial Uas Kelas Xi ( Sebelas ) Sem. I Tahun 2016

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 Bahaduralay
B
Bahaduralay
Community Contributor
Quizzes Created: 1 | Total Attempts: 602
| Attempts: 602
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/20 Pertanyaan

    Untuk membuat formula atau rumus, maka pada awal data harus ditulis tanda …

    • =
    • +
    • *
    • @
    • $
Please wait...
About This Quiz

Remedial Uas Kelas Xi ( Sebelas ) Sem. I Tahun 2016 - Quiz

Quiz Preview

  • 2. 

    Fungsi untuk mencari nilai maksimum suatu range dari L2 sampai L7 adalah…..

    • =MAX(L2:LII)

    • MAX ( L6:L7)

    • =MAX(L2:L7)

    • MAX(L7:L20)

    • MAX (L7:L2)

    Correct Answer
    A. =MAX(L2:L7)
    Explanation
    The correct answer is =MAX(L2:L7). This formula is used to find the maximum value within the range of cells from L2 to L7. It will evaluate all the values in that range and return the highest value.

    Rate this question:

  • 3. 

    Fungsi SUM untuk mencari total range dari S3 sampai S10 adalah…..

    • = SUM(J3:J10)

    • = SUM(S3:S10)

    • = SUM(S3:S6)

    • SUM(S3:H19)

    • SUM(S3:J3)

    Correct Answer
    A. = SUM(S3:S10)
    Explanation
    The correct answer is = SUM(S3:S10). This is because the SUM function is used to calculate the total sum of a range of cells. In this case, the range specified is from cell S3 to S10, so the function will add up the values in those cells and return the total sum.

    Rate this question:

  • 4. 

    Rumus yang digunakan untuk menjumlahkan nilai adalah...

    • = Count

    • = Average

    • = Var

    • = SUM

    • = IF

    Correct Answer
    A. = SUM
    Explanation
    The correct answer is = SUM. The SUM function is used to add up a range of values in a spreadsheet. It allows you to easily calculate the total of a set of numbers.

    Rate this question:

  • 5. 

    Untuk membuka program Microsoft Excel digunakan langkah-langkah…. 

    • Start-Program-Paint

    • Start-Program-Accessories-Microsoft Excel

    • Start-Microsoft Word-Program

    • Start-Program-Microsoft Office- Microsoft Excel

    • Start-Program-Close

    Correct Answer
    A. Start-Program-Microsoft Office- Microsoft Excel
    Explanation
    The correct answer is "Start-Program-Microsoft Office- Microsoft Excel" because to open Microsoft Excel, you need to start the program, go to the Start menu, select the Program folder, find and open the Microsoft Office folder, and then open Microsoft Excel.

    Rate this question:

  • 6. 

    Bentuk fungsi excel seperti=SUM(B1:B5) dapat diartikan….

    • Membagi angka sel B1 dengan angka sel B5

    • Menjumlahkan angka sel B1 dan Angka sel B5

    • Menjumlahkan angka sel B1 sampai angka sel B5

    • Merata-ratakan angka sel B1 sampai angka sel B5

    • Merata-ratakan angka sel B1 dan angka sel B5

    Correct Answer
    A. Menjumlahkan angka sel B1 sampai angka sel B5
    Explanation
    The given correct answer states that the Excel function SUM(B1:B5) is used to sum the numbers in the range from cell B1 to B5. This means that it will add up all the numbers in cells B1, B2, B3, B4, and B5 and provide the total sum as the result.

    Rate this question:

  • 7. 

    Fungsi untuk mencari nilai minimum data pada range dari H5 sampai H12 adalah ....

    • = MIN(H5-H12)

    • =MIN(H5:H12)

    • =MIN(H5;H12)

    • MIN(H5,H12)

    • =MIN(H5:H24)

    Correct Answer
    A. =MIN(H5:H12)
    Explanation
    The correct answer is =MIN(H5:H12). This formula is used to find the minimum value within the range of cells from H5 to H12. The MIN function in Excel returns the smallest value from a given set of values. In this case, it will return the minimum value from the range of cells H5 to H12.

    Rate this question:

  • 8. 

    Pada penggabungan dua sel kolom digunakan pilihan….

    • Insert Cell

    • Split Cell

    • Merge Center

    • Delete

    • Delete

    Correct Answer
    A. Merge Center
    Explanation
    The correct answer is "Merge Center". This option is used when combining two column cells into one. It allows the content of both cells to be merged into a single cell, with the text centered within the merged cell. This can be useful for creating a more organized and visually appealing layout in a spreadsheet or table.

    Rate this question:

  • 9. 

    Sel A1 berisi 6000, sel B1 berisi 8000, sel C1 berisi 9000 jika sel D1 berisi formula = Min ( A1:C1), maka isi sel D1 adalah ….

    • 6000

    • 7000

    • 8000

    • 9000

    • 21000

    Correct Answer
    A. 6000
    Explanation
    The formula used in cell D1 is "Min(A1:C1)", which calculates the minimum value among the numbers in cells A1, B1, and C1. Since the minimum value among 6000, 8000, and 9000 is 6000, the answer is 6000.

    Rate this question:

  • 10. 

    Pada sel A1 berisi angka 4, jika pada sel B2 berisi fungsi IF(A1>5,”LULUS”,”TIDAK LULUS”), bila kita tekan Enter akan menghasilkan ….

    • Lulus

    • Gagal

    • Hang

    • Tidak lulus

    • Semua salah

    Correct Answer
    A. Tidak lulus
    Explanation
    Jawaban yang benar adalah "Tidak lulus". Hal ini karena fungsi IF(A1>5,"LULUS","TIDAK LULUS") akan mengevaluasi apakah nilai di sel A1 lebih besar dari 5. Jika iya, maka akan menghasilkan "LULUS", jika tidak, maka akan menghasilkan "TIDAK LULUS". Karena nilai di sel A1 adalah 4, yang kurang dari 5, maka fungsi akan menghasilkan "TIDAK LULUS".

    Rate this question:

  • 11. 

    Pada sel C1, C2, C3, dan C4 berturut-turut berisi 24, 20, 17 dan 23. Jika pada sel A6 berisi fungsi SUM(C1:C4), akan menghasilkan angka …..

    • 64

    • 74

    • 84

    • 94

    • 99

    Correct Answer
    A. 84
    Explanation
    The function SUM(C1:C4) adds up the values in cells C1, C2, C3, and C4. The values in these cells are 24, 20, 17, and 23 respectively. Therefore, the sum of these values is 24 + 20 + 17 + 23 = 84.

    Rate this question:

  • 12. 

    Pada sel C1, C2, C3, dan C4 berturut-turut berisi 24, 20, 17 dan 23. Jika pada sel A6 berisi fungsi MIN(C1:C4), akan menghasilkan angka …..

    • 20

    • 17

    • 24

    • 23

    • 28

    Correct Answer
    A. 17
    Explanation
    The function MIN(C1:C4) will return the minimum value among the numbers in cells C1, C2, C3, and C4. The numbers in these cells are 24, 20, 17, and 23 respectively. The minimum value among these numbers is 17.

    Rate this question:

  • 13. 

    Perintah yang digunakan mencari nilai dari suatu table pencarian pada baris yang ditentukan dengan metode menurun adalah …

    • LOOKUP

    • MLOOKUP

    • HLOOKUP

    • VLOOKUP

    • FLOOKUP

    Correct Answer
    A. VLOOKUP
    Explanation
    The correct answer is VLOOKUP. VLOOKUP is a command used to search for a value in a specified table and retrieve a corresponding value from another column in the same row. It is commonly used to perform vertical lookups in Excel and other spreadsheet programs. The "V" in VLOOKUP stands for vertical, indicating that the search is performed vertically in a column. It is different from HLOOKUP, which performs horizontal lookups in a row.

    Rate this question:

  • 14. 

    File Ms. Excel Sering disebut juga...

    • Workbook

    • Worksheet

    • Sheet

    • Lembar Kerja

    • Document

    Correct Answer
    A. Worksheet
    Explanation
    The correct answer is "Worksheet." In Ms. Excel, a worksheet is a single sheet within a workbook where data is organized and calculations are performed. It is used to enter, analyze, and manipulate data in a tabular format. A workbook can contain multiple worksheets, each identified by a sheet name, and they can be used for various purposes such as creating budgets, charts, and reports. Therefore, "Worksheet" is the appropriate term to describe a single sheet in Ms. Excel.

    Rate this question:

  • 15. 

    Untuk menghapus baris dan kolom digunakan perintah….

    • Delete row

    • Delete Column dan row

    • Delete Column

    • Jawaban a dan b benar

    • Delete cell

    Correct Answer
    A. Delete Column dan row
    Explanation
    The correct answer is "Delete Column and row" because it states that both deleting a column and deleting a row can be done using the same command. This implies that there is a single command that can be used to delete both columns and rows, making it the most appropriate answer.

    Rate this question:

  • 16. 

    Jika kita memblok range dari sel C2 hingga sel E9, berarti kita memblok sebanyak…

    • 12 sel

    • 14 sel

    • 18 sel

    • 21 sel

    • 24 sel

    Correct Answer
    A. 24 sel
    Explanation
    If we block the range from cell C2 to cell E9, it means we are blocking a total of 24 cells. This is because the range includes 3 columns (C, D, E) and 8 rows (2 to 9), resulting in a total of 24 cells being blocked.

    Rate this question:

  • 17. 
    Pada sel D4 berisi angka 50,  dengan ketentuan :- Jika nilainya lebih besar dari 50, maka dinyatakan “Naik Kelas”,sebaliknya jika nilainya kurang dari 50 maka dinyatakan “Tinggal Kelas”.Rumus yang benar untuk menentukan Hasil di Sel E4 adalah .... - ProProfs

    Pada sel D4 berisi angka 50,  dengan ketentuan :- Jika nilainya lebih besar dari 50, maka dinyatakan “Naik Kelas”,sebaliknya jika nilainya kurang dari 50 maka dinyatakan “Tinggal Kelas”.Rumus yang benar untuk menentukan Hasil di Sel E4 adalah ....

    • =IF(D4>”50”,”Naik Kelas”,”Tinggal Kelas”)

    • =IF(D4>”50”,”Naik Kelas, Tinggal Kelas”)

    • =IF(D1>50,”Naik Kelas”,”Tinggal Kelas”)

    • =IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)

    • IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)

    Correct Answer
    A. =IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)
    Explanation
    The correct answer is "=IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)". This formula checks if the value in cell D4 is greater than 50. If it is, it returns "Naik Kelas", indicating that the student has passed. If it is not, it returns "Tinggal Kelas", indicating that the student has failed. The quotation marks around the numbers in the other options are unnecessary and would cause an error in the formula.

    Rate this question:

  • 18. 
    Pada sel D8 berisi angka 80,  dengan ketentuan :- Jika nilainya lebih besar dari 50, maka dinyatakan “Naik Kelas”,sebaliknya jika nilainya kurang dari 50 maka dinyatakan “Tinggal Kelas”.Rumus yang benar untuk menentukan Hasil di Sel E8 adalah .... - ProProfs

    Pada sel D8 berisi angka 80,  dengan ketentuan :- Jika nilainya lebih besar dari 50, maka dinyatakan “Naik Kelas”,sebaliknya jika nilainya kurang dari 50 maka dinyatakan “Tinggal Kelas”.Rumus yang benar untuk menentukan Hasil di Sel E8 adalah ....

    • =IF(D8>”50”,”Naik Kelas”,”Tinggal Kelas”)

    • =IF(D8>”50”,”Naik Kelas, Tinggal Kelas”)

    • =IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)

    • =IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)

    • IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)

    Correct Answer
    A. =IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)
    Explanation
    The correct answer is =IF(D8>50,”Naik Kelas”,”Tinggal Kelas”). This formula checks if the value in cell D8 is greater than 50. If it is, it returns the text "Naik Kelas". If it is not, it returns the text "Tinggal Kelas".

    Rate this question:

  • 19. 

    Perintah yang digunakan mencari nilai dari suatu table pencarian pada baris yang ditentukan dengan metode mendatar adalah …

    • LOOKUP

    • MLOOKUP

    • HLOOKUP

    • VLOOKUP

    • FLOOKUP

    Correct Answer
    A. HLOOKUP
    Explanation
    HLOOKUP is the correct answer because it is a function used to search for a value in the top row of a table and return a corresponding value in the same column from a specified row. It is commonly used to search for data horizontally in a table.

    Rate this question:

  • 20. 

    Untuk menyisipkan baris, menu yang digunakan adalah….

    • Insert - column

    • Insert – cell

    • Insert – row

    • Edit – row

    • File – insert – row

    Correct Answer
    A. Insert – row
    Explanation
    The correct answer is "insert – row". This is because to insert a new row in a document or spreadsheet, the "insert" menu is used, and within that menu, the option to insert a row is selected.

    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
  • Dec 07, 2016
    Quiz Created by
    Bahaduralay
Back to Top Back to top
Advertisement