Selected MCQ

Current Question
Getting data from a cell located in a different sheet is called ____.
  • A. Accessing
  • B. Updating
  • C. Cell Referencing
  • D. Functioning
Correct Answer: C
Explanation:
Referring to a cell in another sheet is called external cell referencing.
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
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
The basic unit of a worksheet into which you enter data is called as ____.
  • A. Tab
  • B. Cell
  • C. Box
  • D. Range
Correct Answer: B
Explanation:
Data is entered into a cell.
Related Question 4
Computers manipulate data in many ways, and this manipulation is called ____.
  • A. Upgrading
  • B. Processing
  • C. Batching
  • D. Utilizing
Correct Answer: B
Explanation:
Data manipulation by a computer is called processing.
Related Question 5
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.