Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D465
  4. Set 3
WGU D465 · Data Applications

WGU D465 Practice Questions – Set 3

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

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

Question 2 of 50

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

Question 3 of 50

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

Question 4 of 50

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

Question 5 of 50

What is the purpose of the PRIMARY KEY constraint in SQL?

Question 6 of 50

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

Question 7 of 50

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

Question 8 of 50

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

Question 9 of 50

Which SQL function is used to convert a string to lowercase?

Question 10 of 50

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

Question 11 of 50

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

Question 12 of 50

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

Question 13 of 50

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

Question 14 of 50

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

Question 15 of 50

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

Question 16 of 50

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?

Question 17 of 50

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

Question 18 of 50

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

Question 19 of 50

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

Question 20 of 50

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

Question 21 of 50

Which Excel function would you use to count the number of cells that meet multiple criteria?

Question 22 of 50

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

Question 23 of 50

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

Question 24 of 50

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

Question 25 of 50

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

Question 26 of 50

Which SQL function is used to return the current date?

Question 27 of 50

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

Question 28 of 50

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

Question 29 of 50

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

Question 30 of 50

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

Question 31 of 50

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

Question 32 of 50

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

Question 33 of 50

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

Question 34 of 50

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

Question 35 of 50

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

Question 36 of 50

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

Question 37 of 50

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

Question 38 of 50

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

Question 39 of 50

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

Question 40 of 50

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

Question 41 of 50

Which SQL function is used to return the smallest value in a numeric column?

Question 42 of 50

Which Excel function would you use to count the number of cells that contain specific text?

Question 43 of 50

In R, which function is used to create a subset of a dataframe based on specific conditions?

Question 44 of 50

In SQL, which clause is used to specify the condition for filtering rows in a query?

Question 45 of 50

Which Excel function is used to search for a value in the first row of a table and return a value in the same column from a different row?

Question 46 of 50

In R, which function is used to combine multiple dataframes by rows?

Question 47 of 50

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

Question 48 of 50

Which Excel function is used to return the square root of a number?

Question 49 of 50

In R, which function is used to apply a function to each element of a vector or list?

Question 50 of 50

In SQL, which function is used to concatenate two or more strings together?

Set 3 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 4

Struggling with WGU D465?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now