Kelas Xi Semester 2: MS. Excel

The correct answer is "Menu toolbar." The given image represents a toolbar, which is a graphical control element on a computer screen that contains buttons or icons that allow users to perform specific actions or access certain functions. It is usually located at the top of a window or application and provides quick access to commonly used features or commands.

The correct answer is "Untuk melihat tampilan sebelum dicetak" which translates to "To preview the printout before printing". This means that the submenu "print preview" allows the user to see how the document will look like when it is printed, enabling them to make any necessary adjustments or corrections before actually printing it.

To change the name of sheet 2 to "ulangan", the correct command is to right-click on the tab for sheet 2, select and click on "rename", then type "ulangan" and click "OK".

The correct answer is "Kolom kurang lebar" which means "Column is too narrow" in English. This suggests that the issue with the cell marked with "#" is that the column width is not wide enough to display the entire content of the cell.

Microsoft Excel is a program application that is commonly used in daily life for various purposes. One of its main functions is to create and manage spreadsheets, which allows users to organize and analyze data in a tabular format. Spreadsheets are commonly used for tasks such as budgeting, financial analysis, data tracking, and creating charts and graphs. Therefore, the correct answer is "Spreedsheet."

The given image represents a pull-down menu for inserting options. This type of menu is typically found in software applications and allows users to access various options for inserting different elements or objects into a document or interface. The pull-down feature allows for a compact and organized display of options, making it easier for users to navigate and select the desired option.

The correct answer is "format, row, height". This is because to adjust the row height in a table, we use the "format" command, followed by specifying "row" as the element we want to format, and then setting the desired "height" for the row.

The correct answer is "Stock" because the question is asking for the active worksheet, and "Stock" is the only option that can be an active worksheet. The other options are unrelated to worksheets or could potentially be worksheets, but without further context, it is not possible to determine if they are active or not.

The correct answer is "Accounting" because this format is specifically used to display currency symbols. The Accounting format is designed to align currency symbols and decimal points in a column, making it easier to read and compare monetary values. This format is commonly used in financial statements and reports where accuracy and consistency in displaying currency symbols are crucial.

The correct answer is "Column". Column charts are used to compare quantities or show changes over time. They are vertical bars that represent different categories or groups. Each bar's height represents the value or quantity being measured. In this case, to create a bar chart, the column type is selected.

The given correct answer is "Border". This suggests that the question is asking for a term that is related to drawing a border. Out of the options provided, "Border" is the most appropriate term as it directly relates to creating a border around an object or element in a design or document.

The function =RIGHT(B12;4) extracts the rightmost 4 characters from the text in cell B12. In this case, the text in cell B12 is "/D10". Therefore, the correct answer is "/D10".

To remove gridlines in MS Excel, you need to click on the "Tools" menu, then select "Options". In the "Options" window, go to the "View" tab and uncheck the "Gridlines" option. This will remove the gridlines from the Excel sheet.

The correct answer is C21. This indicates that cell C21 is the active cell.

The answer 1250000 is the correct choice because it is the only option that matches the given description "Angka lebih dari 6 digit" (Number more than 6 digits). The other options, 340000 and Tidak ada data, do not meet this criteria.

The correct answer is "Pertemuan beberapa sel yang berbentuk persegi panjang." This answer suggests that a range refers to the intersection of multiple rectangular-shaped cells in a worksheet. A range can be a group of cells selected together to perform a specific operation or to apply formatting changes.

The correct answer is "Data tersebut absolut terhadap kolom." This means that the formula in cell A1 is fixed or absolute with respect to the column. This means that if the formula is copied or dragged to other cells horizontally, the column reference in the formula will not change. Only the row reference will change if the formula is copied or dragged vertically.

The correct answer is "File" because the menu options listed are commonly found in software applications, and "File" is typically the menu where options related to document settings, such as page margins and paper size, are located.

The explanation for the correct answer "Baris kurang tinggi" is that the row height of B4 and C4 is not sufficient to display the content properly. This means that the text in those cells may be cut off or not fully visible. To fix this issue, the row height needs to be increased to accommodate the content in those cells.

The correct answer suggests that to format the content of a cell to be italicized like in rows 3 and 4, one should use the alignment format in the orientation section. This means that by adjusting the orientation of the text in the cell, it can be formatted to appear slanted or italicized.

The correct answer is =MID(B11;4;2). This formula uses the MID function to extract a portion of the text in cell B11. It starts at the 4th character and includes the next 2 characters, resulting in the value "58".

The correct answer is "File | save as web page". This option allows you to save an Excel worksheet as a web page, which can then be displayed in a web browser. By selecting this option, you can convert the Excel file into a format that is compatible with web browsers, making it easier to share and view the worksheet online.

The correct answer is "Page break". This command is used to display page boundaries on the screen, allowing the user to see where each page begins and ends. It is commonly used when formatting a document or preparing it for printing, as it helps ensure that content is properly distributed across pages. By inserting page breaks, the user can control how the document is divided into separate pages and can easily navigate through them.

To display the document in its normal form after it has been restored, the command to use is "Minimum".

The correct answer is "Dua kolom atau baris" which means "Two columns or rows" in English. In a pie chart, the data required can be represented using either two columns or two rows. This means that the data can be organized and presented in either a vertical or horizontal manner. Both options are valid for displaying the necessary information in a pie chart.