In Access, which of the following is a valid expression for a validation rule? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, to protect a worksheet from being edited, you can:
Correct Answer: Option A
Explanation:
Protect Sheet is under Review tab.
Protect Sheet is under Review tab.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In Excel, which function is used to convert a text string that looks like a number into a number?
Correct Answer: Option C
Explanation:
The VALUE function converts a text string that represents a number into a numeric value. TEXT does the opposite.
The VALUE function converts a text string that represents a number into a numeric value. TEXT does the opposite.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?
Correct Answer: Option C
Explanation:
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!