Microsoft Excel MCQs with answers Page - 92

In page break preview, the selected print area shown in white background with blue line around each page, and dark grey area is not a print area, this area contain blank cell which not require to print.

Adds up cell values based on a condition The correct answer is option (1) Adds up cell values based on a condition. The SUMIF function in Excel is used to add up cell values from a range that meet a specific condition. It takes three arguments: range, criteria, and sum_range. The "range" argument specifies the range of cells that will be evaluated based on the condition. The "criteria" argument defines the condition that must be met for the cells to be included in the calculation. The "sum_range" argument determines the cells that will be added together if they meet the specified condition. The SUMIF function is particularly useful when you want to sum values in a range based on certain criteria. For example, you can use it to sum all sales amounts for a specific product or sum all expenses for a particular category.

to move to the previous worksheet, you should press (2) Ctrl + PgUp.

The VLOOKUP function in Excel is used to (3) find related records. VLOOKUP stands for "Vertical Lookup" and is a powerful function that allows you to search for a specific value in the leftmost column of a table and retrieve a corresponding value from a different column within the same table. It is commonly used to look up and retrieve data from a large dataset or table based on a specific criteria. By specifying the lookup value, the table range, the column index number, and optionally indicating whether to perform an exact or approximate match, the VLOOKUP function can locate the desired value and return a corresponding value from a specified column. This is particularly useful when working with large datasets or when you need to retrieve specific information based on certain criteria. So, the correct answer is (3) finds related records.

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.