D465 Data Applications - Set 2 - 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: In R, which function would you use to remove missing values from a vector?

na.omit()

is.na()

complete.cases()

remove_na()

Question 42: Which SQL function would you use to calculate the total sum of a numeric column?

SUM

COUNT

MAX

AVG

Question 43: In Excel, which function is used to return the average of a set of values?

AVERAGE

SUM

MAX

MEDIAN

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

median()

mean()

sum()

sd()

Question 45: Which SQL keyword is used to return only distinct values in a query result?

DISTINCT

UNIQUE

COUNT

FILTER

Question 46: Which Excel function would you use to count the number of cells that contain a specific value?

COUNTIF

SUMIF

AVERAGEIF

COUNTA

Question 47: In R, which function is used to check if a value is NA (missing)?

is.na()

na.rm()

check_na()

na.omit()

Question 48: In SQL, which function is used to calculate the number of non-null values in a column?

COUNT

SUM

AVG

MAX

Question 49: Which Excel function would you use to add all the numbers in a range?

SUM

AVERAGE

MAX

COUNT

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

var()

mean()

sd()

sum()

Struggling With Exams?

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

Get Exam Support