How can you sum up a range of cells in Excel...?

PPSC Past Papers

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

How can you sum up a range of cells in Excel...?

(A) Use the SUM function

(B) Use the AVERAGE function

(C) Use the COUNT function

(D) Use the MAX function

✅ Correct Answer: Use the SUM function

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

✅ Correct Answer: A unit of data

Comments

Source: This question is taken from the Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

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

Where can you set the shading color of a range of cells in excel ...?

(A) Choose required color on Fill Color tool in Formatting toolbar

(B) Choose required color on Fill Color tool in Drawing toolbar

(C) Choose required color form Patterns tab of Format Cells dialog box

(D) All of these

✅ Correct Answer: All of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of following is an active cell in excel...?

(A) Cell address

(B) Range

(C) Formula

(D) Current cell

✅ Correct Answer: Current cell

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What will be the result of formula '=16/2^3' in a cell in MS Excel...?

(A) 512

(B) 124

(C) 2

(D) 124

✅ Correct Answer: 2

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which is correct form of Cell range in MS Excel:...?

(A) A1-B1

(B) A1:A10

(C) A1 to A10

(D) A1-A10

✅ Correct Answer: A1:A10

Comments

Source: This question is taken from the Administrative Officer (Bs-17), Administrator (Bs-16), Media Monitoring Officer (Bs-16), Information Officer (Bs-17), Estate Officer (Bs-16) 2024

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

Which is the shortcut key to display active cells in Excell...?

(A) Shift+Backspace

(B) Crtl+Backspace

(C) Alt+Backspace

(D) none

✅ Correct Answer: Shift+Backspace

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How to activate a cell in MS Excel...?

(A) Pressing an arrow key

(B) Clicking the cell

(C) Pressing the Tab key

(D) All of the above

✅ Correct Answer: All of the above

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

✅ Correct Answer: A unit of data

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE

(B) SUM

(C) COUNT

(D) None of these

✅ Correct Answer: AVERAGE

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which one cannot be used to enter data in a cell in MS Excel...?

(A) Pressing tab key

(B) Pressing arrow key

(C) Pressing Esc key

(D) clicking the enter button to the formula bar

✅ Correct Answer: Pressing Esc key

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which formula is used to find the number of numerical cells in a range of cells in Excel...?

(A) COUNTIF

(B) COUNT

(C) COUNTA

(D) None of these

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How can you sum up a range of cells in Excel...? Mcqs

PPSC Past Papers