Selected MCQ

Current Question
A ____ is a dynamic mathematical calculation that displays a single value for a specific field.
  • A. Format row
  • B. Criteria row
  • C. Aggregate function
  • D. Format layout
Correct Answer: C
Explanation:
Aggregate functions (SUM, AVERAGE, COUNT, etc.) calculate a single summary value.
Related Question 1
The function is ____ which can calculate the value given in a specific order.
  • A. Program
  • B. Predefined formula
  • C. Software
  • D. None of these
Correct Answer: B
Explanation:
Functions are built-in, predefined formulas in Excel.
Related Question 2
To create a table of columns and rows for statistical or mathematical calculations, using spreadsheet software is used.
  • A. Excel
  • B. Word Pad
  • C. WordPerfect
  • D. Corel Draw
Correct Answer: A
Explanation:
Excel is used for tables and calculations.
Related Question 3
A(n) ____ language reflects the way people think mathematically.
  • A. Cross-platform programming
  • B. 3GL business programming
  • C. Event-driven programming
  • D. Functional
Correct Answer: D
Explanation:
Functional programming languages (e.g., Haskell) model mathematical functions.
Related Question 4
A Word field may consist of an optional field instruction called a(n) ____.
  • A. Sub-document
  • B. Symbol
  • C. Signal
  • D. Switch
Correct Answer: D
Explanation:
Field switches modify the behavior of Word fields.
Related Question 5
A single point on a computer screen is called ____.
  • A. Cell
  • B. Bit
  • C. Pixel
  • D. Element
Correct Answer: C
Explanation:
A pixel (Picture Element) is the smallest unit on a display.