Mega Quiz Winner and Correct Answers

Congratulations Mr. Pratyush Nayak for winning the quiz. Amazing performance – he got all the right answers in just 5 minutes and 3 seconds. What is even more commendable is that he got all answers right in the first attempt!
Mr. Pratyush please send me a mail at nitin@maxoffice.biz. Office Mix does not reveal your contact details.
Read on to find out the right answers and learn more … Continue reading

Monthly Quiz – July 2014

Quiz time. This is a special quiz created using Office Mix – a new PowerPoint add-in from Microsoft. This time the stakes are higher USD 50. Ten questions. If you have been reading this blog, you should be able to derive the answers.

Best of Luck. Click here to start the quiz.

You must sign-in using either Microsoft, Facebook or Google account.

image

Choosing the winner – All answers must be correct, minimum attempts, minimum time. If there are many potential winners, then a random number will be generated to choose the winner. Ideally, I should choose the person who answered first in chronological order. However, this site is viewed from 80+ countries across different time zones. Therefore, to be fair to everyone, I will use the random number approach. Hope it is ok with everyone.

We have a winner

The right answer was given again by Kakesh. Congratulations!

image

The question

If you have tabular data copied from Excel which contains a list of email ids, how to convert it to a semicolon delimited list for sending a mail. Of course, the quiz was to find the quickest and smartest way.

How to convert this…

image 

to this…

someone@maxoffice.biz; boss@maxoffice.biz; finance@maxoffice.biz; chairman@maxoffice.biz; everyperson@maxoffice.biz; katrin@maxoffice.biz

The right answer

The answer is that you don’t have to do anything special.

Most email applications understand the issue and they know how to convert a tabular copy paste to a semicolon delimited list. In most cases, you don’t have to do anything special.

Just copy and paste the tabular data into the To, CC or BCC fields and click send as usual.

If you want to see the process in action, press Ctrl K or click on Check Names button in Outlook. It will process the data and show you the results.

image

Email etiquette

I hope you already know this but just to be sure… If you are sending a mail to many unrelated people, put the names in BCC and put your own name in the To list. This way we protect the privacy of all the recipients.

Even though you may know all these people, they may not know each other. Therefore, it is your job to protect their identity.