Data Analyst

Do you have experience in financial or operational modeling?

What methods did you use to solve the test assignment? What main functions did you use? Did you use AI?

Tell me about the logic of calculating Report 2: the attributes 'Already approved above' and 'Approved' — what do they mean and how are they calculated?

What projects are you interested in — only technical or do you consider consulting? What do you want to develop?

Was the task difficult, interesting, or simple for you?

Write the formula for calculating accumulated approval based on previous applications and other parameters in Report 2, using cell references.

Should a key be created separately in each table?

Why are comments not loading? Is it correct to create a sheet in the same Excel with comments and connect to it, then merge?

Problem Solving Solve the problem and indicate the correct answer 1. Two territories are equal in area. One of them is square with a side of 90 m. The other is rectangular, with a width of 45 m. What is its length? 120 m 270 m 135 m 150 m 180 m 2. The arithmetic mean of 10, 40, and 60 is: [phone]. The train travels x kilometers in 3 minutes. How many kilometers ... [text truncated]

Tell me about your experience: what did you do at previous jobs that is relevant to this project?

How to create Report 1 (Balance) — step by step?