엑셀에서 INDIRECT 함수는 문자열로 주어진 참조를 실제 셀 참조로 변환하는 함수입니다. 즉, 직접 셀을 지정하는 대신 텍스트 형태로 된 주소를 이용해서 값을 가져올 수 있습니다.=SUM(INDIRECT(C3&"[Workshops Scheduled]"))이 수식은 INDIRECT 함수와 SUM 함수를 함께 사용하여 특정 테이블의 열(column)을 동적으로 참조하고, 그 합계를 구하는 구조입니다.=INDIRECT(C3&"[Workshops Scheduled]")C3C3 셀에 들어 있는 테이블 이름을 가져옵니다. AsteriskCity를 가져옵니다.&"[Workshops Scheduled]"[Workshops Scheduled]라는 열(column) 이름을 연결합니다.결과적으로"AsteriskCity[..

Table: Products+---------------+---------+| Column Name | Type |+---------------+---------+| product_id | int || new_price | int || change_date | date |+---------------+---------+(product_id, change_date) is the primary key (combination of columns with unique values) of this table.Each row of this table indicates that the price of some product was changed to a new price ..

Table: Employees+-------------+----------+| Column Name | Type |+-------------+----------+| employee_id | int || name | varchar || reports_to | int || age | int |+-------------+----------+employee_id is the column with unique values for this table.This table contains information about the employees and the id of the manager they report to. Some employees do no..

Table: MyNumbers+-------------+------+| Column Name | Type |+-------------+------+| num | int |+-------------+------+This table may contain duplicates (In other words, there is no primary key for this table in SQL).Each row of this table contains an integer. A single number is a number that appeared only once in the MyNumbers table.Find the largest single number. If there is no single n..

Table: Activity+--------------+---------+| Column Name | Type |+--------------+---------+| player_id | int || device_id | int || event_date | date || games_played | int |+--------------+---------+(player_id, event_date) is the primary key (combination of columns with unique values) of this table.This table shows the activity of players of some games.Each row is a recor..

Table: Delivery+-----------------------------+---------+| Column Name | Type |+-----------------------------+---------+| delivery_id | int || customer_id | int || order_date | date || customer_pref_delivery_date | date |+-----------------------------+---------+delivery_id is the column of unique values of this tabl..