D465 Data Applications - Set 5 - 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 Excel function would you use to search for a value in the first column of a table and return a value from the same row in another column?

VLOOKUP

HLOOKUP

MATCH

INDEX

Question 42: In R, which function is used to return the number of columns in a dataframe?

ncol()

nrow()

length()

dim()

Question 43: In SQL, which clause is used to group rows that have the same values in specified columns?

GROUP BY

ORDER BY

HAVING

WHERE

Question 44: Which Excel function would you use to replace part of a text string with a new string?

SUBSTITUTE

REPLACE

FIND

Question 45: In R, which function is used to compute the logarithm of a number?

log()

exp()

sqrt()

abs()

Question 46: In SQL, which statement is used to add a new column to an existing table?

ALTER TABLE

INSERT INTO

UPDATE TABLE

CREATE COLUMN

Question 47: Which Excel function would you use to return the rank of a number in a list of numbers?

RANK

RANK.EQ

RANK.AVG

PERCENTRANK

Question 48: In R, which function is used to replace NA values in a vector with a specified value?

replace()

fill()

substitute()

impute()

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

AVG()

SUM()

COUNT()

MIN()

Question 50: Which Excel function would you use to calculate the number of days between two dates?

DATEDIF

DATE

DAY

TODAY

Congratulations! You have completed all 5 question sets. Good job!

Go Back to Home

Struggling With Exams?

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

Get Exam Support