Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Database
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en

Instruction: DAVERAGE(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DCOUNT(database, field, criteria)
Language: Sheets
Context: Database
Returns: Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DCOUNTA(database, field, criteria)
Language: Sheets
Context: Database
Returns: Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DGET(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns a single value from a database table-like array or range using a SQL-like query. Learn more

Instruction: DMAX(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DMIN(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DPRODUCT(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DSTDEV(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DSTDEVP(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DSUM(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DVAR(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more

Instruction: DVARP(database, field, criteria)
Language: Sheets
Context: Database
Returns: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more