IF function used in Excel for _____...?

PPSC Past Papers

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

IF function used in Excel for _____...?

(A) Performing logical comparisons

(B) Formatting text

(C) Creating charts

(D) None of these

✅ Correct Answer: Performing logical comparisons

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Maximum zoom percentage in Excel is _________...?

(A) 100%

(B) 300%

(C) 400%

(D) 500%

✅ Correct Answer: 400%

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box

(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar

(D) You can not set page border in Excel

✅ Correct Answer: You can not set page border in Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) SUM

(B) AVG

(C) MAX

(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Actual working area of Computer’s Microsoft Excel is ________ ...?

(A) Workbook

(B) Worksheet

(C) Notesheet

(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

In MS Excel ______ shortcut key is used for hiding rows....?

(A) Ctrl+H

(B) Ctrl+7

(C) Ctrl+9

(D) None of the above

✅ Correct Answer: Ctrl+9

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

The valid data type in MS Excel is _____...?

(A) Boolean

(B) Tupal

(C) Dictionary

(D) None of these

✅ Correct Answer: Boolean

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) NUM

(B) COUNT

(C) SUM

(D) CHKNUM

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) SUM

(B) AVG

(C) MAX

(D) MIN

✅ Correct Answer: AVG

Comments

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

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) organized data

(B) loss data

(C) gain data

(D) none of these

✅ Correct Answer: organized data

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Move to the next cell in the row in MS Excel _____...?

(A) Tab

(B) Shift

(C) Space

(D) None of these

✅ Correct Answer: Tab

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

The formula = (B3+B4+B5+B6)/4 would have the same result as the function _______...?

(A) =SUM (B3:B6)

(B) =AVERAGE (B3:B6)

(C) =MAX (B3:B6)

(D) None of these

✅ Correct Answer: =AVERAGE (B3:B6)

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

In Excel, to calculate the product of numbers, the function used is _____...?

(A) =MULTIPLY()

(B) =PRODUCTSUM()

(C) =PRODUCE()

(D) =PRODUCT()

✅ Correct Answer: =PRODUCT()

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Shortcut key to insert a new worksheet in Excel is _______...?

(A) Shift + F8

(B) Shift + F9

(C) Shift + F10

(D) Shift + F11

✅ Correct Answer: Shift + F11

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

In Excel, to perform addition, the function used is _____...?

(A) =ADD()

(B) =SUM()

(C) =TOTAL()

(D) =PLUS()

✅ Correct Answer: =SUM()

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Function of a_________ is similar to that of a mouse...?

(A) Joystick

(B) Keyboard

(C) Camera

(D) Monitor

✅ Correct Answer: Joystick

Comments

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Autosave default time in MS Excel is ________....?

(A) 10 hours

(B) 10 minutes

(C) 10 second

(D) None of these

✅ Correct Answer: 10 minutes

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

The Function ________ in Excel is used to look up information in a table and extract the corresponding data....?

(A) FETCH

(B) GET

(C) VLOOKUP

(D) LET

✅ Correct Answer: VLOOKUP

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) Formula

(B) Command

(C) Operation

(D) None of these

✅ Correct Answer: Formula

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

The Maximum number of rows in MS-Excel is ______...?

(A) 1200000

(B) 1048576

(C) 1020239

(D) None of these

✅ Correct Answer: 1048576

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

Another name for a pre programmed formula in excel is ___________...?

(A) Cell

(B) Graph

(C) Function

(D) Range

✅ Correct Answer: Function

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

What is active cell in MS-Excel ______...?

(A) Rectangular box

(B) Pointer

(C) Nearing point of view

(D) None of the above

✅ Correct Answer: Rectangular box

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

(A) SUMB

(B) AVG

(C) MAX

(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 English word par Double-Click karein: Urdu meaning + pronunciation 🔊

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

IF function used in Excel for _____...? Mcqs

PPSC Past Papers