How many types of references are used in Excel:...?

PPSC Past Papers

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

How many types of references are used in Excel:...?

(A) 3

(B) 4

(C) 5

(D) 6

✅ Correct Answer: 3

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 does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

✅ Correct Answer: To temporarily hide certain data based on specific criteria

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of...?

(A) Absolute refrence

(B) Relative reference

(C) mixed reference

(D) circular reference

✅ Correct Answer: Relative reference

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 worksheets are there in Excel by default:...?

(A) 01

(B) 03

(C) 05

(D) 07

✅ Correct Answer: 03

Comments

Source: This question is taken from the Lecturer Political Science Punjab Higher Education Department (Bs-17) 2022

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

Which sign is used to create an absolute cell reference in MS Excel...?

(A) $

(B) @

(C) &

(D) %

✅ Correct Answer: $

Comments

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

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

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

✅ Correct Answer: To temporarily hide certain data based on specific criteria

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

If a formula references a cell that contains text instead of a numerical value, what error does Excel display...?

(A) #NUM!

(B) #VALUE!

(C) #REF!

(D) #DIV0

✅ Correct Answer: #VALUE!

Comments

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

How many types of references are used in Excel:...? Mcqs

PPSC Past Papers