They asked you technical Excel questions and to explain how you would write certain Excel functions for applicable scenarios.
Use the supplied question and response tables to return every question with its most recent response, if one exists. Treat a later timestamp as more recent, with the response ID resolving timestamp ties.
question_id, function_name, scenario_text, latest_status, latest_answerquestion_id ascending| Column | Type | Description |
|---|---|---|
| question_idPK | INT | Unique identifier for the Excel function question |
| function_name | VARCHAR(100) | Excel function being evaluated |
| scenario_text | TEXT | Scenario in which the function may be applicable |
| Column | Type | Description |
|---|---|---|
| response_idPK | INT | Unique response identifier |
| question_id | INT | References the related Excel function question |
| answered_at | TIMESTAMP | Timestamp when the response was submitted |
| status | VARCHAR(30) | Assessment status of the response |
| answer_text | TEXT | Candidate explanation or formula |