D465 - Data Applications EXAM Questions and
Answers (Verified Answers) (Latest Update 2025)
UPDATE!!
Save
Terms in this set (126)
Both widely used in data science with extensive
R and Python similarities
libraries.
R unique challenges Steeper learning curve, limited web dev capabilities.
Advantage of storing Allows reproducibility and collaboration among
code in R analysts.
Programming languages Python: web dev, data science, ML, automation.
and use cases
MIN function in Returns the smallest value in a cell range.
spreadsheets
COUNTIF function in Counts cells meeting a specified condition.
spreadsheets
Pivot table elements Rows, columns, values, filters for data aggregation.
SELECT command in SQL Retrieves data from one or more database tables.
JOIN commands in SQL INNER, LEFT, RIGHT, FULL OUTER JOIN types.
Delimiter for code chunks Triple backticks or markup to define code sections.
Output formats for HTML, PDF, Word (docx), Markdown.
documents
Presentation formats Slides, Dashboards, Interactive web apps.
,Knit button in R Compiles R Markdown into desired output formats.
Symbol for comments in R Pound sign (`#`) precedes comments in R.
Nested function usage Simplifies operations, improves code readability.
Logical operators AND (&&), OR (||), NOT (!).
Advantage of tidyverse Cohesive data manipulation packages in R.
Functions in ggplot2 ggplot(), geom_point(), geom_line(), aes().
Plus sign in ggplot2 Adds layers to ggplot objects for customization.
Common errors in Incorrect aesthetic mappings, syntax
ggplot2 misunderstanding.
Basic aesthetic attributes x-axis, y-axis, color for plot customization.
in ggplot2
Smoothing line usage Visual representation of trends in data.
dplyr filter() function Subset rows based on specific conditions in R.
VLOOKUP function in Searches for values in a vertical column.
spreadsheets
Locking table array in Prevents range changes for formula accuracy.
VLOOKUP
Different JOIN functions in INNER, LEFT, RIGHT, FULL OUTER JOIN types.
SQL
COUNT vs. COUNT COUNT: total rows, COUNT DISTINCT: unique values.
DISTINCT in SQL
SELECT statement usage Retrieving data from one or more tables.
in SQL
FROM statement in SQL Specifies tables for data retrieval in SQL queries.
Tibbles vs. data frames Modernized data frames with improved features.
Main operators in R Arithmetic, relational, logical, assignment operators.
sample() function for Creates random unbiased data samples.
biased data
, Fill in the blank: The COUNTIF
spreadsheet function _____
returns the number of
cells within a range that
match a specified value.
COUNTIF
ARRAY
COUNT DISTINCT
VALUE
What is an example of an The values in cells B2 through B31
array in a spreadsheet?
All cells with number
values
Cells D7, E14, and F20
The values in cells B2
through B31
All cells with values
greater than 100
Which function will =SUMPRODUCT(M1:M4, P1:P4)
calculate the sum of the
products of the
corresponding items in
the arrays M1:M4 and
P1:P4?
=SUMPRODUCT(M1:M4,
P1:P4)
=MULTIPLY(M1:M4, P1:P4)
=PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4)
Answers (Verified Answers) (Latest Update 2025)
UPDATE!!
Save
Terms in this set (126)
Both widely used in data science with extensive
R and Python similarities
libraries.
R unique challenges Steeper learning curve, limited web dev capabilities.
Advantage of storing Allows reproducibility and collaboration among
code in R analysts.
Programming languages Python: web dev, data science, ML, automation.
and use cases
MIN function in Returns the smallest value in a cell range.
spreadsheets
COUNTIF function in Counts cells meeting a specified condition.
spreadsheets
Pivot table elements Rows, columns, values, filters for data aggregation.
SELECT command in SQL Retrieves data from one or more database tables.
JOIN commands in SQL INNER, LEFT, RIGHT, FULL OUTER JOIN types.
Delimiter for code chunks Triple backticks or markup to define code sections.
Output formats for HTML, PDF, Word (docx), Markdown.
documents
Presentation formats Slides, Dashboards, Interactive web apps.
,Knit button in R Compiles R Markdown into desired output formats.
Symbol for comments in R Pound sign (`#`) precedes comments in R.
Nested function usage Simplifies operations, improves code readability.
Logical operators AND (&&), OR (||), NOT (!).
Advantage of tidyverse Cohesive data manipulation packages in R.
Functions in ggplot2 ggplot(), geom_point(), geom_line(), aes().
Plus sign in ggplot2 Adds layers to ggplot objects for customization.
Common errors in Incorrect aesthetic mappings, syntax
ggplot2 misunderstanding.
Basic aesthetic attributes x-axis, y-axis, color for plot customization.
in ggplot2
Smoothing line usage Visual representation of trends in data.
dplyr filter() function Subset rows based on specific conditions in R.
VLOOKUP function in Searches for values in a vertical column.
spreadsheets
Locking table array in Prevents range changes for formula accuracy.
VLOOKUP
Different JOIN functions in INNER, LEFT, RIGHT, FULL OUTER JOIN types.
SQL
COUNT vs. COUNT COUNT: total rows, COUNT DISTINCT: unique values.
DISTINCT in SQL
SELECT statement usage Retrieving data from one or more tables.
in SQL
FROM statement in SQL Specifies tables for data retrieval in SQL queries.
Tibbles vs. data frames Modernized data frames with improved features.
Main operators in R Arithmetic, relational, logical, assignment operators.
sample() function for Creates random unbiased data samples.
biased data
, Fill in the blank: The COUNTIF
spreadsheet function _____
returns the number of
cells within a range that
match a specified value.
COUNTIF
ARRAY
COUNT DISTINCT
VALUE
What is an example of an The values in cells B2 through B31
array in a spreadsheet?
All cells with number
values
Cells D7, E14, and F20
The values in cells B2
through B31
All cells with values
greater than 100
Which function will =SUMPRODUCT(M1:M4, P1:P4)
calculate the sum of the
products of the
corresponding items in
the arrays M1:M4 and
P1:P4?
=SUMPRODUCT(M1:M4,
P1:P4)
=MULTIPLY(M1:M4, P1:P4)
=PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4)
