Selected MCQ

Current Question
In Excel we added ____ before fraction for not to enter date.
  • A. S
  • B. &
  • C. Space
  • D. None of these
Correct Answer: C
Explanation:
A leading space forces Excel to treat the entry as text/fraction.
Related Question 1
Which is used for fractions, so data in MS-Excel doesn’t read it as a date?
  • A. S
  • B. @
  • C. /
  • D. Space
Correct Answer: D
Explanation:
Prefixing a fraction with a space prevents Excel from interpreting it as a date.
Related Question 2
Which area in an Excel window allows entering values and formulas?
  • A. Title bar
  • B. Menu bar
  • C. Formula bar
  • D. Standard toolbar
Correct Answer: C
Explanation:
The Formula Bar is the dedicated area for entering and editing content.
Related Question 3
Which of the following methods cannot be used to enter data in an MS Excel cell?
  • A. Pressing the Esc key
  • B. Clicking the formula bar
  • C. Pressing an arrow key
  • D. Pressing the Tab key
Correct Answer: A
Explanation:
Esc cancels editing; the other keys confirm or move after entry.
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
Before moving a subdocument to another location within a master document, you must switch to ____.
  • A. Normal View
  • B. Outline View
  • C. Web Layout View
  • D. Print Layout View
Correct Answer: B
Explanation:
Outline view is required for managing master and sub-documents.