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

PPSC Past Papers

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

How many characters can be typed in a single cell in Excel ...?

(A) 256
(B) 1024

(C) 32767
(D) 65535

✅ Correct Answer: 32767

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link