aoinoue: (Rachel Maddow - WTF)
[personal profile] aoinoue
You are sent two spreadsheets. Spreadsheet #1 is a finished version of last month's report - it is basically just a bunch of columns with data items in it. Three columns are calculations of # of days, months, years since a date in one column. Two more columns are if/then statements based off of the calculations in the previous three columns.

Spreadsheet #2 is simply a copy of Spreadsheet #1 only with the calculations and if/then statements missing. All other data items are present.

You are now asked to make Spreadsheet #2 look like Spreadsheet #1.

What would you do?

If you answered, "Send both files over to one of the Business Analysts because I don't understand Excel and it scares me," congratulations, you did what my co-worker did.

Why "copy the formulas for the five columns in spreadsheet #1 that are currently blank in spreadsheet #2" did not occur to her, I do not know. Argh.
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
Account name:
If you don't have an account you can create one now.
HTML doesn't work in the subject.


Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.
Page generated Sep. 19th, 2017 06:51 pm
Powered by Dreamwidth Studios