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++.
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.
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.
No comments yet. Be the first to start the discussion!