Modul 5 "Mengopersikan Perangkat Lunak Pengolah Angka"

The correct answer is "Accounting" because the question asks for the tab in the format cell number dialog box that allows the user to add the symbol Rp. to indicate the currency value. The "Accounting" tab in the format cell number dialog box provides options for formatting numbers as currency, including adding currency symbols.

To activate the program Ms. Excel, the correct way is to click on the Start menu, then go to the Program folder, and select Ms. Excel from the list of available programs.

The correct answer is "c" because the question is asking for the tools used to combine multiple cells into one cell. The options provided are a, b, c, d, and e. Since option c is the only one mentioned in the question, it is the correct answer.

To change the paper size to A4, the correct command to use is "Page Setup". This command allows you to adjust various settings related to the page layout, including the paper size, margins, and orientation. By selecting "Page Setup", you can specify that you want to use A4 as the paper size for your document.

The correct answer is F4. F4 is the function key that is used to lock or freeze a column in a spreadsheet. This feature is commonly used in spreadsheet programs like Microsoft Excel to keep a specific column visible while scrolling through the rest of the data. By pressing F4, users can easily freeze a column and keep it in view, making it easier to compare data or reference information in the spreadsheet.

The correct answer is "Delete". This button is used to remove or delete a selected cell or content in a document or spreadsheet. It is commonly found on keyboards and can be used to delete text, images, or any other element within a file.

The correct answer is "= A3 * B3" because the question states that the value in cell A3 is 8 and the value in cell B3 is 9, and the operation to be performed is multiplication. In Excel, the formula for multiplication is using the asterisk symbol (*), so the correct formula to calculate the multiplication of the values in A3 and B3 is "= A3 * B3".

The correct answer is "Column". The Format à Column à Width option is used to change the width of columns in a document or spreadsheet. This option allows the user to adjust the size of columns to better fit the content or to create a more organized layout. By changing the width of columns, the user can ensure that the text or data is displayed in a visually appealing and easily readable manner.

The symbol "^" is used to represent the power or exponentiation operation in Ms. Excel. This means that if you want to raise a number to a certain power, you can use the "^" symbol. For example, if you want to calculate 2 raised to the power of 3, you would write it as "2^3" in Excel.

The correct answer is "Landscape" because when printing with the paper orientation set to horizontal, the image or document will be printed in landscape mode. This means that the width of the paper will be greater than its height, allowing for a wider view of the content.

The correct answer is 256 kolom dan 65536 baris. This is because the question is asking for the number of columns and rows in the workbook, and this option states that there are 256 columns and 65536 rows.

The correct answer is F2. F2 is the function key that is used to edit the contents of a cell in Microsoft Excel. When a cell is selected, pressing F2 allows the user to enter the edit mode and make changes to the cell's content. This key is commonly used for correcting errors or updating data in a spreadsheet.

The correct answer is RANK because it is the function that can be used to fill the "PERINGKAT" column in the table. The RANK function calculates the rank of a number in a list of numbers, based on its value. It can be used to determine the position of each value in the "PERINGKAT" column based on their values in the table.

The correct answer is COUNT. COUNT function is used to calculate the number of cells in a range that contains numbers or dates. It does not include empty cells or cells that contain text or logical values.

Microsoft Outlook is not a spreadsheet software, but rather an email and personal information management program. Lotus 123, Microsoft Excel, and Open Office.org Calc are all examples of spreadsheet software used for processing numbers and data. Therefore, the correct answer is Microsoft Outlook.

The correct answer is "Perataan" because the command "Format - Cell - Alignment" is used to adjust the alignment of the content within a cell in a spreadsheet or document. This command allows users to align the text or numbers in a cell to the left, right, or center, as well as vertically align the content to the top, bottom, or middle of the cell. It helps in making the data more organized and visually appealing.

The correct answer is "Klik Tools - Options - Gridlines - Ok". This is because the question is asking for the correct command to display or hide gridlines. The option "Tools - Options" is commonly used in software applications to access settings and preferences. By selecting "Gridlines" within the "Options" menu and clicking "Ok", the user can toggle the display of gridlines on or off.

The given options consist of logical operators and symbols. The symbols "=", ">=", and "<=" are comparison operators used to compare two values. The symbol "+" is an arithmetic operator used to perform addition. Therefore, the correct answer is "+", as it is not a logical operator but an arithmetic operator.

The given answer is % because it is not a mathematical operation used in Ms. Excel. The operations listed in the question, such as +, -, *, ^, and %, are all commonly used in Excel for addition, subtraction, multiplication, exponentiation, and percentage calculations. However, the % symbol is not used as an operation in Excel. Instead, it is used to represent percentages or to calculate percentages using formulas.

The correct answer is =IF(B6>=60, "LULUS","GAGAL"). This formula checks if the value in cell B6 is greater than or equal to 60. If it is, it returns "LULUS", indicating that the condition for passing is met. If it is not, it returns "GAGAL", indicating that the condition for failing is met.