In MS Word, what is the function of CTRL + R...?

PPSC Past Papers

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

In MS Word, what is the function of CTRL + R...?

(A) Open the print dialogue

(B) Update the current web page

(C) Close the current window

(D) None of these

✅ Correct Answer: None of these

Comments

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

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

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 MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM

(B) SUBSTITUTE

(C) CLEAN

(D) REPT

✅ Correct Answer: TRIM

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which function can be used to calculate the monthly mortgage payment :...?

(A) PMT

(B) PV

(C) MORT

(D) None of these

✅ Correct Answer: PMT

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 🔊

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 🔊

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 🔊

What is the function of CTRL+N in Microsoft Word...?

(A) Save Document

(B) Open Document

(C) New Document

(D) Close Document

✅ Correct Answer: New Document

Comments

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

A computer cannot function without..?

(A) Microsoft Office

(B) Operating System

(C) Internet Connection

(D) Antivirus

✅ Correct Answer: Operating System

Comments

Source: This question is taken from the Sub Inspector BS 14 (open Marit) 2016

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

What is the function of CTRL+R in Microsoft Word...?

(A) Open the Print dialog box

(B) Update the current Web page

(C) Close the current window

(D) None of these

✅ Correct Answer: None of these

Comments

Source: This question is taken from the Microsoft Word MCQs

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

Which function in Excel tells how many numeric entries are there...?

(A) NUM

(B) COUNT

(C) SUM

(D) CHKNUM

✅ Correct Answer: COUNT

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 CTRL+O in Microsoft Word...?

(A) Save Document

(B) Print Document

(C) Close Document

(D) Open Document

✅ Correct Answer: Open Document

Comments

Source: This question is taken from the Microsoft Word MCQs

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

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

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

__________ function calculates the largest value in a set of numbers...?

(A) Average

(B) Count

(C) Min

(D) Max

✅ Correct Answer: Max

Comments

Source: This question is taken from the Assistant Sub Inspector in the Punjab Police Department

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

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

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

What is the function of CTRL+Q in Microsoft Word...?

(A) Paragraph formatting (Line Space and Paragraph Space)

(B) Close Word Application without saving Document

(C) Print Whole Document without confirmation

(D) Does nothing

✅ Correct Answer: Paragraph formatting (Line Space and Paragraph Space)

Comments

Source: This question is taken from the Microsoft Word MCQs

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

Which function will you use to enter current time in a woksheet cell ...?

(A) =time()

(B) =nowtime()

(C) =now()

(D) =currentTime()

✅ Correct Answer: =now()

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which file stored in computer that perform functions quickly while browsing:...?

(A) Cache

(B) Exe

(C) Cookies

(D) None of these

✅ Correct Answer: Cache

Comments

Source: This question is taken from the Assistant BS-16 Special Education Department

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

A computer cannot function without _____...?

(A) Microsoft Office

(B) Internet Connection

(C) Operating System

(D) Antivirus Protection

✅ Correct Answer: Operating System

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

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

Which function calculates the largest value in a set of numbers in Excel...?

(A) Average

(B) Count

(C) Minimum

(D) Maximum

✅ Correct Answer: Maximum

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

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

A computer cannot function without:...?

(A) Microsoft Office

(B) Operating System

(C) Internet Connector

(D) Antivirus Protection

✅ Correct Answer: Operating System

Comments

Source: This question is taken from the Assistant Sub Inspector in the Punjab Police Department

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

What is the function of Ctrl + B in Ms-Word...?

(A) It converts selected text into the next larger size of the same font

(B) It adds a line break to the document

(C) It makes tho selected text bold

(D) It applies Italic formatting t the selected text

✅ Correct Answer: It makes tho selected text bold

Comments

Source: This question is taken from the Microsoft Word MCQs

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

What is the function of CTRL+P in Microsoft Word...?

(A) Open Paragraph Dialog Box

(B) Open Page Format Dialog Box

(C) Open Save Dialog Box

(D) Open Print Dialog box

✅ Correct Answer: Open Print Dialog box

Comments

Source: This question is taken from the Microsoft Word MCQs

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

What category of functions is used in this formula = PMT (C10/12, CB, C9, 1)...?

(A) Logical

(B) Payment

(C) Financial

(D) None of these

✅ Correct Answer: Financial

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Clipboard function in MS-PowerPoint is ______...?

(A) Copy

(B) Insert

(C) Dashes

(D) None of these

✅ Correct Answer: Copy

Comments

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

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

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

In MS Word, what is the function of CTRL + R...? Mcqs

PPSC Past Papers