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

PPSC Past Papers

Latest MCQs

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

Latest MCQs

Which Excel function is used to add the current system date...?

(A) DATE()

(B) NOW()

(C) TODAY()

(D) CURRENT_DATE()

✅ Correct Answer: TODAY()

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

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

PPSC Past Papers