In MS Excel, the currently selected cell address is displayed in ____
Name Box
Formula Bar
Both A and B
None of the above
Correct answer is A
No explanation has been provided for this answer.
In Excel, which symbol is used to specify the fixed columns or rows in the formula?
=
*
$
%
Correct answer is C
No explanation has been provided for this answer.
What is the keyboard shortcut to view formulas instead of values in MS Excel?
CTRL + `
ALT + `
CTRL + ALT + `
CTRL + SHIFT + F
Correct answer is A
No explanation has been provided for this answer.
What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?
CTRL + F
ALT + 1
CTRL + SHIFT + F
CTRL + 1
Correct answer is D
No explanation has been provided for this answer.
What is the keyboard shortcut to insert a SUM formula in MS Excel?
CTRL + =
ALT + =
ALT + S
CTRL + ALT + =
Correct answer is B
The keyboard shortcut to insert a SUM formula is "ALT + =". For this, select the cell range and press "ALT+=". You will get the SUM of the values of the selected range.