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