Where is a list of all functions displayed:...? Mcqs

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

Where is a list of all functions displayed:...?

(A) Text box
(B) Dialog box

(C) Function box
(D) Category box

✅ Correct Answer: Function box

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

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

Which function displays row data into column or column data into row...?

(A) Hyperlink
(B) Index

(C) Transpose
(D) Rows

✅ Correct Answer: Transpose

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

in MS Excel what is function inside another function is called...?

(A) nested
(B) round

(C) switch
(D) none of these

✅ Correct Answer: nested

Comments

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

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

Which of the following function is used to get the current date...?

(A) Exact ()
(B) Today ()

(C) Month ()
(D) Year ()

✅ Correct Answer: Today ()

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

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

Which function displays row data into column or column data into a row?...?

(A) Hyperlink
(B) Index

(C) Transpose
(D) Rows

✅ Correct Answer: Transpose

Comments

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

💡 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 of following function is used to sum the values in a range that meet criteria that you specify...?

(A) SUM
(B) SUMIF

(C) SUMALL
(D) SUMANY

✅ Correct Answer: SUMIF

Comments

Source: This question is taken from the Microsoft Excel MCQs

Best of Luck

From ShineGk.com

Share our website's link