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 is not a Text function in MS Excel?
CODE()
CLEAN()
CHAR()
DB()
Correct answer is D
The DB() is a financial function, not a Text function, the rest of the others are text functions.
Which chart type is used to show trends over time and categories in Excel?
Area Chart
Bar Chart
Doughnut Chart
Hierarchy Chart
Correct answer is A
No explanation has been provided for this answer.
Which chart type is used to visually compare values across a few categories in Excel?
Area Chart
Bar Chart
Doughnut Chart
Hierarchy Chart
Correct answer is B
No explanation has been provided for this answer.
Under which tab can chart options be found in MS Excel?
Data
Insert
Review
View
Correct answer is B
No explanation has been provided for this answer.
What are the steps for protecting an Excel Sheet by password?
Under the Review tab, click on Protect Current Sheet
Under Insert tab, click on Protect Sheet
Under Data tab, click on Protect Sheet
Under the Review tab, click on Protect Sheet
Correct answer is D
No explanation has been provided for this answer.