D465 Data Applications - Set 2 - 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: What is the purpose of the WHERE clause in SQL?

To filter rows based on a condition

To group rows

To sort the result set

To return distinct rows

Question 22: In Excel, which function would you use to return the current date and time?

NOW

TODAY

DATE

TIME

Question 23: In R, which function is used to convert a dataframe to a tibble?

as_tibble()

convert_tibble()

to_tibble()

create_tibble()

Question 24: Which SQL function is used to calculate the average of a columns values?

AVG

SUM

MEAN

COUNT

Question 25: In Excel, which function would you use to count the number of non-empty cells in a range?

COUNTA

COUNT

COUNTIF

SUMIF

Question 26: Which SQL command is used to remove a table from a database?

DROP TABLE

DELETE TABLE

REMOVE TABLE

TRUNCATE TABLE

Question 27: In R, which function calculates the sum of the elements of a vector?

sum()

mean()

total()

add()

Question 28: In SQL, which keyword is used to limit the number of rows returned by a query?

LIMIT

WHERE

ORDER BY

HAVING

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

MAX

MIN

SUM

AVERAGE

Question 30: A data analyst needs to filter out rows where a value is greater than a specific number in SQL. Which clause should they use?

WHERE

HAVING

ORDER BY

GROUP BY

Question 31: In R, which function is used to rename a column in a dataframe?

rename()

colnames()

change_column()

modify_column()

Question 32: In SQL, which function would you use to count only the unique values in a column?

COUNT DISTINCT

SUM

COUNT

DISTINCT

Question 33: In Excel, which function is used to retrieve the value from a specified position in a table or array?

INDEX

MATCH

VLOOKUP

HLOOKUP

Question 34: Which clause is used in SQL to specify a condition that rows must meet after they are grouped?

HAVING

WHERE

GROUP BY

ORDER BY

Question 35: In R, which function is used to create a scatter plot?

plot()

ggplot()

geom_point()

scatter()

Question 36: In SQL, which function returns the remainder of a division operation?

MOD

DIVIDE

REMAINDER

SPLIT

Question 37: Which Excel function returns the number of characters in a text string?

LEN

LENGTH

CHARCOUNT

FIND

Question 38: In R, which function combines two or more vectors into a single vector?

c()

combine()

unite()

merge()

Question 39: In SQL, which clause is used to group rows that have the same values into summary rows?

GROUP BY

ORDER BY

DISTINCT

WHERE

Question 40: In Excel, which function is used to round a number to a specified number of digits?

ROUND

SUM

MOD

LEN

Don't Want to Study?

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

Get Exam Support