Selected MCQ

Current Question
Which of the following Excel features allows users to evaluate values and return a result?
  • A. Formulas
  • B. Formatting
  • C. Filters
  • D. Insertions
Correct Answer: A
Explanation:
Formulas and functions evaluate data and return results.
Related Question 1
Which area in an Excel window allows entering values and formulas?
  • A. Title bar
  • B. Menu bar
  • C. Formula bar
  • D. Standard toolbar
Correct Answer: C
Explanation:
The Formula Bar is the dedicated area for entering and editing content.
Related Question 2
Excel would evaluate the formula, =2010/58, and return answer as ____.
  • A. 34.655
  • B. 6.25
  • C. 320
  • D. 132
Correct Answer: A
Explanation:
2010 ÷ 58 equals approximately 34.655.
Related Question 3
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 4
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 5
Which of the following is not one of Excel’s “what-if” functions?
  • A. Goal seek
  • B. Data Table
  • C. Scenario manager
  • D. Auto Outline
Correct Answer: D
Explanation:
Auto Outline is not a what-if analysis tool.