D465 Data Applications - Set 4 - 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 is used to replace specific text in a string?

REPLACE

SUBSTITUTE

FIND

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

colnames()

rename()

names()

setnames()

Question 43: In SQL, which clause is used to filter the results of a query based on a specified condition?

WHERE

HAVING

GROUP BY

ORDER BY

Question 44: Which Excel function would you use to return a specific number of characters from a text string, starting from the left?

LEFT

RIGHT

MID

FIND

Question 45: In R, which function is used to create a line plot?

plot()

lines()

geom_line()

ggplot()

Question 46: In SQL, which function is used to return the largest value in a numeric column?

MAX

MIN

AVG

SUM

Question 47: Which Excel function would you use to join two or more text strings into one?

CONCATENATE

REPLACE

SUBSTITUTE

LEFT

Question 48: In R, which function is used to select specific columns from a dataframe?

select()

filter()

arrange()

group_by()

Question 49: In SQL, which statement is used to create a new table in a database?

CREATE TABLE

INSERT INTO

ALTER TABLE

SELECT INTO

Question 50: Which Excel function is used to return the position of a substring within a text string?

FIND

REPLACE

LEFT

Struggling With Exams?

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

Get Exam Support