To add a row above the current row in an Excel table, press: MCQ with Answer and Explanation

To add a row above the current row in an Excel table, press:
A. Shift + Space, Ctrl + +
B. Ctrl + Shift + +
C. Ctrl + +
D. Alt + I, R
Answer: Option B
Solution (By JKSSB Mock Tests)
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++.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Access, which data type should you choose to store a web address?
A. Attachment
B. Text
C. Memo
D. Hyperlink

Correct Answer: Option D


Explanation:
Hyperlink data type stores URLs.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, to permanently remove a table and all its data, you should:
A. Clear all records
B. Use a Make-Table query
C. Delete the table object
D. Use a Delete query

Correct Answer: Option C


Explanation:
Deleting the table object removes structure and data. Delete query only removes records.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, a query that asks the user to input a specific value each time it is run is called a:
A. Parameter query
B. Select query
C. Action query
D. Crosstab query

Correct Answer: Option A


Explanation:
A parameter query prompts for criteria. Select query retrieves data, crosstab summarizes, action query updates/deletes.

This question belongs to: Computer Microsoft Office