Enlightened ... There are no special effects.

In Google Spreadsheet, the function ROUNDUP expects two parameters - the value and number of digits. But the second parameter is optional, defaulting to 0. If you had given just one parameter for the function, it works fine until you do an excel export. In Google spreadsheet, the formula was: =IF(ROUNDUP('Sheet1'!B52+'Sheet2'!B52+'Sheet3'!B52)-'Sheet4'!B51>='Sheet1'!B52,'Sheet5'!$E53,0.0) In the exported excel, it came out as =IF(((ROUNDUP((('Sheet1'!R[24]C+'Sheet2'!R[24]C)+'Sheet3'!R[24]C))-'Sheet4'!R[23]C)>='Sheet1'!R[24]C),'Sheet5'!R[25]C5,0.0) Really weird export. It took me a while to suspect that the missing parameter was causing the problem. Once the parameter was supplied, the exported excel looked fine.

Tired of being called to interview fresh graduates who can't think, I gave our HR person three sets of questions as follows. I didn't want to copy paste objective type questions. I wanted to see how they think, present etc. Set 1 1. Write the events that happen between requesting for a web-site address in browser's address bar and the retrieval of the web page. State your assumptions on internet / intranet, static / dynamic web sites. 2. Write a function (secondLargest) to find the second largest number in a given array of integers. (Expectation is just the function in such a way it can be reused in multiple programs with the most optimal solution in any programming language.) 3. Write a data structure in C/C++/C#/Java to store folders and files in a computer. Set 2 1. Give step-by-step instructions to go from your home to college. Be clear that a stranger to these places can simply follow the instructions and still reach the destination with no additional help. 2. Wr...