What is the function of the SUM function in Excel:...? Mcqs

PPSC Past Papers

Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

Latest MCQs

What is the function of the IF function in Excel...?

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

(C) To find the average of a range of cells
(D) To count the number of cells in a range

✅ Correct Answer: To perform a logical test and return a value based on the result

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

Which of the following functions in Microsoft Excel is used to count items in a cell range...?

(A) COUNT
(B) AVERAGE

(C) SUM
(D) MAX

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Assistant Punjab Police Department PPSC Past Paper

Latest MCQs

MOD () function is used in MS excel to get...?

(A) Dividend
(B) Remainder

(C) Quotient
(D) None of these

✅ Correct Answer: Remainder

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which of following function in Microsoft Excel is used to count items in a cell range...?

(A) Count
(B) SUM

(C) MAX
(D) Average

✅ Correct Answer: Count

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which one is not a Function in MS Excel...?

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

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

Latest MCQs

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

✅ Correct Answer: Performing logical comparisons

Comments

Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved

Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

The Function ________ in Excel is used to look up information in a table and extract the corresponding data....?

(A) FETCH
(B) GET

(C) VLOOKUP
(D) LET

✅ Correct Answer: VLOOKUP

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which of the following is not a function in Microsoft Excel?...?

(A) SUM
(B) MAX

(C) MIN
(D) AVG

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Latest MCQs

VLOOKUP is a built-in function in Excel used to:...?

(A) Increases the font of text
(B) Prints the content of an Excel sheet

(C) Searches for a value in the column
(D) Deletes a value in the column

✅ Correct Answer: Searches for a value in the column

Comments

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

Latest MCQs

What does the VLOOKUP function do in Excel...?

(A) Count the number of cells
(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values
(D) Sorts data in ascending order

✅ Correct Answer: Searches for a value in a column and returns a value in the same row

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

✅ Correct Answer: Performing logical comparisons

Comments

Source: This question is taken from the Microsoft Excel MCQs

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link