Selected MCQ

Current Question
Which Excel tool allows you to set specific conditions for data entry, ensuring accuracy and consistency in your analysis?
  • A. Scenario Manager
  • B. Goal Seek
  • C. Data Validation
  • D. Pivot Table
Correct Answer: C
Explanation:
Data Validation enforces rules on data entry.
Related Question 1
A ____ is a collection of data organized in a manner that allows access, retrieval and use of that data.
  • A. File
  • B. Recordset
  • C. Database
  • D. document
Correct Answer: C
Explanation:
A database is an organized collection of data.
Related Question 2
In MS Access, which of the following data types allows alphanumeric characters and special symbols?
  • A. Text
  • B. Memo
  • C. Auto number
  • D. None of these
Correct Answer: A
Explanation:
The Text data type (Short Text) supports alphanumeric characters and special symbols up to 255 characters.
Related Question 3
In Excel, you can sort data in ____.
  • A. Ascending order
  • B. Descending order
  • C. Both A & B
  • D. None of these
Correct Answer: C
Explanation:
Excel supports both ascending and descending sorts.
Related Question 4
In MS Excel data can be arranged by ____.
  • A. Data Menu
  • B. Data Sort
  • C. Data View
  • D. None of these
Correct Answer: B
Explanation:
Data Sort is the feature for rearranging data.
Related Question 5
Which is used for arranging data in ascending and descending order in MS Excel?
  • A. Data, Order
  • B. Data, all
  • C. Data, Sort
  • D. None of these
Correct Answer: C
Explanation:
The Sort command arranges data in ascending or descending order.