indeed spreadsheets with microsoft excel test

#Indeed spreadsheets with microsoft excel test code
#Indeed spreadsheets with microsoft excel test download

This is what most people do before we’ve been exposed to time-saving strategies.

Anything that can’t be replicated by your Future.

Highlighting a range of numbers and counting.

Eye-balling (mentally tallying by looking at the.

Tallying by hand (by pointing at the screen).

Throughout the lesson, you’ll hear me refer to bad, better, and best solutions. Is the participant that lives in Parkside that has only one child? 33īad, Better, Best: A Range of Correct Solutions

How many participants are 18 years old? 4Īges of 14 and 19 have 4 or more children?.

(exactly as it appears in the data – with the misspelling): Parsdise

#Indeed spreadsheets with microsoft excel test code

Participant unique IDs) are included in this data set? 114Ģ0019 zip code (include anyone that does not have 20019 as a zip code)? 4 – 1 Is the participant that lives in Parkside that has only one child?

How many participants that are between theĪges of 14 and 19 have 4 or MORE children?.

How many participants are 18 years old?.How many African Americans live in Kenilworth.

How many participants have blank (missing).(exactly as it appears in the data – with the misspelling): Please write out the misspelled value below There is a typo in one of the Neighborhoodĭata fields – one value is spelled differently than the rest.How many participants live in the Lotus.How many participants DO NOT live in theĢ0019 zip code (include anyone that does not have 20019 as a zip code)?.Participant unique IDs) are included in this data set? Lesson on January 31, 2020, so my answers are dependent on that date. Some of the questions require using a date.

#Indeed spreadsheets with microsoft excel test download

Your Turn: Take the Excel Test!ĭownload the spreadsheet here: Download the spreadsheet I want to show you that even somebody who does this for a living still gets stuck sometimes. Maybe I’ve still got it!Īnd I might wish I never recorded this video at all. My time training others on data visualization-which means I spend less time I’m going to see if, ten years later, I can still pass! Isaac (the interviewer) and I thought this would make a … Re-Taking the Excel Test from Ten Years Ago I hoped I could actually do those things! He led me to another office across the hall. I was going on and on about all my great spreadsheet skills.īecause that’s what you do in interviews, right?Īnd then the interviewer was like, “Prove it. Level was pretty high: that you could work totally independently. It was a fast-paced office, so the expectation I remember sitting in the interviewer’s office. Improvement Specialist,” “Research Analyst,” or even “Data Scientist.” The official job title was “Learning and Evaluation Specialist.” Nowadays, you might hear it called “Quality Ten years ago, I was interviewing for an analyst position.