D465 Data Applications - Set 3 - Part 3

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

Question 41: Which SQL function is used to return the smallest value in a numeric column?

MIN

MAX

SUM

AVG

Question 42: Which Excel function would you use to count the number of cells that contain specific text?

COUNTIF

SUMIF

COUNTA

TEXTIF

Question 43: In R, which function is used to create a subset of a dataframe based on specific conditions?

subset()

filter()

arrange()

select()

Question 44: In SQL, which clause is used to specify the condition for filtering rows in a query?

WHERE

HAVING

GROUP BY

ORDER BY

Question 45: Which Excel function is used to search for a value in the first row of a table and return a value in the same column from a different row?

HLOOKUP

VLOOKUP

INDEX

MATCH

Question 46: In R, which function is used to combine multiple dataframes by rows?

rbind()

cbind()

merge()

append()

Question 47: In SQL, which function is used to calculate the average value of a numeric column?

AVG

SUM

MAX

COUNT

Question 48: Which Excel function is used to return the square root of a number?

SQRT

MOD

ROUND

POWER

Question 49: In R, which function is used to apply a function to each element of a vector or list?

lapply()

apply()

sapply()

map()

Question 50: In SQL, which function is used to concatenate two or more strings together?

CONCAT

LOWER

UPPER

REPLACE

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support