VLOOKUP is a built-in function in Excel used to:...? Mcqs

PPSC Past Papers

Latest MCQs

VLOOKUP is a built-in function in Excel used to:...?

(A) Increases the font of text
(B) Prints the content of an Excel sheet

(C) Searches for a value in the column
(D) Deletes a value in the column

✅ Correct Answer: Searches for a value in the column

Comments

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

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

✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

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

✅ Correct Answer: To perform a logical test and return a value based on the result

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

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

✅ Correct Answer: To find a value in a table based on a matching value in the first column

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

✅ Correct Answer: Searches for a value in a column and returns a value in the same row

Comments

Source: This question is taken from the Microsoft Excel MCQs

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link