In Excel, what is the function of the F11 key...?

PPSC Past Papers

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

In Excel, what is the function of the F11 key...?

(A) Save the workbook

(B) Toggle full-screen mode on/off

(C) Insert a new worksheet

(D) Open the print preview

✅ Correct Answer: Insert a new worksheet

Comments

Explanation:

In Excel, pressing the "F11" key creates a new chart sheet based on the currently selected data range, essentially allowing you to quickly generate a chart from the highlighted cells in a separate chart sheet.

Source: This question is taken from the Assistant (S&GAD) PPSC Past Paper 2024

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

MS Excel's function arguments are always written in _______ ....?

(A) Cell

(B) Row

(C) Colomn

(D) Parenthesis

✅ Correct Answer: Parenthesis

Comments

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

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

Microsoft Excel functions arguments are always written in __ ...?

(A) Rows

(B) Cells

(C) Columns

(D) Parentheses

✅ Correct Answer: Parentheses

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel, which function automatically total a column or row of values...?

(A) TOTAL

(B) ADD

(C) SUM

(D) AVG

✅ Correct Answer: SUM

Comments

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

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

In Ms Excel, which of the following special function keys allow the content in cell...?

(A) Shift

(B) Esc

(C) Tab

(D) Space

✅ Correct Answer: Space

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel, _____ function calculates the square root of a number....?

(A) SQR

(B) SQRT

(C) SQUARE

(D) None of these

✅ Correct Answer: SQRT

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel function to return one value if a condition is true and another value if it's false:...?

(A) If function

(B) Sum function

(C) Decimal function

(D) Info function

✅ Correct Answer: If function

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 🔊

In Excel, what is the function of the F11 key...? Mcqs

PPSC Past Papers