D465 Data Applications - Set 3 - 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: Which Excel function would you use to count the number of cells that meet multiple criteria?

COUNTIFS

COUNTIF

COUNTA

SUMIF

Question 22: In R, which function is used to find the unique values in a vector?

unique()

distinct()

sort()

filter()

Question 23: In SQL, which function is used to return the remainder of a division operation?

MOD

DIV

REMAINDER

SPLIT

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

LEN

LENGTH

CHARCOUNT

COUNTIF

Question 25: In R, which function is used to sort the elements of a vector in ascending order?

sort()

order()

rank()

arrange()

Question 26: Which SQL function is used to return the current date?

CURRENT_DATE

NOW

GETDATE

TODAY

Question 27: Which Excel function would you use to calculate the number of cells that are not empty?

COUNTA

COUNTIF

COUNT

SUMIF

Question 28: In R, which function is used to calculate the variance of a dataset?

var()

sd()

sum()

mean()

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

MAX

MIN

SUM

AVG

Question 30: Which Excel function is used to return the result of multiplying corresponding elements in two arrays?

SUMPRODUCT

PRODUCT

MULTIPLY

SUMIF

Question 31: In R, which function is used to read a CSV file into a dataframe?

read.csv()

import()

load.csv()

data.frame()

Question 32: In SQL, which statement is used to update data in an existing row of a table?

UPDATE

INSERT

MODIFY

CHANGE

Question 33: Which Excel function is used to return the sum of values that meet a specific condition?

SUMIF

SUM

COUNTIF

AVERAGEIF

Question 34: In R, which function is used to generate a sequence of numbers?

seq()

rep()

range()

generate()

Question 35: In SQL, which function returns the number of characters in a string?

LENGTH

CHARCOUNT

COUNT

LEN

Question 36: Which Excel function returns the remainder when one number is divided by another?

MOD

DIVIDE

SPLIT

FLOOR

Question 37: In R, which function is used to check if a value is infinite?

is.infinite()

is.na()

is.nan()

infinite()

Question 38: In SQL, which clause is used to sort the result set of a query?

ORDER BY

GROUP BY

HAVING

DISTINCT

Question 39: In Excel, which function would you use to round a number down to the nearest integer?

FLOOR

ROUND

CEILING

MOD

Question 40: In R, which function is used to remove duplicate rows from a dataframe?

distinct()

unique()

filter()

arrange()

Don't Want to Study?

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

Get Exam Support