What is the shortcut key to open the 'Page Setup' dialog in MS Excel? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In MS Access, what type of structural relationship is formed between two tables when a unique primary key is linked to a field that is also a primary key in another table?
Correct Answer: Option D
Explanation:
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS Access, to permanently remove a table and all its data, you should:
Correct Answer: Option D
Explanation:
Deleting the table object removes structure and data. Delete query only removes records.
Deleting the table object removes structure and data. Delete query only removes records.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In Excel, which function returns the year from a date?
Correct Answer: Option B
Explanation:
YEAR(serial_number) returns year.
YEAR(serial_number) returns year.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!