Selected MCQ

Current Question
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 1
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 2
In MS Excel 2016, the “Pivot Tables” option is available in the ____ menu.
  • A. Review
  • B. View
  • C. Insert
  • D. Page Layout
Correct Answer: C
Explanation:
PivotTables are inserted from the Insert tab.
Related Question 3
Rows in Microsoft Excel are labeled as ____.
  • A. 1, 2, 3, etc.
  • B. A1, A2, etc.
  • C. C, A, B, C, etc.
  • D. D, A, B, etc.
Correct Answer: A
Explanation:
Rows are numbered sequentially, starting from 1.
Related Question 4
How many rows are in an MS Excel Sheet?
  • A. 86340
  • B. 1048576
  • C. 8640
  • D. None of these
Correct Answer: B
Explanation:
There are 1,048,576 rows in a modern Excel worksheet.
Related Question 5
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.