QUESTION ONE

Which of the following is the CORRECT one for the HLOOKUP function in excel?

[A]= HLOOKUP(lookup_value, [range_lookup], table_array, column_index_num)

Correct Incorrect Correct answer

[B]= HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Correct Incorrect Correct answer

[C]= HLOOKUP(lookup_value, column_index_num, [range_lookup], table_array)

Correct Incorrect Correct answer

[D]= HLOOKUP([range_lookup], lookup_value, table_array, column_index_num)

Correct Incorrect Correct answer

QUESTION TWO

Data analytics can be analysed at four levels:

Which of the following is the alternative description of Level 4?

[A]Predictive

Correct Incorrect Correct answer

[B]Descriptive

Correct Incorrect Correct answer

[C]Diagnostic

Correct Incorrect Correct answer

[D]Prescriptive

Correct Incorrect Correct answer

SECTION TWO

ANSWER ALL THE QUESTIONS IN SECTION TWO

CLICK ON THE ATTACHED LINK TO DOWNLOAD PART TWO QUESTIONS

Upload your answer to this question.

This response will be reviewed and graded after submission.

FUNCTIONAL BUDGET

Information