WGU D465 FINAL PAPER MODULE REVIEW
TESTED QUESTIONS 2026 100% CORRECT.
⫸ R unique challenges. Answer: Steeper learning curve, limited web
dev capabilities.
⫸ Advantage of storing code in R. Answer: Allows reproducibility
and collaboration among analysts.
⫸ Programming languages and use cases. Answer: Python: web dev,
data science, ML, automation.
⫸ MIN function in spreadsheets. Answer: Returns the smallest value
in a cell range.
⫸ COUNTIF function in spreadsheets. Answer: Counts cells meeting
a specified condition.
⫸ Pivot table elements. Answer: Rows, columns, values, filters for
data aggregation.
⫸ SELECT command in SQL. Answer: Retrieves data from one or
more database tables.
,⫸ JOIN commands in SQL. Answer: INNER, LEFT, RIGHT, FULL
OUTER JOIN types.
⫸ Delimiter for code chunks. Answer: Triple backticks or markup to
define code sections.
⫸ Output formats for documents. Answer: HTML, PDF, Word
(docx), Markdown.
⫸ Presentation formats. Answer: Slides, Dashboards, Interactive web
apps.
⫸ Knit button in R. Answer: Compiles R Markdown into desired
output formats.
⫸ Symbol for comments in R. Answer: Pound sign (`#`) precedes
comments in R.
⫸ Nested function usage. Answer: Simplifies operations, improves
code readability.
⫸ Logical operators. Answer: AND (&&), OR (||), NOT (!).
⫸ Advantage of tidyverse. Answer: Cohesive data manipulation
packages in R.
,⫸ Functions in ggplot2. Answer: ggplot(), geom_point(),
geom_line(), aes().
⫸ Plus sign in ggplot2. Answer: Adds layers to ggplot objects for
customization.
⫸ Common errors in ggplot2. Answer: Incorrect aesthetic mappings,
syntax misunderstanding.
⫸ Basic aesthetic attributes in ggplot2. Answer: x-axis, y-axis, color
for plot customization.
⫸ Smoothing line usage. Answer: Visual representation of trends in
data.
⫸ dplyr filter() function. Answer: Subset rows based on specific
conditions in R.
⫸ VLOOKUP function in spreadsheets. Answer: Searches for values
in a vertical column.
⫸ Locking table array in VLOOKUP. Answer: Prevents range
changes for formula accuracy.
⫸ Different JOIN functions in SQL. Answer: INNER, LEFT, RIGHT,
FULL OUTER JOIN types.
, ⫸ COUNT vs. COUNT DISTINCT in SQL. Answer: COUNT: total
rows, COUNT DISTINCT: unique values.
⫸ SELECT statement usage in SQL. Answer: Retrieving data from
one or more tables.
⫸ FROM statement in SQL. Answer: Specifies tables for data
retrieval in SQL queries.
⫸ Tibbles vs. data frames. Answer: Modernized data frames with
improved features.
⫸ Main operators in R. Answer: Arithmetic, relational, logical,
assignment operators.
⫸ sample() function for biased data. Answer: Creates random
unbiased data samples.
⫸ Fill in the blank: The spreadsheet function _____ returns the
number of cells within a range that match a specified value.
COUNTIF
ARRAY
COUNT DISTINCT
TESTED QUESTIONS 2026 100% CORRECT.
⫸ R unique challenges. Answer: Steeper learning curve, limited web
dev capabilities.
⫸ Advantage of storing code in R. Answer: Allows reproducibility
and collaboration among analysts.
⫸ Programming languages and use cases. Answer: Python: web dev,
data science, ML, automation.
⫸ MIN function in spreadsheets. Answer: Returns the smallest value
in a cell range.
⫸ COUNTIF function in spreadsheets. Answer: Counts cells meeting
a specified condition.
⫸ Pivot table elements. Answer: Rows, columns, values, filters for
data aggregation.
⫸ SELECT command in SQL. Answer: Retrieves data from one or
more database tables.
,⫸ JOIN commands in SQL. Answer: INNER, LEFT, RIGHT, FULL
OUTER JOIN types.
⫸ Delimiter for code chunks. Answer: Triple backticks or markup to
define code sections.
⫸ Output formats for documents. Answer: HTML, PDF, Word
(docx), Markdown.
⫸ Presentation formats. Answer: Slides, Dashboards, Interactive web
apps.
⫸ Knit button in R. Answer: Compiles R Markdown into desired
output formats.
⫸ Symbol for comments in R. Answer: Pound sign (`#`) precedes
comments in R.
⫸ Nested function usage. Answer: Simplifies operations, improves
code readability.
⫸ Logical operators. Answer: AND (&&), OR (||), NOT (!).
⫸ Advantage of tidyverse. Answer: Cohesive data manipulation
packages in R.
,⫸ Functions in ggplot2. Answer: ggplot(), geom_point(),
geom_line(), aes().
⫸ Plus sign in ggplot2. Answer: Adds layers to ggplot objects for
customization.
⫸ Common errors in ggplot2. Answer: Incorrect aesthetic mappings,
syntax misunderstanding.
⫸ Basic aesthetic attributes in ggplot2. Answer: x-axis, y-axis, color
for plot customization.
⫸ Smoothing line usage. Answer: Visual representation of trends in
data.
⫸ dplyr filter() function. Answer: Subset rows based on specific
conditions in R.
⫸ VLOOKUP function in spreadsheets. Answer: Searches for values
in a vertical column.
⫸ Locking table array in VLOOKUP. Answer: Prevents range
changes for formula accuracy.
⫸ Different JOIN functions in SQL. Answer: INNER, LEFT, RIGHT,
FULL OUTER JOIN types.
, ⫸ COUNT vs. COUNT DISTINCT in SQL. Answer: COUNT: total
rows, COUNT DISTINCT: unique values.
⫸ SELECT statement usage in SQL. Answer: Retrieving data from
one or more tables.
⫸ FROM statement in SQL. Answer: Specifies tables for data
retrieval in SQL queries.
⫸ Tibbles vs. data frames. Answer: Modernized data frames with
improved features.
⫸ Main operators in R. Answer: Arithmetic, relational, logical,
assignment operators.
⫸ sample() function for biased data. Answer: Creates random
unbiased data samples.
⫸ Fill in the blank: The spreadsheet function _____ returns the
number of cells within a range that match a specified value.
COUNTIF
ARRAY
COUNT DISTINCT
