D465 Data Applications - Set 4 - 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 create a boxplot?

boxplot()

ggplot()

geom_boxplot()

plot()

Question 22: In SQL, which function would you use to calculate the total sum of a numeric column?

SUM

COUNT

AVG

MAX

Question 23: Which Excel function returns the remainder when one number is divided by another?

MOD

DIVIDE

SPLIT

ROUND

Question 24: In R, which function is used to return the unique values of a vector?

unique()

distinct()

filter()

sample()

Question 25: In SQL, which statement is used to delete a specific row from a table?

DELETE

DROP

REMOVE

TRUNCATE

Question 26: Which Excel function would you use to round a number to a specified number of decimal places?

ROUND

FLOOR

CEILING

MOD

Question 27: In R, which function would you use to create a scatter plot?

plot()

scatter()

ggplot()

geom_point()

Question 28: In SQL, which function is used to find the number of rows in a result set?

COUNT

SUM

MAX

AVG

Question 29: Which Excel function would you use to find the maximum value in a range of cells?

MAX

MIN

SUM

AVERAGE

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

var()

sd()

mean()

sum()

Question 31: In SQL, which keyword is used to combine the results of two SELECT statements into a single result set?

UNION

JOIN

MERGE

INSERT

Question 32: Which Excel function would you use to count the number of cells that contain numbers?

COUNT

COUNTA

COUNTIF

SUM

Question 33: In R, which function is used to bind dataframes by rows?

rbind()

cbind()

merge()

append()

Question 34: In SQL, which function returns the current date and time?

NOW()

GETDATE()

SYSDATE()

CURRENT_DATE()

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

MATCH

INDEX

VLOOKUP

Question 36: In R, which function would you use to calculate the median of a numeric vector?

median()

mean()

sd()

var()

Question 37: In SQL, which function is used to remove leading and trailing spaces from a string?

TRIM

REPLACE

LTRIM

RTRIM

Question 38: Which Excel function would you use to retrieve a value from a table by specifying a row and column number?

INDEX

VLOOKUP

HLOOKUP

MATCH

Question 39: In R, which function is used to sort a vector or dataframe?

sort()

order()

rank()

arrange()

Question 40: In SQL, which function is used to round a number to a specified number of decimal places?

ROUND

FLOOR

CEILING

MOD

Don't Want to Study?

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

Get Exam Support