In MS Access, the 'Allow Zero Length' property is relevant for: MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
What will be the result of the MS Excel formula =COUNTA(A1:A4) if cell A1=10, A2="Text", A3=EMPTY, and A4=0?
Correct Answer: Option A
Explanation:
The COUNTA function counts any non-empty cells within a range. Out of four cells, three are occupied (10, "Text", 0) and one is blank, yielding 3.
The COUNTA function counts any non-empty cells within a range. Out of four cells, three are occupied (10, "Text", 0) and one is blank, yielding 3.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In Excel, which function is used to return the current time?
Correct Answer: Option A
Explanation:
NOW() returns date and time. TIME() creates a time from given hours, minutes, seconds. There is no CURRENTTIME.
NOW() returns date and time. TIME() creates a time from given hours, minutes, seconds. There is no CURRENTTIME.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
The shortcut to display the 'Open' dialog in MS Office is:
Correct Answer: Option C
Explanation:
Ctrl+O and Ctrl+F12 both open the Open dialog.
Ctrl+O and Ctrl+F12 both open the Open dialog.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!