Remedial Uas Kelas Xi ( Sebelas ) Sem. I Tahun 2016
- 1.
File Ms. Excel Sering disebut juga...
- A.
Workbook
- B.
Worksheet
- C.
Sheet
- D.
Lembar Kerja
- E.
Document
Correct Answer
B. WorksheetExplanation
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:
-
- 2.
Jika kita memblok range dari sel C2 hingga sel E9, berarti kita memblok sebanyak…
- A.
12 sel
- B.
14 sel
- C.
18 sel
- D.
21 sel
- E.
24 sel
Correct Answer
E. 24 selExplanation
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:
-
- 3.
Untuk menyisipkan baris, menu yang digunakan adalah….
- A.
Insert - column
- B.
Insert – cell
- C.
Insert – row
- D.
Edit – row
- E.
File – insert – row
Correct Answer
C. Insert – rowExplanation
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:
-
- 4.
Pada penggabungan dua sel kolom digunakan pilihan….
- A.
Insert Cell
- B.
Split Cell
- C.
Merge Center
- D.
Delete
- E.
Delete
Correct Answer
C. Merge CenterExplanation
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:
-
- 5.
Untuk menghapus baris dan kolom digunakan perintah….
- A.
Delete row
- B.
Delete Column dan row
- C.
Delete Column
- D.
Jawaban a dan b benar
- E.
Delete cell
Correct Answer
B. Delete Column dan rowExplanation
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:
-
- 6.
Untuk membuat formula atau rumus, maka pada awal data harus ditulis tanda …
- A.
=
- B.
+
- C.
*
- D.
@
- E.
$
Correct Answer
A. =Explanation
To create a formula or equation in a spreadsheet, the equal sign (=) must be written at the beginning of the data. This signals to the software that the following characters are part of a formula and need to be calculated.Rate this question:
-
- 7.
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 ....
- A.
=IF(D4>”50”,”Naik Kelas”,”Tinggal Kelas”)
- B.
=IF(D4>”50”,”Naik Kelas, Tinggal Kelas”)
- C.
=IF(D1>50,”Naik Kelas”,”Tinggal Kelas”)
- D.
=IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)
- E.
IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)
Correct Answer
D. =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:
-
- 8.
Pada sel A1 berisi angka 4, jika pada sel B2 berisi fungsi IF(A1>5,”LULUS”,”TIDAK LULUS”), bila kita tekan Enter akan menghasilkan ….
- A.
Lulus
- B.
Gagal
- C.
Hang
- D.
Tidak lulus
- E.
Semua salah
Correct Answer
D. Tidak lulusExplanation
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:
-
- 9.
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 …..
- A.
64
- B.
74
- C.
84
- D.
94
- E.
99
Correct Answer
C. 84Explanation
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:
-
- 10.
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 …..
- A.
20
- B.
17
- C.
24
- D.
23
- E.
28
Correct Answer
B. 17Explanation
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:
-
- 11.
Fungsi untuk mencari nilai minimum data pada range dari H5 sampai H12 adalah ....
- A.
= MIN(H5-H12)
- B.
=MIN(H5:H12)
- C.
=MIN(H5;H12)
- D.
MIN(H5,H12)
- E.
=MIN(H5:H24)
Correct Answer
B. =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:
-
- 12.
Fungsi untuk mencari nilai maksimum suatu range dari L2 sampai L7 adalah…..
- A.
=MAX(L2:LII)
- B.
MAX ( L6:L7)
- C.
=MAX(L2:L7)
- D.
MAX(L7:L20)
- E.
MAX (L7:L2)
Correct Answer
C. =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:
-
- 13.
Fungsi SUM untuk mencari total range dari S3 sampai S10 adalah…..
- A.
= SUM(J3:J10)
- B.
= SUM(S3:S10)
- C.
= SUM(S3:S6)
- D.
SUM(S3:H19)
- E.
SUM(S3:J3)
Correct Answer
B. = 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:
-
- 14.
Rumus yang digunakan untuk menjumlahkan nilai adalah...
- A.
= Count
- B.
= Average
- C.
= Var
- D.
= SUM
- E.
= IF
Correct Answer
D. = SUMExplanation
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:
-
- 15.
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 ….
- A.
6000
- B.
7000
- C.
8000
- D.
9000
- E.
21000
Correct Answer
A. 6000Explanation
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:
-
- 16.
Bentuk fungsi excel seperti=SUM(B1:B5) dapat diartikan….
- A.
Membagi angka sel B1 dengan angka sel B5
- B.
Menjumlahkan angka sel B1 dan Angka sel B5
- C.
Menjumlahkan angka sel B1 sampai angka sel B5
- D.
Merata-ratakan angka sel B1 sampai angka sel B5
- E.
Merata-ratakan angka sel B1 dan angka sel B5
Correct Answer
C. Menjumlahkan angka sel B1 sampai angka sel B5Explanation
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:
-
- 17.
Untuk membuka program Microsoft Excel digunakan langkah-langkah….
- A.
Start-Program-Paint
- B.
Start-Program-Accessories-Microsoft Excel
- C.
Start-Microsoft Word-Program
- D.
Start-Program-Microsoft Office- Microsoft Excel
- E.
Start-Program-Close
Correct Answer
D. Start-Program-Microsoft Office- Microsoft ExcelExplanation
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:
-
- 18.
Perintah yang digunakan mencari nilai dari suatu table pencarian pada baris yang ditentukan dengan metode mendatar adalah …
- A.
LOOKUP
- B.
MLOOKUP
- C.
HLOOKUP
- D.
VLOOKUP
- E.
FLOOKUP
Correct Answer
C. HLOOKUPExplanation
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:
-
- 19.
Perintah yang digunakan mencari nilai dari suatu table pencarian pada baris yang ditentukan dengan metode menurun adalah …
- A.
LOOKUP
- B.
MLOOKUP
- C.
HLOOKUP
- D.
VLOOKUP
- E.
FLOOKUP
Correct Answer
D. VLOOKUPExplanation
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:
-
- 20.
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 ....
- A.
=IF(D8>”50”,”Naik Kelas”,”Tinggal Kelas”)
- B.
=IF(D8>”50”,”Naik Kelas, Tinggal Kelas”)
- C.
=IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)
- D.
=IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)
- E.
IF(D8>50,”Naik Kelas”,”Tinggal Kelas”)
Correct Answer
D. =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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jul 22, 2024Quiz Edited by
ProProfs Editorial Team -
Dec 07, 2016Quiz Created by
Bahaduralay
Back to top