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?
Correct answer:
C) INDEX
Explanation: The INDEX function returns the value of a specific cell in a table, using 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?
Correct answer:
B) ALTER TABLE
Explanation: The ALTER TABLE statement is used to modify the structure of an existing table, including adding new columns.
Question 3 of 50
Which Excel function would you use to combine text from multiple cells into one cell?
Correct answer:
A) CONCATENATE
Explanation: The CONCATENATE function joins text from multiple cells into a single cell.
Question 4 of 50
In R, which function is used to create a bar chart?
Correct answer:
A) barplot()
Explanation: The barplot() function in R is used to create bar charts from data.
Question 5 of 50
What is the purpose of the PRIMARY KEY constraint in SQL?
Correct answer:
A) To ensure that each row is unique
Explanation: The PRIMARY KEY constraint ensures that each row in a table has a unique identifier, preventing duplicate entries.
Question 6 of 50
Which Excel function calculates the average of a range of values that meet specific criteria?
Correct answer:
B) AVERAGEIF
Explanation: The AVERAGEIF function returns the average of all the numbers in a range 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?
Correct answer:
A) ROUND
Explanation: The ROUND function rounds a numeric value to a specified number of decimal places in SQL.
Question 8 of 50
In Excel, which function is used to return the current date without the time?
Correct answer:
A) TODAY
Explanation: The TODAY function returns the current date without the time component in Excel.
Question 9 of 50
Which SQL function is used to convert a string to lowercase?
Correct answer:
A) LOWER
Explanation: The LOWER function converts all the characters in a string to lowercase in SQL.
Question 10 of 50
Which Excel function would you use to find the position of a value within a range of cells?
Correct answer:
A) MATCH
Explanation: The MATCH function returns the position of a specified value within a range of cells.
Question 11 of 50
In R, which function would you use to concatenate strings together?
Correct answer:
A) paste()
Explanation: The paste() function in R is used to concatenate (join) strings together.
Question 12 of 50
Which SQL clause is used to retrieve only the rows where a column has non-null values?
Correct answer:
A) IS NOT NULL
Explanation: The IS NOT NULL clause in SQL retrieves 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?
Correct answer:
A) COUNT
Explanation: The COUNT function counts the number of cells that contain numeric values in a specified range.
Question 14 of 50
In SQL, which keyword is used to remove duplicate values from a result set?
Correct answer:
A) DISTINCT
Explanation: The DISTINCT keyword is used to eliminate duplicate values from a SQL query result set.
Question 15 of 50
In R, which function is used to calculate the cumulative sum of elements in a vector?
Correct answer:
A) cumsum()
Explanation: The cumsum() function calculates the cumulative sum of the elements in a vector in R.
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?
Correct answer:
A) VLOOKUP
Explanation: The VLOOKUP function searches for a value in the first column of a table and returns a value from the same row in a specified column.
Question 17 of 50
In SQL, which function calculates the total number of rows that meet a specific condition?
Correct answer:
A) COUNT
Explanation: The COUNT function returns the total number of rows that meet a specified condition.
Question 18 of 50
Which Excel function would you use to return the largest value in a range of cells?
Correct answer:
A) MAX
Explanation: The MAX function returns the largest numeric value in a specified range of cells.
Question 19 of 50
In R, which function is used to calculate the length of a vector?
Correct answer:
A) length()
Explanation: The length() function returns the number of elements in a vector in R.
Question 20 of 50
In SQL, which statement is used to delete a specific row from a table?
Correct answer:
A) DELETE
Explanation: The DELETE statement is used to remove specific rows from a table in SQL based on a condition.
Question 21 of 50
Which Excel function would you use to count the number of cells that meet multiple criteria?
Correct answer:
A) COUNTIFS
Explanation: The COUNTIFS function counts the number of cells that meet multiple criteria in different ranges.
Question 22 of 50
In R, which function is used to find the unique values in a vector?
Correct answer:
A) unique()
Explanation: The unique() function in R returns the distinct values in a vector, excluding duplicates.
Question 23 of 50
In SQL, which function is used to return the remainder of a division operation?
Correct answer:
A) MOD
Explanation: The MOD function returns the remainder of a division operation in SQL.
Question 24 of 50
Which Excel function returns the number of characters in a text string?
Correct answer:
A) LEN
Explanation: The LEN function returns the number of characters in a text string, including spaces.
Question 25 of 50
In R, which function is used to sort the elements of a vector in ascending order?
Correct answer:
A) sort()
Explanation: The sort() function in R arranges the elements of a vector in ascending order.
Question 26 of 50
Which SQL function is used to return the current date?
Correct answer:
A) CURRENT_DATE
Explanation: The CURRENT_DATE function in SQL returns the current date without the time component.
Question 27 of 50
Which Excel function would you use to calculate the number of cells that are not empty?
Correct answer:
A) COUNTA
Explanation: The COUNTA function counts the number of cells that are not empty in a specified range.
Question 28 of 50
In R, which function is used to calculate the variance of a dataset?
Correct answer:
A) var()
Explanation: The var() function calculates the variance of numeric values in a dataset in R.
Question 29 of 50
In SQL, which function is used to return the maximum value in a numeric column?
Correct answer:
A) MAX
Explanation: The MAX function returns the highest numeric value in a specified column in SQL.
Question 30 of 50
Which Excel function is used to return the result of multiplying corresponding elements in two arrays?
Correct answer:
A) SUMPRODUCT
Explanation: The SUMPRODUCT function multiplies corresponding elements in two or more arrays and returns the sum of the results.
Question 31 of 50
In R, which function is used to read a CSV file into a dataframe?
Correct answer:
A) read.csv()
Explanation: The read.csv() function reads a CSV file and imports it as a dataframe in R.
Question 32 of 50
In SQL, which statement is used to update data in an existing row of a table?
Correct answer:
A) UPDATE
Explanation: The UPDATE statement modifies the values in one or more rows of an existing table in SQL.
Question 33 of 50
Which Excel function is used to return the sum of values that meet a specific condition?
Correct answer:
A) SUMIF
Explanation: The SUMIF function sums the values in a range that meet a specified condition in Excel.
Question 34 of 50
In R, which function is used to generate a sequence of numbers?
Correct answer:
A) seq()
Explanation: The seq() function generates a sequence of numbers with a specified interval in R.
Question 35 of 50
In SQL, which function returns the number of characters in a string?
Correct answer:
A) LENGTH
Explanation: The LENGTH function in SQL 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?
Correct answer:
A) MOD
Explanation: The MOD function returns the remainder when one number is divided by another in Excel.
Question 37 of 50
In R, which function is used to check if a value is infinite?
Correct answer:
A) is.infinite()
Explanation: The is.infinite() function checks if a value is infinite in R.
Question 38 of 50
In SQL, which clause is used to sort the result set of a query?
Correct answer:
A) ORDER BY
Explanation: The ORDER BY clause sorts the result set of a SQL query based on one or more columns.
Question 39 of 50
In Excel, which function would you use to round a number down to the nearest integer?
Correct answer:
A) FLOOR
Explanation: The FLOOR function rounds a number down to the nearest integer in Excel.
Question 40 of 50
In R, which function is used to remove duplicate rows from a dataframe?
Correct answer:
A) distinct()
Explanation: The distinct() function removes duplicate rows from a dataframe in R.
Question 41 of 50
Which SQL function is used to return the smallest value in a numeric column?
Correct answer:
A) MIN
Explanation: The MIN function returns the smallest numeric value in a specified column in SQL.
Question 42 of 50
Which Excel function would you use to count the number of cells that contain specific text?
Correct answer:
A) COUNTIF
Explanation: The COUNTIF function counts the number of cells that meet a specific condition, such as containing specific text.
Question 43 of 50
In R, which function is used to create a subset of a dataframe based on specific conditions?
Correct answer:
A) subset()
Explanation: The subset() function in R is used to create a subset of a dataframe based on specified conditions.
Question 44 of 50
In SQL, which clause is used to specify the condition for filtering rows in a query?
Correct answer:
A) WHERE
Explanation: The WHERE clause filters the rows returned by a SQL query based on specified conditions.
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?
Correct answer:
A) HLOOKUP
Explanation: The HLOOKUP function searches for a value in the first row of a table and returns a value from the same column in a specified row.
Question 46 of 50
In R, which function is used to combine multiple dataframes by rows?
Correct answer:
A) rbind()
Explanation: The rbind() function combines multiple dataframes by adding their rows together in R.
Question 47 of 50
In SQL, which function is used to calculate the average value of a numeric column?
Correct answer:
A) AVG
Explanation: The AVG function calculates the average value of a numeric column in SQL.
Question 48 of 50
Which Excel function is used to return the square root of a number?
Correct answer:
A) SQRT
Explanation: The SQRT function returns the square root of a number in Excel.
Question 49 of 50
In R, which function is used to apply a function to each element of a vector or list?
Correct answer:
A) lapply()
Explanation: The lapply() function applies a specified function to each element of a vector or list in R.
Question 50 of 50
In SQL, which function is used to concatenate two or more strings together?
Correct answer:
A) CONCAT
Explanation: The CONCAT function combines two or more strings into one in SQL.
Set 3 completeYou scored 0%
0 correct out of 0 answered (50 questions in this set).