✅ Correct Answer: AVG
Source: This question is taken from the Data Entry Operator in the Punjab Police 2020
✅ Correct Answer: Performing logical comparisons
Source: This question is taken from the Microsoft Excel MCQs
✅ Correct Answer: Outlook
Source: This question is taken from the Microsoft PowerPoint MCQs
✅ Correct Answer: MAX
Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department
✅ Correct Answer: Formula
Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024
Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved
✅ Correct Answer: Worksheet
✅ Correct Answer: COUNT
Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper
✅ Correct Answer: 1, 2, 3, etc.
✅ Correct Answer: 1,048,576
✅ Correct Answer: CTRL + Y
Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024
✅ Correct Answer: A workbook
✅ Correct Answer: 16,384
✅ Correct Answer: To perform a logical test and return a value based on the result
✅ Correct Answer: Searches for a value in a column and returns a value in the same row
✅ Correct Answer: transpose
✅ Correct Answer: organized data
✅ Correct Answer: To add up a range of cells
✅ Correct Answer: To copy formatting from one place and paste it to another place
Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers
✅ Correct Answer: Searches for a value in the column
✅ Correct Answer: Pivot table
Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024
Source: This question is taken from the Assistant Sub Inspector (ASI) Anti-Corruption Punjab Police
✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria
✅ Correct Answer: Count
✅ Correct Answer: CTRL+Y
✅ Correct Answer: Parameter provided to the function is of wrong data type
Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023
✅ Correct Answer: Alt+ Enter
Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR
✅ Correct Answer: .xlsx
Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024
✅ Correct Answer: To find a value in a table based on a matching value in the first column
✅ Correct Answer: Only A & B
Source: This question is taken from the Microsoft Word MCQs
✅ Correct Answer: 3