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.
What symbol is used before a number to make it a label in Excel?
” ( quote )
= ( equal )
_ ( underscore )
‘ ( apostrophe )
Correct answer is D
An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.
Which of the following is an absolute cell reference in Excel?
!A!1
$A$1
#a#1
A1
Correct answer is B
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesn’t adjust relative cell references
Correct answer is B
No explanation has been provided for this answer.
Right clicking something in Excel
Deletes the object
Nothing. The right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Correct answer is C
No explanation has been provided for this answer.
Click the save button on the standard toolbar from the menu
Press Ctrl+ F5
Click Save on the Windows Start button
Select Edit > Save
Correct answer is A
No explanation has been provided for this answer.