Which of the following is not a function in Microsoft Excel?...?

PPSC Past Papers

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

Which of the following is not a function in Microsoft Excel?...?

(A) SUM

(B) MAX

(C) MIN

(D) AVG

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

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

What is the extension of a Microsoft Excel file...?

(A) .msxcl

(B) .xcl

(C) .xlsx

(D) .xlsm

✅ Correct Answer: .xlsx

Comments

Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024

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

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 🔊

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 🔊

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 🔊

How many ways you can save a document in Microsoft word...?

(A) 3

(B) 2

(C) 1

(D) 5

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Word MCQs

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

In Microsoft Excel, the file you create and edit is called...?

(A) A ledger

(B) A table

(C) A workbook

(D) None of these

✅ Correct Answer: A workbook

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 of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching

(B) transpose

(C) matrix

(D) none

✅ Correct Answer: transpose

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a Windows PC, the shortcut key for redoing the last action in Microsoft PowerPoint is:...?

(A) CTRL + R

(B) CTRL + Z

(C) CTRL + Y

(D) CTRL + O

✅ Correct Answer: CTRL + Y

Comments

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

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

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations

(B) Pivot table

(C) Sparkline

(D) Filter

✅ Correct Answer: Pivot table

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 main purpose of Format Painter in Microsoft applications...?

(A) To insert images into a documents

(B) To change the font size

(C) to create the new styles

(D) To copy formatting from one place and paste it to another place

✅ Correct Answer: To copy formatting from one place and paste it to another place

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 🔊

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 🔊

Which of these software applications was not part of the first version of Microsoft Office...?

(A) PowerPoint

(B) Outlook

(C) Paint

(D) None

✅ Correct Answer: Outlook

Comments

Source: This question is taken from the Microsoft PowerPoint MCQs

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

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook

(B) Worksheet

(C) Note sheet

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

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook

(B) Worksheet

(C) Note sheet

(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved

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

How many columns are in one Microsoft Excel sheet...?

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

✅ Correct Answer: 16,384

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In Microsoft Excel, the file you create and edit is called:...?

(A) A form

(B) A ledger

(C) A table

(D) A workbook

✅ Correct Answer: A workbook

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Anti-Corruption Punjab Police

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

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 Manager Auqaf BS 16 PPSC past papers solved

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

Which of the following functions in Microsoft Excel is used to count items in a cell range...?

(A) COUNT

(B) AVERAGE

(C) SUM

(D) MAX

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

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

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

Which of following function in Microsoft Excel is used to count items in a cell range...?

(A) Count

(B) SUM

(C) MAX

(D) Average

✅ Correct Answer: Count

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 🔊

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 🔊

#Value! Error in Microsoft Excel represents:...?

(A) The width of the cell is less to display the answer

(B) Parameter provided to the function is of wrong data type

(C) Value of the answer needs to be round off

(D) When Excel does not recognize the format

✅ Correct Answer: Parameter provided to the function is of wrong data type

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

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

In Microsoft Excel, press___________ key to enter a new line within a cell...?

(A) Ctrl+ Enter

(B) Alt+ Enter

(C) Shift+ Enter

(D) Ctrl+Shift+Enter

✅ Correct Answer: Alt+ Enter

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 🔊

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 🔊

How many rows are in one Microsoft Excel sheet...?

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

✅ Correct Answer: 1,048,576

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.

(B) A1, A2, etc.

(C) A, B, C, etc.

(D) None of these

✅ Correct Answer: 1, 2, 3, etc.

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a windows pc, the shortcut key for redoing the last action in Microsoft PowerPoint is __________...?

(A) CTRL+R

(B) CTRL+Z

(C) CTRL+Y

(D) CTRL+ O

✅ Correct Answer: CTRL+Y

Comments

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

Which of the following is not a function in Microsoft Excel?...? Mcqs

PPSC Past Papers