D465 Data Applications - Set 3 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: Which function in Excel returns the value of a specific cell within a table, based on the row and column numbers?

VLOOKUP

HLOOKUP

INDEX

MATCH

Question 2: In SQL, which statement is used to change the structure of an existing table by adding a new column?

INSERT INTO

ALTER TABLE

ADD COLUMN

UPDATE TABLE

Question 3: Which Excel function would you use to combine text from multiple cells into one cell?

CONCATENATE

VLOOKUP

MATCH

FIND

Question 4: In R, which function is used to create a bar chart?

barplot()

geom_bar()

plot()

ggplot()

Question 5: What is the purpose of the PRIMARY KEY constraint in SQL?

To ensure that each row is unique

To allow NULL values

To group rows based on a condition

To remove duplicate rows

Question 6: Which Excel function calculates the average of a range of values that meet specific criteria?

AVERAGE

AVERAGEIF

SUMIF

COUNTIF

Question 7: In SQL, which function is used to round a numeric value to a specified number of decimal places?

ROUND

CEIL

FLOOR

SUM

Question 8: In Excel, which function is used to return the current date without the time?

TODAY

NOW

DATE

TIME

Question 9: Which SQL function is used to convert a string to lowercase?

LOWER

UPPER

CONCAT

REPLACE

Question 10: Which Excel function would you use to find the position of a value within a range of cells?

MATCH

INDEX

VLOOKUP

HLOOKUP

Question 11: In R, which function would you use to concatenate strings together?

paste()

c()

unite()

append()

Question 12: Which SQL clause is used to retrieve only the rows where a column has non-null values?

IS NOT NULL

IS NULL

HAVING

WHERE

Question 13: Which Excel function counts the number of cells that contain numbers?

COUNT

COUNTA

COUNTIF

SUM

Question 14: In SQL, which keyword is used to remove duplicate values from a result set?

DISTINCT

UNIQUE

COUNT

LIMIT

Question 15: In R, which function is used to calculate the cumulative sum of elements in a vector?

cumsum()

sum()

mean()

cumprod()

Question 16: In Excel, which function is used to search for a value and return a corresponding value in the same row but from a different column?

VLOOKUP

HLOOKUP

INDEX

MATCH

Question 17: In SQL, which function calculates the total number of rows that meet a specific condition?

COUNT

SUM

MAX

AVG

Question 18: Which Excel function would you use to return the largest value in a range of cells?

MAX

MIN

SUM

AVERAGE

Question 19: In R, which function is used to calculate the length of a vector?

length()

nrow()

count()

sum()

Question 20: In SQL, which statement is used to delete a specific row from a table?

DELETE

DROP

TRUNCATE

REMOVE

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support