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

PPSC Past Papers

💡 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 🔊

The freezing row and column in Excel is in which pane...?

(A) Freezing row

(B) Freezing column

(C) Freezing pane

(D) None of these

✅ Correct Answer: Freezing pane

Comments

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

💡 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 🔊

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 🔊

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 🔊

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 🔊

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM

(B) SUBSTITUTE

(C) CLEAN

(D) REPT

✅ Correct Answer: TRIM

Comments

Source: This question is taken from the Microsoft Excel MCQs

💡 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 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 🔊

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

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

MS-Excel uses the _____ function when creating a data table....?

(A) Average

(B) Count

(C) Both A and B

(D) Table

✅ Correct Answer: Table

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel formula and function start with ____...?

(A) +

(B) -

(C) =

(D) [

✅ Correct Answer: =

Comments

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

💡 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 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 🔊

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 file stored in computer that perform functions quickly while browsing:...?

(A) Cache

(B) Exe

(C) Cookies

(D) None of these

✅ Correct Answer: Cache

Comments

Source: This question is taken from the Assistant BS-16 Special Education Department

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

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________...?

(A) Smart tip

(B) Soft Tip

(C) Web Tip

(D) Cell Tip

✅ Correct Answer: Cell Tip

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following function key activates the speller in Ms Word...?

(A) F5

(B) F7

(C) F9

(D) Shift + F7

✅ Correct Answer: F7

Comments

Source: This question is taken from the Microsoft Word 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 🔊

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 🔊

Which function calculates the largest value in a set of numbers in Excel...?

(A) Average

(B) Count

(C) Minimum

(D) Maximum

✅ Correct Answer: Maximum

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

💡 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 🔊

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

PPSC Past Papers