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

Question

Accepted Answer

To perform a logical test and return a value based on the result

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

PPSC Past Papers

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

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

Function in MS Excel is known as ____...?

(A) Formula (B) Command

(C) Operation (D) None of these

What is the main function of MS Excel...?

(A) organized data (B) loss data

(C) gain data (D) none of these

The ______________ function in Excel returns the highest value in a set of data that you specify...?

(A) AVG (B) MAX

(C) LRG (D) None of these

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

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

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

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

Which one is not a Function in MS Excel...?

(A) SUMB (B) AVG

(C) MAX (D) MIN

Which one is not a function in MS Excel:...?

(A) SUM (B) AVG

(C) MAX (D) MIN

The ______ function in Excel returns the highest value in a set of data that you specify....?

(A) LRG (B) AVG

(C) MAX (D) None of these

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

IF function used in Excel for _____...?

(A) Performing logical comparisons (B) Formatting text

(C) Creating charts (D) None of these

Which one is not a function in MS Excel:...?

(A) SUM (B) AVG

(C) MAX (D) MIN

Which function in Excel tells how many numeric entries are there...?

(A) NUM (B) COUNT

(C) SUM (D) CHKNUM

MCQs Categories

Best of Luck

From ShineGk.com

Share our website's link

(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

(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

(A) Formula

(B) Command

(C) Operation

(D) None of these

(A) organized data

(B) loss data

(C) gain data

(D) none of these

(A) AVG

(B) MAX

(C) LRG

(D) None of these

(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

(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

(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

(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

(A) SUMB

(B) AVG

(C) MAX

(D) MIN

(A) SUM

(B) AVG

(C) MAX

(D) MIN

(A) LRG

(B) AVG

(C) MAX

(D) None of these

(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

(A) Performing logical comparisons

(B) Formatting text

(C) Creating charts

(D) None of these

(A) SUM

(B) AVG

(C) MAX

(D) MIN

(A) NUM

(B) COUNT

(C) SUM

(D) CHKNUM