Selected MCQ

Current Question
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 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
What was the name of the first personal computer electronic spreadsheet software package, which became a smash hit as soon as it was introduced in 1978?
  • A. WordStar
  • B. VisiCalc
  • C. Lotus 1-2-3
  • D. Excel
Correct Answer: B
Explanation:
VisiCalc (1979) was the first electronic spreadsheet for personal computers.
Related Question 3
In a computer spreadsheet, first part of number format describes ____.
  • A. Positive number
  • B. Negative number
  • C. Zero values
  • D. Text values
Correct Answer: A
Explanation:
In custom number formats, the first section defines how positive numbers are displayed.
Related Question 4
When adding two cells in a spreadsheet, which of the following represents the correct formula?
  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Correct Answer: B
Explanation:
=A1+A2 is the correct basic addition formula.
Related Question 5
Basic unit of a computer spreadsheet in which you enter text and numbers is known as ____.
  • A. Workbook
  • B. Column
  • C. Row
  • D. Cell
Correct Answer: D
Explanation:
The basic unit is a cell.