Selected MCQ

Current Question
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 1
Statistical calculations and preparation of tables and graphs can be done using ____.
  • A. Text
  • B. Boolean
  • C. Excel
  • D. Adobe Photoshop
Correct Answer: C
Explanation:
Excel is used for statistical tables.
Related Question 2
What is the maximum number of columns that can be inserted in MS Word Table?
  • A. 35
  • B. 45
  • C. 55
  • D. 63
Correct Answer: D
Explanation:
A Word table can have a maximum of 63 columns.
Related Question 3
Which type of table constraint will prevent the entry of duplicate rows?
  • A. Primary Key
  • B. Unique
  • C. Foreign Key
  • D. Check
Correct Answer: B
Explanation:
The Unique constraint ensures no duplicate values in a column (Primary Key also enforces uniqueness, but is a special case).
Related Question 4
In Excel, the rows of a table correspond to ____.
  • A. Table
  • B. Record
  • C. Field
  • D. Cell
Correct Answer: B
Explanation:
Each row in a table represents one complete record.
Related Question 5
A computer application program that displays data arranged in rows and columns is called ____.
  • A. Spreadsheet
  • B. Register
  • C. Form
  • D. Box
Correct Answer: A
Explanation:
A spreadsheet displays data in rows and columns.