Ujian Akhir Aplikasi Komputer Pend. Fisika Fkip Umm Makassar
Bacalah petunjuk mengerjakan soal online ini dengan baik dan teliti1. Tuliskan Nama Lengkap Anda pada kotak Your Name (di bawah) lalu tekan Enter2. Bacalah baik-baik soal sebelum memberikan jawaban3. Silahkan klik pada pilihan jawaban yang menurut Anda benar 4. Jika merubah jawaban silahkan klik jawaban lain yang menurut Anda benar5. Selesai memberikan jawaban tekan Submit My Answer untuk lanjut ke soal berikutnya6. Setelah memasukkan jawaban soal selanjutnya muncul, klik +View Answer untuk melihat soal sebelumnya7. Jika telah mengerjakan soal secara kesuluruhan maka akan ada informasi hasil ujian Anda
- 1.
Bentuk persamaan umum fungsi konversi adalah
- A.
=CONVERT(number;from_unit;to_unit)
- B.
= CONVERT(from_unit; number;to_unit)
- C.
= CONVERT(number;to _unit;from _unit)
- D.
= CONVERT(from_unit;to_unit)
Correct Answer
A. =CONVERT(number;from_unit;to_unit)Explanation
The correct answer is =CONVERT(number;from_unit;to_unit). This is because the given equation follows the standard format for the CONVERT function, where "number" represents the value to be converted, "from_unit" represents the unit of measurement of the original value, and "to_unit" represents the unit of measurement to which the value should be converted. The semicolons (;) are commonly used as separators in spreadsheet formulas.Rate this question:
-
- 2.
=CONVERT(68;”yd”;”ft”) bertujuan untuk
- A.
Konversi nilai 68 dari kaki ke yard
- B.
Konversi nilai 68 dari yard ke inch
- C.
Konversi nilai 68 dari pica ke inch
- D.
Konversi nilai 68 dari yard ke kaki
Correct Answer
D. Konversi nilai 68 dari yard ke kakiExplanation
The correct answer is "Konversi nilai 68 dari yard ke kaki." This is because the CONVERT function is used to convert a value from one unit of measurement to another. In this case, the function is converting 68 yards to feet. Since the question asks for the conversion from yards to feet, this is the correct answer.Rate this question:
-
- 3.
To_unit dalam persamaan umum konversi adalah
- A.
Satuan awal
- B.
Satuan hasil
- C.
Angka yang akan dikonversi
- D.
Tidak ada jawaban yang benar
Correct Answer
B. Satuan hasilExplanation
The correct answer is "Satuan hasil." In the general conversion equation, the "to_unit" refers to the unit in which the conversion is being made, or the unit in which we want the final result to be expressed. This is the unit that we are trying to convert to. The "from_unit" refers to the initial unit or the unit in which the value is given. So, the "Satuan hasil" or the "to_unit" is the correct answer as it represents the unit in which we want the final result of the conversion.Rate this question:
-
- 4.
=A1*(B2*C3-B3*C2)+A2*(B3*C1-B1*C3)+A3*(B1*C2-B2*C1) digunakan untuk menghitung nilai determinan, dalam formula excel dituliskan
- A.
Mdetermn(A1;C3)
- B.
Mdetermn(A1:C3)
- C.
Mdetermn(A:C)
- D.
Mdetermn(A1-C3)
Correct Answer
B. Mdetermn(A1:C3)Explanation
The given correct answer, "Mdetermn(A1:C3)", is the correct formula to calculate the determinant of a 3x3 matrix in Excel. The formula calculates the determinant by multiplying the elements of the first row (A1, B1, C1) by the cofactors of their respective minors (B2*C3-B3*C2), (B3*C1-B1*C3), and (B1*C2-B2*C1), and then summing these products. The formula "Mdetermn(A1:C3)" specifies that the determinant is to be calculated for the range of cells A1 to C3.Rate this question:
-
- 5.
Bentuk umum persamaan invers adalah =MINVERSE(array), array adalah
- A.
Jumlah baris dan kolom yang sama
- B.
Jumlah baris pada cell tertentu
- C.
Umlah kolom pada cell tertentu
- D.
Jumlah baris dan kolom yang mewakili cell data
Correct Answer
D. Jumlah baris dan kolom yang mewakili cell dataExplanation
The correct answer is "Jumlah baris dan kolom yang mewakili cell data" because the MINVERSE function in Excel is used to find the inverse of a matrix. The array argument in the MINVERSE function should be a square matrix, which means it should have an equal number of rows and columns. Therefore, the number of rows and columns in the array should represent the number of cells in the data.Rate this question:
-
- 6.
Diperoleh hasil invers pada baris dan kolom pertama, maka pada baris dan kolom selanjutnya digunakan cara
- A.
Blok A5:C7 lalu tekan F2 dan tekan Ctrl+Shift+Enter
- B.
Blok B5:C7 lalu tekan F2 dan tekan Ctrl+Shift+Enter
- C.
Blok A5:C7 lalu tekan Ctrl+Shift+Enter dan tekan F2
- D.
Blok B5:C7 lalu tekan Ctrl+Shift+Enter dan tekan F2
Correct Answer
A. Blok A5:C7 lalu tekan F2 dan tekan Ctrl+Shift+EnterExplanation
The correct answer is "Blok A5:C7 lalu tekan F2 dan tekan Ctrl+Shift+Enter". This answer suggests that in order to obtain the inverse result on the first row and column, the user should select the range A5:C7, press F2 to enter edit mode, and then press Ctrl+Shift+Enter to apply the inverse calculation.Rate this question:
-
- 7.
Rumus perkalian matriks (Lihat gambar di samping) Variabel b dan c pada MO Excel masing-masing adalah
- A.
Array 1 dan array 2
- B.
Jumlah baris dan kolom
- C.
Hasil perkalian matriks
- D.
Tidak ada jawaban yang benar
Correct Answer
A. Array 1 dan array 2Explanation
The correct answer is "Array 1 dan array 2". This is because the question is asking for the variables b and c in MO Excel, and the options provided are Array 1 and Array 2. Therefore, the correct answer is the options that match the variables being asked for.Rate this question:
-
- 8.
Bentuk umum persamaan perkalian matriks pada aplikasi excel adalah
- A.
=Mmult(A1-C3
- B.
=Mult(array1:array2)
- C.
=Mmult(array1;array2)
- D.
=Mmult(array)
Correct Answer
C. =Mmult(array1;array2)Explanation
The correct answer is =Mmult(array1;array2). This is because the question is asking for the general form of the matrix multiplication equation in Excel, and the correct answer represents the correct syntax for multiplying two arrays in Excel using the MMULT function. The semicolon (;) is used as the delimiter between the two arrays, indicating that they should be multiplied together.Rate this question:
-
- 9.
Model grafik silinder, kerucut, pyramid adalah model grafik dari grafik jenis
- A.
Grafik garis (line chart)
- B.
Grafik kue (pie chart)
- C.
Grafik area (area chart)
- D.
Grafik kolom (stacked column chart)
Correct Answer
D. Grafik kolom (stacked column chart)Explanation
The correct answer is "Grafik kolom (stacked column chart)" because the question asks for the model of the cylinder, cone, and pyramid. Out of the given options, the stacked column chart is not related to these shapes, so it is the correct answer.Rate this question:
-
- 10.
Membuat grafik XY dapat dilakukan dengan cara
- A.
Insert-shapes
- B.
Insert-table
- C.
Insert-symbol
- D.
Insert-scatter
Correct Answer
D. Insert-scatterExplanation
The correct answer is "Insert-scatter" because creating an XY graph involves plotting points on a graph to represent data. The scatter plot is a type of graph that displays individual data points as dots on the graph, with one variable plotted on the x-axis and the other variable plotted on the y-axis. Therefore, inserting a scatter plot is the appropriate method for creating an XY graph.Rate this question:
-
- 11.
Apa arti nilai y = 26,96x - 9,139 dari persamaan add tradline pada suatu grafik
- A.
Nilai rata-rata dari data
- B.
Nilai ratarata dari grafik
- C.
Nilai rata-rata data pada grafik
- D.
Nilai grafik dengan persamaan tradline
Correct Answer
D. Nilai grafik dengan persamaan tradline -
- 12.
Perhatikan gambar (yang ditunjukkan angka 1) bertujuan untuk
- A.
Memilih jenis grafik
- B.
Memilih jenis data untuk grafik
- C.
Memilih data sekaligus grafik
- D.
Memilih jenis grafik sesuai dengan data
Correct Answer
B. Memilih jenis data untuk grafikExplanation
The correct answer is "Memilih jenis data untuk grafik" because the image shown in the question is a selection of different types of data. It is not about selecting a specific type of chart or graph, but rather about choosing the appropriate data to be represented in a graph.Rate this question:
-
- 13.
Mengubah sumbu vertical atau horizontal pada grafik dilakukan dengan mengubah
- A.
Add minor gridlines
- B.
Format axis
- C.
Add mayor gridlines
- D.
Format gridlines
Correct Answer
B. Format axisExplanation
To change the vertical or horizontal axis on a graph, you need to format the axis. This involves adjusting the settings and appearance of the axis, such as the scale, labels, and tick marks. The other options listed, such as adding minor or major gridlines or formatting gridlines, do not directly relate to changing the axis itself. Therefore, the correct answer is "Format axis."Rate this question:
-
- 14.
Fungsi kuadrat dengan persamaan y=2x2 + 10x + 5, dapat dituliskan dalam formula excel
- A.
=$B$1*B4*B4+$B$2*B4+$B$3
- B.
=(2*B4^2)+(B2*10)+(5)
- C.
=(B1*B4^2)+(B2*B4)+(B3)
- D.
Semua jawaban adalah benar
Correct Answer
D. Semua jawaban adalah benar -
- 15.
Fungsi sinus sudut trigonometri dengan persamaan y=a Sin x, dengan a pada cell B1 (nilai tetap) dan nilai x mulai dari sudut 0, 15, … 90 pada cell C1. Dalam formula excel fungsi y dituliskan
- A.
=$B$1*sin(Radians($C$1))
- B.
=B1*sin($C$1)
- C.
=$B$1*Radians(C1)
- D.
=$B$1*sin(Radians(C1))
Correct Answer
D. =$B$1*sin(Radians(C1))Explanation
The given formula, =$B$1*sin(Radians(C1)), calculates the value of the trigonometric function sine for the angle C1 in radians. The Radians function is used to convert the angle from degrees to radians, and the value of a is taken from cell B1. The formula multiplies the value of a with the sine of the angle C1 in radians, giving the result for the function y.Rate this question:
-
- 16.
Perhatikan gambar grafik di samping ini, grafik tersebut diperoleh data dari fungsi
- A.
Fungsi linear
- B.
Fungsi trigonometri
- C.
Fungsi pangkat kuadrat
- D.
Fungsi eksponen
Correct Answer
C. Fungsi pangkat kuadratExplanation
The correct answer is "Fungsi pangkat kuadrat" because the graph shown in the image resembles a quadratic function. A quadratic function is a type of power function where the highest power of the variable is 2. It has a U-shaped graph and can be represented by an equation of the form y = ax^2 + bx + c.Rate this question:
-
- 17.
Persamaan logaritma aLog bx dalam aplikasi excel a disebut
- A.
Base
- B.
Number
- C.
Array
- D.
Cell
Correct Answer
A. BaseExplanation
The correct answer is "Base." In logarithmic equations, the base represents the number that is raised to a certain power to produce a given value. In the equation aLog bx, the base is represented by the letter "a." Therefore, in the context of using logarithmic functions in Excel, the term "base" refers to the number that is being raised to a power.Rate this question:
-
- 18.
Menambahkan angka-angka pada titik tertentu digrafik disebut
- A.
Add trendline
- B.
Format data labels
- C.
Add data labels
- D.
Format data series
Correct Answer
C. Add data labelsExplanation
Adding data labels to a graph refers to the act of including numerical values or labels at specific points on the graph. This helps in providing a clear representation of the data and makes it easier for the audience to interpret the information. It allows for a more precise understanding of the graph and enhances its visual appeal.Rate this question:
-
- 19.
Mengaktifkan menu developer dapat dilakukan dengan melalui
- A.
Developer
- B.
Home
- C.
Insert
- D.
Office Button
Correct Answer
D. Office ButtonExplanation
The correct answer is "Office Button" because it is the option that allows the user to activate the developer menu. The other options mentioned (Developer, Home, Insert) are not relevant to activating the developer menu.Rate this question:
-
- 20.
Persamaan waktu (t) dapat dituliskan =0+0,1+posisi_cell, posisi cell adalah
- A.
Cell lain
- B.
Cell baru
- C.
Cell waktu
- D.
Cell gelombang
Correct Answer
C. Cell waktuExplanation
The equation for time (t) can be written as 0 + 0.1 + posisi_cell, where posisi_cell represents the position of the cell. The correct answer, "Cell waktu," means "time cell" in English. This suggests that the equation is referring to a specific cell that represents time.Rate this question:
-
- 21.
Benda bergerak dengan kecepatan 5 m/s, setelah waktu ke-5 dengan persamaan waktu (t) =0+0,2+posisi_cell sekon, maka percepatan benda adalah
- A.
50 m/s2
- B.
O,5 m/s2
- C.
5 m/s
- D.
5 m/s2
Correct Answer
D. 5 m/s2Explanation
The given equation for time (t) indicates that the position of the object is changing by 0.2 meters per second every second. This indicates that the object is experiencing a constant acceleration of 0.2 m/s^2. Therefore, the correct answer is 5 m/s^2.Rate this question:
-
- 22.
Mengeksekusi sebuah grafik menjadi simulasi kombinasi VBA dapat dilakukan dengan menekan
- A.
F2
- B.
F9
- C.
Macros
- D.
Visual basic
Correct Answer
C. MacrosExplanation
The correct answer is "Macros". To execute a graph as a VBA simulation, you can use macros. Macros are a set of instructions or commands that automate tasks in Microsoft Excel. By creating a macro, you can record a series of actions and then play them back later to save time and effort. In this case, by using macros, you can execute the graph and transform it into a VBA simulation.Rate this question:
-
- 23.
Fungsi sinus dengan persamaan =sin(A11+beda_fase), jika beda fese adalah variabel yang berubah-ubah datanya, maka persamaan beda fase dituliskan
- A.
=0+0,1
- B.
=0,2+0+Cell_beda_fase
- C.
=0+cell_beda_fese
- D.
=cell_beda_fase
Correct Answer
B. =0,2+0+Cell_beda_faseExplanation
The given answer is the correct explanation because it accurately represents the equation for the sinus function with a changing phase difference. It shows that the phase difference is equal to the sum of 0.2, 0, and the variable "Cell_beda_fase." Therefore, the answer is "=0.2+0+Cell_beda_fase."Rate this question:
-
- 24.
Jika for n = 1 to 1000, dengan t =0,2+cell_waktu, maka simulasi berhenti jika t mencapai angka
- A.
50
- B.
100
- C.
200
- D.
2.000
Correct Answer
C. 200Explanation
The simulation will stop when the value of t reaches 200.Rate this question:
-
Back to top