Latihan Soal MS Excel 2007 (Part 2)

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The function LEFT("BINARAGA", 4) will extract the first 4 characters from the string "BINARAGA", which are "BINA".

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

To fix the data in a cell, besides double-clicking on the cell, we can also press the F2 button.

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.

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.

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.

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.

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.