Which of the following returns a specific value in a one-dimensional range with reference to index?Answer choicesSelect only one optionREVISITTRIMLEFTRIGHTINDEX

Which of the following statement is true about INDEX function?Group of answer choicesIt returns a value at a specific row and column within a rangeIt returns the position of a value in a listYou can nest INDEX function within MATCH function to look up a value and return a related value in another columnAll of the answers are correct

Which of the following values indicate range?

Select the correct answerWhich of these is returned by “greater than”, “less than” and “equal to” operators?Optionsboolean valuesfloat valuesinteger valuesNone of the mentioned

In a 2D structure, what is represented by the first index?Group of answer choicesrowcolumn0None of the option given

In SQL, which operator is used to check if a value is within a specified range?OptionsIS NULLBETWEENINLIKE