Wgu D465 - Data Applications
COUNTIF function in spreadsheets - ✔️✔️Counts cells meeting a specified condition.
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.
R and Python similarities - ✔️✔️Both widely used in data science with extensive
libraries.
R unique challenges - ✔️✔️Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - ✔️✔️Allows reproducibility and collaboration among
analysts.
Programming languages and use cases - ✔️✔️Python: web dev, data science, ML,
automation.
MIN function in spreadsheets - ✔️✔️Returns the smallest value in a cell range.
Delimiter for code chunks - ✔️✔️Triple backticks or markup to define code sections.
Output formats for documents - ✔️✔️HTML, PDF, Word (docx), Markdown.
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 ggplot2 - ✔️✔️Incorrect aesthetic mappings, syntax
misunderstanding.
Basic aesthetic attributes in ggplot2 - ✔️✔️x-axis, y-axis, color for plot customization.
Smoothing line usage - ✔️✔️Visual representation of trends in data.
dplyr filter() function - ✔️✔️Subset rows based on specific conditions in R.
VLOOKUP function in spreadsheets - ✔️✔️Searches for values in a vertical column.
Locking table array in VLOOKUP - ✔️✔️Prevents range changes for formula accuracy.
Different JOIN functions in SQL - ✔️✔️INNER, LEFT, RIGHT, FULL OUTER JOIN
types.
COUNT vs. COUNT DISTINCT in SQL - ✔️✔️COUNT: total rows, COUNT DISTINCT:
unique values.
SELECT statement usage in SQL - ✔️✔️Retrieving data from one or more tables.
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 biased data - ✔️✔️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
VALUE - ✔️✔️COUNTIF
What is an example of an 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 - ✔️✔️The values in cells B2 through B31
Which function will 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) - ✔️✔️=SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table organize and group the selected data
horizontally.
columns
rows
filters
values - ✔️✔️rows
Which spreadsheet tool finds an average value using values generated within a pivot
table?
Filter
Data validation
Conditional formatting
Calculated field - ✔️✔️Calculated field
In a SQL query, what is the purpose of the modulo (%) operator?
Return the remainder of a division calculation
Convert a decimal to a percent
Apply an exponent to a value
Find the square root of a number - ✔️✔️Return the remainder of a division calculation
A data professional writes a query that uses more than one arithmetic operator. What
do they add to the query to control the order of the calculations?
Dollar sign ($)
Parenthesis [()]
Colon [:]
Backslash [/] - ✔️✔️Parenthesis [()]
Spreadsheet cell D5 contains the decimal .74. Which formula will convert it to a
percentage?
=D5%100
=D5,100
COUNTIF function in spreadsheets - ✔️✔️Counts cells meeting a specified condition.
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.
R and Python similarities - ✔️✔️Both widely used in data science with extensive
libraries.
R unique challenges - ✔️✔️Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - ✔️✔️Allows reproducibility and collaboration among
analysts.
Programming languages and use cases - ✔️✔️Python: web dev, data science, ML,
automation.
MIN function in spreadsheets - ✔️✔️Returns the smallest value in a cell range.
Delimiter for code chunks - ✔️✔️Triple backticks or markup to define code sections.
Output formats for documents - ✔️✔️HTML, PDF, Word (docx), Markdown.
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 ggplot2 - ✔️✔️Incorrect aesthetic mappings, syntax
misunderstanding.
Basic aesthetic attributes in ggplot2 - ✔️✔️x-axis, y-axis, color for plot customization.
Smoothing line usage - ✔️✔️Visual representation of trends in data.
dplyr filter() function - ✔️✔️Subset rows based on specific conditions in R.
VLOOKUP function in spreadsheets - ✔️✔️Searches for values in a vertical column.
Locking table array in VLOOKUP - ✔️✔️Prevents range changes for formula accuracy.
Different JOIN functions in SQL - ✔️✔️INNER, LEFT, RIGHT, FULL OUTER JOIN
types.
COUNT vs. COUNT DISTINCT in SQL - ✔️✔️COUNT: total rows, COUNT DISTINCT:
unique values.
SELECT statement usage in SQL - ✔️✔️Retrieving data from one or more tables.
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 biased data - ✔️✔️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
VALUE - ✔️✔️COUNTIF
What is an example of an 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 - ✔️✔️The values in cells B2 through B31
Which function will 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) - ✔️✔️=SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table organize and group the selected data
horizontally.
columns
rows
filters
values - ✔️✔️rows
Which spreadsheet tool finds an average value using values generated within a pivot
table?
Filter
Data validation
Conditional formatting
Calculated field - ✔️✔️Calculated field
In a SQL query, what is the purpose of the modulo (%) operator?
Return the remainder of a division calculation
Convert a decimal to a percent
Apply an exponent to a value
Find the square root of a number - ✔️✔️Return the remainder of a division calculation
A data professional writes a query that uses more than one arithmetic operator. What
do they add to the query to control the order of the calculations?
Dollar sign ($)
Parenthesis [()]
Colon [:]
Backslash [/] - ✔️✔️Parenthesis [()]
Spreadsheet cell D5 contains the decimal .74. Which formula will convert it to a
percentage?
=D5%100
=D5,100
