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

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

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

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

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

Comments

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

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

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

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

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

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

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

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link