Selected MCQ

Current Question
Which command can be set to prohibit or allow a cell entry?
  • A. Background error checking
  • B. Data validation
  • C. Go to the special
  • D. Evaluate formulas
Correct Answer: B
Explanation:
Data Validation restricts or controls what can be entered in a cell.
Related Question 1
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as ____.
  • A. Decoration
  • B. Data appearance
  • C. Functions
  • D. Charting
Correct Answer: D
Explanation:
The feature is called charting or chart creation.
Related Question 2
Which Excel tool allows you to set specific conditions for data entry, ensuring accuracy and consistency in your analysis?
  • A. Scenario Manager
  • B. Goal Seek
  • C. Data Validation
  • D. Pivot Table
Correct Answer: C
Explanation:
Data Validation enforces rules on data entry.
Related Question 3
Cell entry “July 16, 2016” will be considered a ____ by Excel sheet.
  • A. Number
  • B. Formula
  • C. Value
  • D. Label
Correct Answer: C
Explanation:
Excel automatically recognizes and stores dates as numeric values.
Related Question 4
Computer spreadsheet cell that is highlighted with a heavy border is a ____.
  • A. Active cell
  • B. Cell containing a formula
  • C. Locked cell
  • D. Cell
Correct Answer: A
Explanation:
The cell with a heavy border is the active (currently selected) cell.
Related Question 5
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.