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.
Which option is used to hide/show the Headings in MS Excel?
View Menu > Show Group > Headings
View Menu > Show Group > Gridlines
View Menu > Show Group > Headers
View Menu > Show Group > Titles
Correct answer is A
No explanation has been provided for this answer.
Workbook Statistics
Statistics
Excel Statistics
Workbook Analysis
Correct answer is A
No explanation has been provided for this answer.
Which function is used to find the sum of complex numbers in MS Excel?
SUM()
ADD()
CSUM()
IMSUM()
Correct answer is D
Example:
=IMSUM("1-2i", "2+4i") // Returns 3+2i
Which is the correct syntax of the HEX2BIN() function in MS Excel?
=HEX2BIN (number, [places])
=HEX2BIN (number)
=HEX2BIN (number, BASE, [places])
=HEX2BIN (number, BASE)
Correct answer is A
Example:
=HEX2BIN("F") // Return 1111
=HEX2BIN("F",8) // Returns 00001111
Which function is used to remove extra spaces from the text in MS Excel?
REMOVE()
TRIM()
TRUNC()
All of the above
Correct answer is B
The TRIM() function in Excel removes extra spaces from text. It deletes all leading, trailing and in-between spaces except for a single space character between words.
Syntax:
=TRIM (text)
Example:
=TRIM(" Hello World! ") // Returns "Hello World!"