What function returns a value or reference of the cell at the intersection of a particular row and column in a given range?
Answer: INDEX(array,row_num,col_num)
Learn More :
Data Analytics
- What test do we use if population variances are known?
- What is an alternative step to the critical value comparison?
- What do we do if the test statistic is in the non rejection region?
- What do we do if the test statistic falls into a rejection region?
- What does the critical value do?
- How do know if we reject or fail to reject?
- We want the power of the test to be ___.
- The use of data to understand past and current business performance and make well informed decisions
- Getting a list of objects in the current workspace is done using what command?
- Which of the following will produce the square root of the number 65?
- What is the c() function in R?
- What assigned the calculation 4 multiples by 3 to the variable z?
- If you want to plot a bar chart, which of the following functions would you use?
- In order to add rows to a data frame, which function is the most appropriate?
- To compare two means, what is the best function to use?
- What is the value of the expression 2+NA
- To select two columns from a data frame called Clients, which of the following expressions is correct?
- The expression 2**4 returns
- When a query is successfully executed in Microsoft SQL Server Management Studio, the number of rows in the query result is indicated:
- In SSMS, when viewing the list of columns for a table in the object explorer, the field that if the primary key is identified by
- To import an Excel table into Access, where would go?
- In Access, what is true for two tables to be joined with another
- In the query design mode (Access), what can be entered into the "criteria" section for a "customer name" field that will result in a listing of all customer names beginning with the letter A?
- How do you ensure a certain field will always have a value in access?
- What data type in Access results in the field automatically being assigned the next higher number when a new record is created?