Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, the function =ISBLANK(A1) returns:
Correct Answer: Option B
Explanation:
ISBLANK returns TRUE if cell is empty. A cell with a space is not empty, so FALSE.
ISBLANK returns TRUE if cell is empty. A cell with a space is not empty, so FALSE.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS Access, what is a 'composite key'?
Correct Answer: Option B
Explanation:
A composite key is a primary key made up of multiple columns.
A composite key is a primary key made up of multiple columns.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
Which of the following database objects in MS Access is primarily designed to securely look up, enter, or modify data in a table through a user-friendly layout?
Correct Answer: Option A
Explanation:
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!