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

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

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

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

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

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

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 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

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

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

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

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

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

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

Best of Luck

From ShineGk.com

Share our website's link