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 statement is true about MATCH function?Group of answer choicesIt returns the position of a value in a listIt returns a value within a range.Its Match_type is always equal to 0Its Match _type is always equal to 1

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

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

The Excel function VLOOKUP looks up a value in the leftmost column of a table (specified by the table_array) and returns a value in the same row from a column you specify (col_index_num).Group of answer choicesTrueFalse

In forecasting, what is an index?Group of answer choicesIt is a single measure that weights multiple indicators and provides a measure of overall expectation.It is a stream of historical data, such as weekly sales.It is a time series that does not have trend, seasonal, or cyclical effects but is relatively constant and only exhibits random behavior.It is a measure that provides a complete forecast.