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 function is used to get the location of text in a string in MS Excel?
FIND()
INDEX()
SEARCH()
STRINGSEARCH()
Correct answer is C
The SEARCH() function is used to get the location of text in a string.
Syntax:
=SEARCH (find_text, within_text, [start_num])
Example:
=SEARCH("How","Hello, world! How are you?") // Returns 15
Show/Hide Gridlines option is available in the ____ menu of Excel.
Page Layout
Data
Insert
Format
Correct answer is A
No explanation has been provided for this answer.
Under which menu can we insert Header and Footer in an Excel sheet?
Format
Review
Data
Insert
Correct answer is D
We can insert the Header and Footer in the sheet by clicking on the "Header and Footer" option from "Text Group" in the "Insert" Menu.
Styling
Conditional Formatting
Compare Formatting
Special Formatting
Correct answer is B
By using the "Conditional Formatting" feature, we can apply special formatting based on the conditions.
What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
Shift + F9
Shift + F10
Shift + F11
Shift + F12
Correct answer is C
No explanation has been provided for this answer.