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. Alt + I, R
B. Ctrl + Shift + +
C. Ctrl + +
D. Shift + Space, Ctrl + +
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, what is a 'Primary Key'?
A. A field that uniquely identifies each record in a table
B. A field that allows duplicate values
C. A field that stores external data
D. A field used for sorting

Correct Answer: Option A


Explanation:
A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, what does the 'IF' function do?
A. Looks up a value in a table
B. Tests a condition and returns one value if true, another if false
C. Sums cells based on a condition
D. Counts cells based on a condition

Correct Answer: Option B


Explanation:
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which object can contain other objects like buttons, text boxes, and subforms?
A. Form
B. Query
C. Macro
D. Table

Correct Answer: Option A


Explanation:
Forms serve as containers for controls.

This question belongs to: Computer Microsoft Office