In MS Access, what is the default data type for a field when you create a new table in Datasheet View? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, which function calculates the total of a range but ignores error values?
Correct Answer: Option B
Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
Which of the following is the default file extension for a Word template?
Correct Answer: Option B
Explanation:
.dotx is Word template.
.dotx is Word template.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?
Correct Answer: Option C
Explanation:
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!