Selected MCQ

Current Question
In MS Excel, to delete duplicate values, which menu is used?
  • A. File
  • B. Data
  • C. Edit
  • D. View
Correct Answer: B
Explanation:
The Remove Duplicates command is located under the Data tab.
Related Question 1
How to duplicate values in a cell range in MS-Excel 2016?
  • A. Select the range of cells in the worksheet
  • B. Click the conditional formatting button in the Styles group of the Home tab
  • C. Both A and B
  • D. None of these
Correct Answer: C
Explanation:
Duplicate values can be highlighted using Conditional Formatting → Highlight Cells Rules → Duplicate Values.
Related Question 2
Ctrl+Shift+1 shortcut Keys in excel are used to ____.
  • A. Format the number in comma format
  • B. Format number in currency format
  • C. Format number in date format
  • D. Format number in time format
Correct Answer: A
Explanation:
Ctrl + Shift + 1 applies comma number formatting in Excel.
Related Question 3
Which key is used to edit the selected cell in Excel?
  • A. F4
  • B. F10
  • C. F2
  • D. Edit
Correct Answer: C
Explanation:
The F2 key activates edit mode for the selected cell in Excel.
Related Question 4
Which key is used for help in MS Excel?
  • A. F1
  • B. F2
  • C. F3
  • D. None of these
Correct Answer: A
Explanation:
F1 key opens the Help menu in Excel.
Related Question 5
Which key is used for Find in Excel?
  • A. CTRL+C
  • B. CTRL+F
  • C. ALT+SHIFT+D
  • D. ALT+SHIFT+F
Correct Answer: B
Explanation:
Ctrl+F opens the Find dialog in Excel.