Microsoft Excel MCQs with answers Page - 116

                    The correct answer is option (4) Allow you to view additional sheet tabs. Tab scrolling buttons in Excel are located at the bottom-left corner of the sheet tabs. They appear when there are more sheet tabs than can be displayed within the available space. The purpose of these tab scrolling buttons is to allow you to navigate and view additional sheet tabs that are currently hidden. By clicking the tab scrolling buttons, you can scroll through the sheet tabs horizontally and view the tabs that are not visible due to limited space. This feature is useful when you have multiple sheets in your workbook and need to access or switch between different sheets. Therefore, the correct answer is option (4) Allow you to view additional sheet tabs.                

                    The correct answer is option (4) All. In Excel, you can insert labels for all the data markers on a chart, a data series, or a selected data marker. The labels provide additional information about the data points in the chart, such as their values or categories. To insert labels for all the data markers on a chart, you can use the Chart Elements button (plus icon) that appears when the chart is selected. From there, you can enable the Data Labels option to display labels for all data points in the chart. If you want to insert labels for a specific data series, you can select the series in the chart and enable the Data Labels option for that particular series. Additionally, you can also insert labels for a selected data marker by individually selecting the marker and enabling the Data Labels option for that specific marker. Therefore, the correct answer is option (4) All.                

                    The correct answer is (2) On the tools menu, click Add-Ins, and select the Euro Currency Tools check box. By selecting the Euro Currency Tools add-in in Excel, you can enable the conversion of sums from Deutsche Marks to Euros. This add-in provides the necessary functionality to perform the currency conversion within Excel. The options mentioned in (1) and (3) are unrelated to currency conversion. Therefore, the correct answer is (2).                

                    To delete an incorrect character to the right of the insertion point in a document, you would typically press the DELETE key. Therefore, the correct answer is (4) press DELETE key.                

                    The correct answer is (1) PMT (payments). The PMT function is commonly used to calculate the monthly mortgage payment. It takes into account the interest rate, the number of periods, and the present value of the mortgage to calculate the fixed monthly payment amount. The NPER function is used to calculate the number of periods required to pay off a loan, and the PV function is used to calculate the present value or loan amount. However, in the context of calculating the monthly mortgage payment, the PMT function is the most appropriate choice.