What is the purpose of the VLOOUP function in Excel...? Mcqs

PPSC Past Papers

Latest MCQs

What is the purpose of the VLOOUP function in Excel...?

(A) To create a chart
(B) To sort data

(C) To find a value in a table based on a matching value in the first column
(D) None

Comments
Latest MCQs

What is the function of the VLOOKUP function in Excel...?

(A) To perform a vertical lookup and return a value based on a specified criteria
(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells
(D) To find the average of a range of cells

Comments
Latest MCQs

What does the VLOOKUP function do in Excel...?

(A) Count the number of cells
(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values
(D) Sorts data in ascending order

Comments
Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

Comments
Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link