What is the shortcut key to show/hide the ribbon in MS Office applications? MCQ with Answer and Explanation

Explanation:
Select a cell, then Ctrl+Shift++ opens Insert dialog; if whole row is selected, it inserts. Also Ctrl++ works. But the common shortcut: Ctrl+Shift+plus sign. Both are plausible. I'll set A as correct: Ctrl+Shift++.

Explanation:
The AVERAGE function calculates the arithmetic mean. AVG is not a function, MEAN is not, AVERAGEIF averages based on a condition.

Explanation:
The References tab consolidates all formal academic reference indexing features, including bibliographies, table of contents, and citations.