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

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 🔊

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 the maximum value in a range of cells

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching

(B) transpose

(C) matrix

(D) none

✅ Correct Answer: transpose

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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 is not the function of the operating system...?

(A) Linux

(B) DOS

(C) Oracle

(D) Window

✅ Correct Answer: Oracle

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

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

(A) To perform a vertical lookup and return a value based on a specified criteria

(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells

(D) To find the average of a range of cells

✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

A function inside another function in called _____...?

(A) Text function

(B) Sum function

(C) Round function

(D) Nested function

✅ Correct Answer: Nested function

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Programs written to make computer function in a desired way are called:...?

(A) Codes

(B) Instructions

(C) Hardware

(D) Software

✅ Correct Answer: Software

Comments

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

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

Which of the following function key activates the speller in Ms Word...?

(A) F5

(B) F7

(C) F9

(D) Shift + F7

✅ Correct Answer: F7

Comments

Source: This question is taken from the Microsoft Word 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 🔊

What is the function of the F4 key in most systems...?

(A) System Settings

(B) Close a Window

(C) Repeat Last Action

(D) Refresh Page

✅ Correct Answer: Repeat Last Action

Comments

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

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

Function key to go to a specific cell in MS Excel is:...?

(A) F4

(B) F5

(C) F6

(D) None of these

✅ Correct Answer: F5

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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

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

Which function is use to display the current date and time in a cell:...?

(A) Today

(B) Now

(C) Day

(D) Current

✅ Correct Answer: Now

Comments

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

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

Which function is not available in the consolidate dialogue box ...?

(A) Average

(B) Max

(C) Pmt

(D) None

✅ Correct Answer: Pmt

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which is not the function of "Edit clear command"...?

(A) Delete cells

(B) Delete notes

(C) Delete contents

(D) None

✅ Correct Answer: Delete cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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

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

In a computer spreadsheet, a function that is used to count a number of entries in a given range is called...?

(A) length

(B) counter

(C) counting

(D) count

✅ Correct Answer: count

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel formula and function start with ____...?

(A) +

(B) -

(C) =

(D) [

✅ Correct Answer: =

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

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

What is the function of the F4 key in a Spreadsheet...?

(A) Change font

(B) Repeat the last action

(C) Choose open command

(D) Open bookmark

✅ Correct Answer: Repeat the last action

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the primary function of the register in a CPU:...?

(A) Quickly accept, store, and transfer data and instructions

(B) To manage the CPU's cache memory

(C) To control the flow of instructions

(D) To handle memory management

✅ Correct Answer: Quickly accept, store, and transfer data and instructions

Comments

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

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

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

PPSC Past Papers