Selected MCQ

Current Question
____ adds new line in same cell shortcut key in Excel.
  • A. Alt + Shift
  • B. Ctrl + Enter
  • C. Alt + Enter
  • D. Shift + Enter
Correct Answer: C
Explanation:
Alt+Enter inserts a new line in the same cell.
Related Question 1
New line in the same cell shortcut key in Excel?
  • A. Alt + Shift
  • B. Ctrl + Enter
  • C. Alt + Enter
  • D. Shift + Enter
Correct Answer: C
Explanation:
Alt+Enter inserts a line break in the cell.
Related Question 2
In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?
  • A. Absolute reference
  • B. Relative reference
  • C. Mixed reference
  • D. Circular reference
Correct Answer: A
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.
Related Question 3
Which Excel feature is associated with a bold line appearing around a cell when selected?
  • A. Freeze Panes
  • B. Filter
  • C. Data Validation
  • D. Active cell Highlighting
Correct Answer: D
Explanation:
The bold border indicates the active cell.
Related Question 4
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.
Related Question 5
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.