Latihan Soal MS Excel 2007 (Part 2)
Questions and Answers
- 1.
Untuk menghitung jumlah data dari suatu range menggunakan perintah ....
- A.
SUM
- B.
IF
- C.
MAX
- D.
AVERAGE
Correct Answer
A. SUMExplanation
The correct answer is SUM. The SUM function is used to calculate the total sum of a range of data. It adds up all the numbers in the specified range and returns the sum as the result. Therefore, if we want to find the total sum of a range of data, we can use the SUM function.Rate this question:
-
- 2.
Pada kolom yang berisi data angka bila kolomnya kurang lebar maka yang akan terjadi adalah data angka ditampilkan .....
- A.
Tidak tampak sama sekali
- B.
Berupa deretan tanda pagar (################)
- C.
Tampak sebagian
- D.
Tidak jelas
Correct Answer
B. Berupa deretan tanda pagar (################)Explanation
When the column that contains numerical data is not wide enough, the data will be displayed as a series of pound signs (################). This is a common way for software or spreadsheet programs to indicate that the data is too long to fit within the given column width.Rate this question:
-
- 3.
Untuk mengembalikan data pada satu sel dapat dilakukan dengan menekan tombol .....
- A.
Esc
- B.
Insert
- C.
Ctrl + Y
- D.
Ctrl + Z
Correct Answer
D. Ctrl + ZExplanation
To undo or revert the changes made in a cell, the correct key combination is Ctrl + Z. This combination is commonly used to undo the most recent action performed in various applications, including spreadsheet software like Excel. By pressing Ctrl + Z, the user can easily restore the previous data or content of a cell that was accidentally modified or deleted.Rate this question:
-
- 4.
Untuk menghapus karakter yang sudah kita ketik, bisa menggunakan tombol ....
- A.
Delete
- B.
Backspace
- C.
Esc
- D.
Tab
Correct Answer
B. BackspaceExplanation
Backspace is the correct answer because it is the key commonly used to delete the character to the left of the cursor in a text field or document. When pressed, the backspace key removes the character before the cursor, allowing the user to correct any typing mistakes or delete unwanted characters. The other options, such as Delete, Esc, and Tab, do not specifically perform the function of deleting the character to the left of the cursor.Rate this question:
-
- 5.
MIN, MAX, COUNT, dan AVERAGE termasuk dalam kelompok fungsi ....
- A.
Text
- B.
Logika
- C.
Statistik
- D.
Rujukan
Correct Answer
C. StatistikExplanation
MIN, MAX, COUNT, dan AVERAGE adalah fungsi-fungsi yang digunakan dalam statistik. Fungsi MIN digunakan untuk mencari nilai terkecil dalam kumpulan data, fungsi MAX digunakan untuk mencari nilai terbesar, fungsi COUNT digunakan untuk menghitung jumlah data, dan fungsi AVERAGE digunakan untuk mencari rata-rata dari kumpulan data. Oleh karena itu, mereka termasuk dalam kelompok fungsi statistik.Rate this question:
-
- 6.
Fungsi = LEFT ("BINARAGA", 4) akan menghasilkan kata ....
- A.
BINA
- B.
BINAR
- C.
NARA
- D.
NAGA
Correct Answer
A. BINAExplanation
The function LEFT("BINARAGA", 4) will extract the first 4 characters from the string "BINARAGA", which are "BINA".Rate this question:
-
- 7.
Lambang operator matematika untuk pangkat adalah .....
- A.
&
- B.
^
- C.
$
- D.
/
Correct Answer
B. ^Explanation
The symbol "^" is the mathematical operator for exponentiation or raising a number to a power. It is commonly used to indicate that a number is being multiplied by itself a certain number of times. For example, "2^3" means 2 raised to the power of 3, which is equal to 2 multiplied by itself 3 times, resulting in 8.Rate this question:
-
- 8.
Fungsi =MID("GLOBALISASI" ;4 ;4) akan menghasilkan kata ....
- A.
GLOBAL
- B.
ASI
- C.
BALI
- D.
BASI
Correct Answer
C. BALIExplanation
The MID function in Excel is used to extract a specific number of characters from a text string, starting at a specified position. In this case, the function is extracting 4 characters starting at the 4th position of the text string "GLOBALISASI". Therefore, the correct answer is "BALI", as it is the 4 characters starting from the 4th position in the given text.Rate this question:
-
- 9.
Fungsi yang menggunakan operator pembanding adalah .....
- A.
Statistik
- B.
Absolut
- C.
Matematika
- D.
Logika
Correct Answer
D. LogikaExplanation
The correct answer is "Logika" because logic is a branch of mathematics that deals with reasoning and the principles of valid reasoning. In logic, operators such as comparison operators (e.g., greater than, less than, equal to) are used to compare values and make logical decisions. Therefore, the function that uses comparison operators would fall under the realm of logic.Rate this question:
-
- 10.
Untuk mengambil sebanyak " n " data dari sebelah kanan adalah fungsi ....
- A.
LEFT
- B.
MID
- C.
CENTER
- D.
RIGHT
Correct Answer
D. RIGHTExplanation
The correct answer is RIGHT because the question is asking for a function that retrieves data from the right side. The RIGHT function in programming is used to extract a specified number of characters from the right side of a string. Therefore, it is the appropriate function for this situation.Rate this question:
-
- 11.
Untuk memformat tanggal, maka pada format Cell adalah ....
- A.
Date
- B.
Time
- C.
Percentage
- D.
Number
Correct Answer
A. DateExplanation
The correct answer is "Date" because to format a date in a cell, you need to select the "Date" format option. This will allow you to display the date in various formats such as day/month/year or month/day/year, depending on your preference.Rate this question:
-
- 12.
Untuk memperbaiki data suatu sel, selain dengan mengklik ganda sel tersebut, kita pun dapat menekan tombol .....
- A.
F4
- B.
F3
- C.
F2
- D.
F1
Correct Answer
C. F2Explanation
To fix the data in a cell, besides double-clicking on the cell, we can also press the F2 button.Rate this question:
-
- 13.
Penggunaan rumus/fungsi pada Microsoft Excel penulisannya didahului karakter .....
- A.
-
- B.
+
- C.
=
- D.
/
Correct Answer
C. =Explanation
The correct answer is "=" because in Microsoft Excel, the equal sign "=" is used to indicate that a cell contains a formula or function. This allows the program to recognize and calculate the formula or function entered in the cell.Rate this question:
-
- 14.
Berikut ini merupakan contoh penulisan rumus yang benar pada Microsoft Excel adalah .....
- A.
=MAX5+5
- B.
=$D$6*$E$6
- C.
/5+5
- D.
SUM=5+5
Correct Answer
B. =$D$6*$E$6Explanation
The correct answer is "=$D$6*$E$6". This is the correct way to write a formula in Microsoft Excel. The dollar signs before the column and row references indicate that the references are absolute, meaning they will not change when the formula is copied to other cells. The asterisk (*) is used to multiply the values in cells D6 and E6.Rate this question:
-
- 15.
Jika pada sebuah sel diisi rumus = 4^2*(4-2)+16/2 maka hasilnya adalah .....
- A.
40
- B.
37
- C.
25
- D.
13
Correct Answer
A. 40Explanation
The given formula can be simplified as follows: 4^2*(4-2)+16/2. First, we calculate the value inside the parentheses, which is 4-2 = 2. Then, we calculate the exponentiation, which is 4^2 = 16. Next, we multiply 16 by 2, resulting in 32. Finally, we add 32 to the division of 16 by 2, which is 8. Therefore, the final result is 32 + 8 = 40.Rate this question:
-
- 16.
Gambar berikut ini merupakan Daftar Nilai Siswa SMK Jaya Sampurna 45. Rumus untuk menentukan Jumlah Nilai Siswa adalah .....
- A.
=SUM(D5:D14)
- B.
=AVERAGE(D5:D14)
- C.
=SUM(D5+D14)
- D.
=COUNT(D5:D14)
Correct Answer
A. =SUM(D5:D14)Explanation
The correct answer is =SUM(D5:D14) because the SUM function is used to add up the values in a range of cells. In this case, the range is D5 to D14, which represents the values of the students' scores. By using the SUM function, the total sum of all the scores can be calculated accurately.Rate this question:
-
- 17.
Gambar berikut ini merupakan Daftar Nilai Siswa SMK Jaya Sampurna 45. Rumus untuk menentukan Nilai Maksimum Siswa adalah .....
- A.
=LEFT(D5:D14)
- B.
=MIN(D5:D15)
- C.
=SUM(D4+D5)
- D.
=MAX(D5:D14)
Correct Answer
D. =MAX(D5:D14)Explanation
The correct answer is =MAX(D5:D14). This formula calculates the maximum value from the range of cells D5 to D14. It will return the highest value among the list of student scores in the SMK Jaya Sampurna 45.Rate this question:
-
- 18.
Gambar berikut ini merupakan Daftar Nilai Siswa SMK Jaya Sampurna 45. Rumus untuk menentukan Rata- Rata Nilai Siswa adalah .....
- A.
=SUM(D5:D14)
- B.
=AVERAGE(D5:D14)
- C.
=MAX(D5:D14)
- D.
=COUNT(D5:D14)
Correct Answer
B. =AVERAGE(D5:D14)Explanation
The correct answer is =AVERAGE(D5:D14). This is because the formula AVERAGE(D5:D14) calculates the average of the values in cells D5 to D14. In the given context, the formula is used to determine the average value of the students' scores in SMK Jaya Sampurna 45. The SUM formula calculates the total sum of the values, the MAX formula finds the highest value, and the COUNT formula counts the number of values in the range. However, in this case, the question specifically asks for the average, so the AVERAGE formula is the correct choice.Rate this question:
-
- 19.
Gambar berikut ini merupakan Daftar Nilai Siswa SMK Jaya Sampurna 45. Rumus untuk menentukan Jumlah Siswa Laki-Laki adalah .....
- A.
=SUM(D5:D14; "LAKI-LAKI")
- B.
=COUNT(D5:D14; "LAKI-LAKI")
- C.
=COUNTIF(C5:C14; "LAKI-LAKI")
- D.
=SUMIF(D5:D14; "LAKI-LAKI')
Correct Answer
C. =COUNTIF(C5:C14; "LAKI-LAKI")Explanation
The correct answer is =COUNTIF(C5:C14; "LAKI-LAKI"). This formula counts the number of cells in the range C5:C14 that contain the value "LAKI-LAKI", which represents male students. Therefore, it calculates the total number of male students in the SMK Jaya Sampurna 45.Rate this question:
-
- 20.
Gambar berikut ini merupakan Daftar Nilai Siswa SMK Jaya Sampurna 45. Rumus untuk menentukan Jumlah Nilai Siswa Laki- Laki adalah .....
- A.
=SUM(D5:D14; "LAKI-LAKI")
- B.
=COUNT(D5:D14; "LAKI-LAKI")
- C.
=COUNT(C5:C14; "LAKI-LAKI"; D5:D14)
- D.
=SUMIF(C5:C14; "LAKI-LAKI"; D5:D14)
Correct Answer
D. =SUMIF(C5:C14; "LAKI-LAKI"; D5:D14)Explanation
The correct answer is =SUMIF(C5:C14; "LAKI-LAKI"; D5:D14). This formula calculates the sum of the values in the range D5:D14, but only includes the values where the corresponding cells in the range C5:C14 contain "LAKI-LAKI". In other words, it sums up the values of male students' scores.Rate this question:
-
- 21.
Perintah Page Setup, dijalankan dari menu ...
- A.
Home
- B.
Insert
- C.
Page Layout
- D.
View
Correct Answer
C. Page LayoutExplanation
The correct answer is "Page Layout" because the Page Setup command is typically found in the Page Layout menu. This command allows users to adjust the settings and layout of the page, such as adjusting margins, paper size, orientation, and adding headers and footers.Rate this question:
-
- 22.
Mengatur tanda rupiah (Rp) untuk data yang berupa uang dilakukan di kotak dialog .....
- A.
Option
- B.
Format Cells
- C.
Print
- D.
Page Setup
Correct Answer
B. Format CellsExplanation
The correct answer is "Format Cells" because this option allows the user to customize the appearance of the data, including adding the currency symbol for money values. By selecting "Format Cells," the user can access various formatting options, such as choosing the currency format and specifying the currency symbol to be displayed as "Rp" for Indonesian rupiah.Rate this question:
-
- 23.
Selain dengan cara drag and drop.memindahkan data dapat juga dilakukan dengan cara menjalankan perintah .....
- A.
Print & Copy
- B.
Copy & Paste
- C.
Cut & Paste
- D.
Select all & Cut
Correct Answer
C. Cut & PasteExplanation
Cut & Paste is the correct answer because it is mentioned in the question that data can be moved by running a command, and Cut & Paste is a command that allows users to move data from one location to another. It involves selecting the data, cutting it from its original location, and then pasting it into the desired location. This method is commonly used to move files, text, or other types of data within a computer system.Rate this question:
-
- 24.
Perintah yang digunakan untuk menggandakan data adalah ....
- A.
Copy & Paste
- B.
Cut & Paste
- C.
Copy & Cut
- D.
Select all & Paste
Correct Answer
A. Copy & PasteExplanation
The correct answer is Copy & Paste. This command allows users to duplicate data by copying it from one location and pasting it into another location. It is a common feature in most software applications and is used to easily replicate information without having to retype or recreate it.Rate this question:
-
- 25.
Perintah open dapat dijalankan dari menu file dan tombol open di toolbar standar.selain itu, perintah open dapat juga dijalankan dengan menekan tombol…dikeyboard.
- A.
Ctrl + V
- B.
Ctrl + S
- C.
Ctrl + P
- D.
Ctrl + O
Correct Answer
D. Ctrl + OExplanation
The correct answer is Ctrl + O. The explanation for this is that the given statement mentions that the "open" command can be executed by pressing a button on the keyboard. Among the options provided, Ctrl + O is the only combination that includes the letter "O" and the Ctrl key. Therefore, Ctrl + O is the correct answer.Rate this question:
-
- 26.
Untuk mengubah nama sheet pada menu format pilih sub menu .....
- A.
Sheet, Delete
- B.
Sheet, Rename
- C.
Sheet, Background
- D.
Sheet, Unhide
Correct Answer
B. Sheet, RenameExplanation
To change the name of a sheet in the format menu, you need to select the sub menu "Sheet, Rename". This option allows you to change the name of the sheet to something more meaningful or descriptive.Rate this question:
-
- 27.
Tombol untuk memindahkan lembar kerja dari sheet 1 ke sheet 2 tekan tombol ….
- A.
Ctrl + PgDn
- B.
Shift + PgDn
- C.
Ctrl + PgUp
- D.
Shift + PgUp
Correct Answer
A. Ctrl + PgDnExplanation
Pressing Ctrl + PgDn is the correct answer because it is the shortcut key combination used to move the worksheet from sheet 1 to sheet 2. Ctrl + PgDn is a commonly used keyboard shortcut in spreadsheet software like Microsoft Excel to navigate between worksheets in a workbook.Rate this question:
-
- 28.
Perintah untuk menggabungkan beberapa sel yang berdekatan dan data yang akan diformat rata tengah adalah ..........
- A.
Align Left
- B.
Wrap Text
- C.
Merge and Center
- D.
Align Right
Correct Answer
C. Merge and CenterExplanation
The correct answer is "Merge and Center". This command is used to combine multiple adjacent cells and format the data in the middle. It is commonly used to create headings or labels that span across multiple columns in a spreadsheet. By using this command, the content of the selected cells will be merged into one cell and aligned in the center.Rate this question:
-
- 29.
Perintah untuk memformat angka dengan menggunakan menu format cell lalu pilih ....
- A.
Font
- B.
Date
- C.
Currency
- D.
Number
Correct Answer
D. NumberExplanation
The correct answer is "Number" because selecting the "Number" option in the format cell menu allows for formatting numbers in various ways, such as displaying decimal places, adding a thousands separator, or using a specific currency symbol. This option is used when you want to format cells containing numerical data.Rate this question:
-
- 30.
Berikut ini tombol yang dapat digunakan untuk menggeser sel yang aktif adalah .....
- A.
Tombol Tab
- B.
Tombol Enter
- C.
Tombol Arah
- D.
Semua Benar
Correct Answer
D. Semua BenarExplanation
The correct answer is "Semua Benar" which means "All Correct" in English. This means that all of the options provided (Tombol Tab, Tombol Enter, Tombol Arah) can be used to shift the active cell.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
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
May 15, 2016Quiz Created by
Gedeaksama
Back to top