A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
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.