Gotta take a test for a tech support role. What should I expect?

[Burned Verses]

The company's MO is basically helping hiring teams at other businesses with interviewing programmers, from what I see this is mostly through providing quizzes and an IDE to test their applicants. The job would deal with solving whatever technical issues these clients would have. Doesn't sound too challenging but I still would like some pointers, I know that I'll be analyzing CVS files for the assessment and Excel is recommended.

 

[Billy Ray Valentine]

CSV (comma separated values) files contain key/value pairs. They can be created in text files but people prefer .csv or .xlsx files so can they can be used in Excel. It's just easier to separate and view the data that way.



CSVs have columns and rows. The first row contains the "Keys" and the other rows contain the values. In programming or scripting, you would use CSVs to query data and output the results to a CSV file. Or you can "automate" a process by using a CSV to add bulk resources.



I'll use a CSV for something like Azure or Office 365 if you need to perform some kind of bulk operation like creating dozens of accounts or adding a bunch of users to a group.

Have you checked the company's knowledge base or FAQs to get a sense of how their program uses CSV files?

 

[Burned Verses]

CSV (comma separated values) files contain key/value pairs. They can be created in text files but people prefer .csv or .xlsx files so can they can be used in Excel. It's just easier to separate and view the data that way.



CSVs have columns and rows. The first row contains the "Keys" and the other rows contain the values. In programming or scripting, you would use CSVs to query data and output the results to a CSV file. Or you can "automate" a process by using a CSV to add bulk resources.



I'll use a CSV for something like Azure or Office 365 if you need to perform some kind of bulk operation like creating dozens of accounts or adding a bunch of users to a group.

Have you checked the company's knowledge base or FAQs to get a sense of how their program uses CSV files?

I looked around but I couldn't find anything. I've been messing around with excel though and I feel pretty comfortable with it, bout to take the test in a few.