1.
Bentuk
persamaan umum fungsi konversi adalah
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.
2.
=CONVERT(68;”yd”;”ft”) bertujuan untuk
Correct Answer
D. Konversi nilai 68 dari yard ke kaki
Explanation
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.
3.
To_unit dalam persamaan umum konversi adalah
Correct Answer
B. Satuan hasil
Explanation
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.
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
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.
5.
Bentuk
umum persamaan invers adalah =MINVERSE(array), array adalah
Correct Answer
D. Jumlah baris dan kolom yang mewakili cell data
Explanation
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.
6.
Diperoleh hasil invers pada baris dan kolom
pertama, maka pada baris dan kolom selanjutnya digunakan cara
Correct Answer
A. Blok A5:C7 lalu tekan F2 dan tekan Ctrl+Shift+Enter
Explanation
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.
7.
Rumus perkalian matriks (Lihat gambar di samping) Variabel b dan c pada MO Excel masing-masing
adalah
Correct Answer
A. Array 1 dan array 2
Explanation
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.
8.
Bentuk
umum persamaan perkalian matriks pada aplikasi excel adalah
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.
9.
Model grafik silinder, kerucut, pyramid adalah
model grafik dari grafik jenis
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.
10.
Membuat grafik XY dapat dilakukan dengan cara
Correct Answer
D. Insert-scatter
Explanation
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.
11.
Apa arti nilai y = 26,96x - 9,139 dari persamaan
add tradline pada suatu grafik
Correct Answer
D. Nilai grafik dengan persamaan tradline
12.
Perhatikan
gambar (yang ditunjukkan angka 1) bertujuan untuk
Correct Answer
B. Memilih jenis data untuk grafik
Explanation
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.
13.
Mengubah sumbu vertical atau horizontal pada
grafik dilakukan dengan mengubah
Correct Answer
B. Format axis
Explanation
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."
14.
Fungsi kuadrat dengan
persamaan y=2x2 + 10x + 5, dapat dituliskan dalam formula excel
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
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.
16.
Perhatikan gambar grafik
di samping ini, grafik tersebut
diperoleh data dari fungsi
Correct Answer
C. Fungsi pangkat kuadrat
Explanation
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.
17.
Persamaan logaritma aLog bx dalam
aplikasi excel a disebut
Correct Answer
A. Base
Explanation
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.
18.
Menambahkan
angka-angka pada titik tertentu digrafik disebut
Correct Answer
C. Add data labels
Explanation
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.
19.
Mengaktifkan
menu developer dapat dilakukan dengan melalui
Correct Answer
D. Office Button
Explanation
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.
20.
Persamaan
waktu (t) dapat dituliskan =0+0,1+posisi_cell, posisi cell adalah
Correct Answer
C. Cell waktu
Explanation
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.
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
Correct Answer
D. 5 m/s2
Explanation
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.
22.
Mengeksekusi
sebuah grafik menjadi simulasi kombinasi VBA dapat dilakukan dengan menekan
Correct Answer
C. Macros
Explanation
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.
23.
Fungsi
sinus dengan persamaan =sin(A11+beda_fase), jika beda fese adalah variabel yang
berubah-ubah datanya, maka persamaan beda fase dituliskan
Correct Answer
B. =0,2+0+Cell_beda_fase
Explanation
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."
24.
Jika
for n = 1 to 1000, dengan t =0,2+cell_waktu, maka simulasi berhenti jika t
mencapai angka
Correct Answer
C. 200
Explanation
The simulation will stop when the value of t reaches 200.