Microsoft Excel MCQs with answers Page - 93

Dear candidates you will find MCQ questions of Microsoft Excel here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

Q. Tab scrolling buttons ?

  • (A) Allow you to view a different worksheet
  • (B) Allow you to view additional worksheet row down
  • (C) Allow you to view additional worksheet columns to the right
  • (D) Allow you to view additional sheet tabs
💬 Discuss
✅ Correct Answer: (D) Allow you to view additional sheet tabs
Explanation: 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.

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:49 am in Microsoft Excel

Q. You can insert labels for ?

  • (A) All the data markers on a chart
  • (B) A data series
  • (C) A selected data marker
  • (D) All
💬 Discuss
✅ Correct Answer: (D) All
Explanation: 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.

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:50 am in Microsoft Excel

Q. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros ?

  • (A) On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
  • (B) On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
  • (C) Apply a selected background color
  • (D) All of above
💬 Discuss
✅ Correct Answer: (B) On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
Explanation: 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).

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:51 am in Microsoft Excel

Q. To delete an incorrect character in a document, _______ to erase to the right of the insertion point ?

  • (A) press the left mouse key
  • (B) double click the right mouse key
  • (C) press the BACKSPACE key
  • (D) press DELETE key
💬 Discuss
✅ Correct Answer: (D) press DELETE key
Explanation: 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.

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:53 am in Microsoft Excel

Q. Which function calculates your monthly mortage payment ?

  • (A) PMT (payments)
  • (B) NPER (number of periods)
  • (C) PV (presént value)
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) PMT (payments)
Explanation: 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.

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:54 am in Microsoft Excel

Q. A __________ is rectangular grid of rows & columns used to enter data ?

  • (A) cell
  • (B) worksheet
  • (C) spreadsheet
  • (D) Both (2) and (3)
💬 Discuss
✅ Correct Answer: (D) Both (2) and (3)

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:54 am in Microsoft Excel

Q. By default, Excel positions text in a cell __________ ?

  • (A) Left-aligned
  • (B) right-aligned
  • (C) centered
  • (D) justified
💬 Discuss
✅ Correct Answer: (A) Left-aligned

Published by Ravi Chauhan ⭐ 11.26K Points at 22-Sep-2024 08:55 am in Microsoft Excel

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play