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.
Concatenation of text can be done in Excel using
Apostrophe ( ‘ )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Correct answer is D
The ampersand (&) calculation operator allow us join text items without using a function.
For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1).
In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.
Getting data from a cell located in a different sheet is called ________
Accessing
Referencing
Updating
Functioning
Correct answer is B
No explanation has been provided for this answer.
Comments can be added to cells using ________
Home > Comments
Insert > Comment
Data > Comments
Review > Comments
Correct answer is D
No explanation has been provided for this answer.
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
Correct answer is A
No explanation has been provided for this answer.
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
Correct answer is A
No explanation has been provided for this answer.