Microsoft Excel MCQs with answers Page - 4

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. Zoom slider option is available in

  • (A) Status bar
  • (B) Formula bar
  • (C) Standard bar
  • (D) Quick Access Toolbar
💬 Discuss
✅ Correct Answer: (A) Status bar

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:56 pm in Microsoft Excel

Q. In Excel Options, the Auto Correct Option can be found in

  • (A) Popular
  • (B) Formulas
  • (C) Proofing
  • (D) Advanced
💬 Discuss
✅ Correct Answer: (C) Proofing

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:56 pm in Microsoft Excel

Q. A function inside another function is known as

  • (A) Nested function
  • (B) Mode function
  • (C) HLOOKUP function
  • (D) Indirect function
💬 Discuss
✅ Correct Answer: (A) Nested function

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:57 pm in Microsoft Excel

Q. What is the shortcut key to replace a data with another in sheet?

  • (A) Ctrl + R
  • (B) Ctrl + Shift + R
  • (C) Ctrl + H
  • (D) Ctrl + F
💬 Discuss
✅ Correct Answer: (C) Ctrl + H

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:57 pm in Microsoft Excel

Q. The Delete key of keyboard is assigned to which command in Excel?

  • (A) Edit > Clear > Contents
  • (B) Edit > Clear > All
  • (C) Edit > Delete
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) Edit > Clear > Contents

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:58 pm in Microsoft Excel

Q. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

  • (A) From Edit menu choose Clear and then Formats
  • (B) From Edit menu choose Delete
  • (C) Click on Remove Formatting tool on Standard Toolbar
  • (D) Double click the Format Painter and then press Esc key in keyboard
💬 Discuss
✅ Correct Answer: (A) From Edit menu choose Clear and then Formats

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:58 pm in Microsoft Excel

Q. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

  • (A) Right click on Sheet Tab of third sheet and choose Delete from the context menu
  • (B) Click on Sheet 3 and from Edit menu choose Delete
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) Right click on Sheet Tab of third sheet and choose Delete from the context menu

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:58 pm in Microsoft Excel

Q. Which of the following action removes a sheet from workbook?

  • (A) Select the sheet, then choose Edit > Delete Sheet
  • (B) Select the sheet then choose Format > Sheet > Hide
  • (C) Both of above
  • (D) None of above
💬 Discuss
✅ Correct Answer: (A) Select the sheet, then choose Edit > Delete Sheet

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:59 pm in Microsoft Excel

Q. While Finding and Replacing some data in Excel, which of the following statement is valid?

  • (A) You can Find and Replace within the sheet or workbook
  • (B) Excel does not have option to match case for find
  • (C) Both are valid
  • (D) None are valid
💬 Discuss
✅ Correct Answer: (A) You can Find and Replace within the sheet or workbook

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:59 pm in Microsoft Excel

Q. Which function returns the most common value in a data set

  • (A) LOGINV function
  • (B) INDIRECT function
  • (C) COVAR function
  • (D) MODE function
💬 Discuss
✅ Correct Answer: (D) MODE function

Published by Mr. Dubey ⭐ 111.54K Points at 22-Jul-2022 09:59 pm 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