D465 Data Applications - Set 5 - Part 2

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 21: In R, which function is used to calculate the quantiles of a numeric vector?

quantile()

median()

sd()

var()

Question 22: In SQL, which function is used to combine multiple strings into one?

CONCAT

MERGE

APPEND

JOIN

Question 23: Which Excel function would you use to return the smallest value in a range of cells?

MIN

MAX

AVERAGE

SUM

Question 24: In R, which function would you use to create a bar plot?

barplot()

geom_bar()

ggplot()

plot()

Question 25: In SQL, which keyword is used to limit the results returned by a query to unique values?

DISTINCT

UNIQUE

COUNT

LIMIT

Question 26: Which Excel function is used to calculate the sum of an array of numbers multiplied by another array of numbers?

SUMPRODUCT

PRODUCT

SUM

MULTIPLY

Question 27: In R, which function is used to sample random numbers or elements from a vector?

sample()

seq()

rep()

random()

Question 28: In SQL, which clause is used to filter rows that have matching values in two tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

OUTER JOIN

Question 29: Which Excel function would you use to return the position of a specific value within a range of cells?

MATCH

VLOOKUP

HLOOKUP

INDEX

Question 30: In R, which function is used to compute a cumulative sum of a vector?

cumsum()

sum()

cumprod()

prod()

Question 31: In SQL, which operator is used to check if a value exists within a range of values?

BETWEEN

Question 32: Which Excel function is used to return the largest value in a range that meets a specific condition?

MAXIFS

SUMIFS

AVERAGEIFS

MAX

Question 33: In R, which function is used to plot a scatter plot?

plot()

ggplot()

geom_point()

scatter()

Question 34: In SQL, which clause is used to specify the source table for a query?

FROM

SELECT

WHERE

INTO

Question 35: Which Excel function would you use to return the average of cells that meet multiple criteria?

AVERAGEIFS

AVERAGEIF

COUNTIFS

SUMIFS

Question 36: In R, which function is used to combine vectors by columns?

cbind()

rbind()

merge()

bind()

Question 37: In SQL, which function is used to extract a substring from a string?

SUBSTRING

LEFT

RIGHT

MID

Question 38: Which Excel function is used to return the remainder after dividing two numbers?

MOD

DIV

ROUND

SUM

Question 39: In R, which function is used to create a histogram?

hist()

barplot()

ggplot()

geom_histogram()

Question 40: In SQL, which operator is used to search for a specific pattern in a column?

MATCH

EXISTS

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support