# Ujian Akhir Aplikasi Komputer Pend. Fisika Fkip Umm Makassar

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
I
Community Contributor
Quizzes Created: 1 | Total Attempts: 232
Questions: 24 | Attempts: 232  Settings  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)

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

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.

Rate this question:

• 3.

### To_unit dalam persamaan umum konversi adalah

• A.

Satuan awal

• B.

Satuan hasil

• C.

Angka yang akan dikonversi

• D.

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.

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)

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.

• A.

Jumlah baris dan kolom yang sama

• B.

• C.

• D.

Jumlah baris dan kolom yang mewakili cell data

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.

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

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.

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.

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.

Rate this question:

• 8.

• A.

=Mmult(A1-C3

• B.

=Mult(array1:array2)

• C.

=Mmult(array1;array2)

• D.

=Mmult(array)

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)

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

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.

Rate this question:

• 11.

• A.

Nilai rata-rata dari data

• B.

Nilai ratarata dari grafik

• C.

• D.

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

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.

Rate this question:

• 13.

### Mengubah sumbu vertical atau horizontal pada grafik dilakukan dengan mengubah

• A.

• B.

Format axis

• C.

• D.

Format gridlines

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."

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.

• 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.

=B1*sin(\$C\$1)

• C.

• D.

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.

• D.

Fungsi eksponen

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.

Rate this question:

• 17.

### Persamaan logaritma aLog bx dalam aplikasi excel a disebut

• A.

Base

• B.

Number

• C.

Array

• D.

Cell

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.

Rate this question:

• 18.

### Menambahkan angka-angka pada titik tertentu digrafik disebut

• A.

• B.

Format data labels

• C.

• D.

Format data series

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.

Rate this question:

• 19.

### Mengaktifkan menu developer dapat dilakukan dengan melalui

• A.

Developer

• B.

Home

• C.

Insert

• D.

Office Button

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.

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

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.

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

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.

Rate this question:

• 22.

### Mengeksekusi sebuah grafik menjadi simulasi kombinasi VBA dapat dilakukan dengan menekan

• A.

F2

• B.

F9

• C.

Macros

• D.

Visual basic

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.

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

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."

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 Back to top