Excel Basics and Terminology | Dataford Interview Questions

MS Excel and Basic terminologies and processes

Use the provided reference table to retrieve entries classified as basic Excel terminology or processes. Return the entries in their defined learning order, using the term as a tie-breaker when two entries share the same order.

Output

One row per basic Excel entry.
Columns: term, item_type, definition, and process_order.
Include only entries in the Basic category.
Sort by process_order ascending, then term ascending.

Schema

excel_reference

Column	Type	Description
terminology_idPK	INT	Unique identifier for the reference entry
term	VARCHAR(100)	Excel terminology or process name
item_type	VARCHAR(30)	Whether the entry is a terminology item or process
category	VARCHAR(30)	Difficulty or learning category
definition	VARCHAR(255)	Short explanation of the Excel entry
process_order	INT	Recommended learning sequence

Your question is Excel Basics and Terminology. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

MS Excel and Basic terminologies and processes

Output

One row per basic Excel entry.
Columns: term, item_type, definition, and process_order.
Include only entries in the Basic category.
Sort by process_order ascending, then term ascending.

Schema

excel_reference

Column	Type	Description
terminology_idPK	INT	Unique identifier for the reference entry
term	VARCHAR(100)	Excel terminology or process name
item_type	VARCHAR(30)	Whether the entry is a terminology item or process
category	VARCHAR(30)	Difficulty or learning category
definition	VARCHAR(255)	Short explanation of the Excel entry
process_order	INT	Recommended learning sequence

Your question is Excel Basics and Terminology. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.