Latihan Soal Pengolah Angka

The correct answer is "/". The division operator ("/") is used in arithmetic operations to divide one number by another.

The correct answer is "menutup jendela dan keluar dari Ms Excel." This is because the "X" button in Microsoft Excel is commonly used to close the window and exit the program. By clicking on this button, the user can effectively close the Excel window and end their session in the program.

The correct answer is "min" because the "min" function is used to find the lowest value within a given range. It compares all the values in the range and returns the smallest value among them.

The given statement is incorrect. The correct explanation is that the function max is used to find the largest value within a range, not the smallest value. Therefore, the answer is False.

The given correct answer is true. The explanation for this is that the function "sum" is indeed used to add or sum up a series of numbers or elements. It is a built-in function in many programming languages that takes an iterable (such as a list or tuple) as input and returns the sum of all the elements in that iterable. Therefore, the statement "Fungsi sum adalah untuk menjumlahkan" translates to "The sum function is used for adding up."

The correct answer is 17. This can be determined by following the order of operations in mathematics, which states that multiplication should be done before addition. In the given equation, 3*3 is equal to 9. Adding 8 to 9 gives a final result of 17.

The correct answer is "data tabel, data base penghitungan rumus, dan grafik". This is because Excel is commonly used for organizing and analyzing data in tabular form, performing calculations using formulas and functions, and creating visual representations of data through charts and graphs.

If you write the formula (60+80/2), the result is 100. This is because the formula follows the order of operations, which states that you should perform the division before the addition. Therefore, 80 divided by 2 equals 40, and when you add 60 to 40, you get 100.

The caret symbol (^) represents the exponentiation operation in arithmetic. It is used to raise a number to a certain power. For example, 2^3 means 2 raised to the power of 3, which is equal to 8. Therefore, the correct answer is ^.

The given expression is 12-4*3. According to the order of operations (PEMDAS/BODMAS), multiplication should be done before subtraction. So, 4*3 equals 12. Therefore, the expression simplifies to 12-12, which equals 0.

Pressing the Ctrl + C shortcut key combination is equivalent to clicking on the "Edit" menu and then selecting the "Copy" option.

The statement is true because a worksheet in Excel consists of 65,536 rows and 256 columns. This means that you can input data, perform calculations, and organize information in a table-like format with this number of rows and columns.

The given options are Quattro Pro, Lotus 123, Microsoft Word, and Microsoft Excel. The question asks for the program that is not a number processor. Quattro Pro and Lotus 123 are both spreadsheet programs used for number processing and data analysis. Microsoft Excel is also a spreadsheet program, specifically designed for number processing. However, Microsoft Word is a word processing program used for creating and editing documents, and it is not primarily used for number processing. Therefore, Microsoft Word is the correct answer.

The correct answer is "sum." In mathematics, the term "sum" refers to the action of adding together a range of numbers or values. In this context, the function is used to calculate the total sum of the range. Therefore, "sum" is the appropriate choice for this question.

The correct answer is "sumif". The question is asking for the function used in mathematics to sum a range with specific criteria. The "sumif" function in mathematics allows you to specify a range and a criteria, and it will sum only the values that meet that criteria.

The correct answer is "shift + ↓". This keyboard shortcut is commonly used in spreadsheet programs like Microsoft Excel to select and move the cursor one cell down. By holding down the shift key and pressing the downward arrow key, the user can select a range of cells from the current cell to the cell below it. This shortcut is useful for quickly navigating and selecting data in a spreadsheet.

A file or document that consists of sheets or pages is called a workbook. This term is commonly used in computer applications such as Microsoft Excel, where a workbook refers to a collection of worksheets or spreadsheets. It is used to organize and store data in a structured manner, allowing users to perform calculations, analyze data, and create reports.

The correct answer is "general". This is because the "general" format is used to display numbers in their original format, without any specific formatting rules applied. This format is commonly used when you want to display numbers as they are, without any additional styling or formatting.

Ms. Excel is not a software for data processing. It is actually a software for spreadsheet creation and analysis. It is commonly used for tasks such as creating tables, charts, and formulas for data analysis and presentation. Therefore, the correct answer is False.

The given statement is false. "Range" is not a collection of columns. It is a collection of values that meet certain criteria or conditions. In Excel, for example, the range refers to a group of cells, not columns. Therefore, the statement is incorrect.