Ctrl + D in MS Excel is used for...?

PPSC Past Papers

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

Ctrl + D in MS Excel is used for...?

(A) Fill down in the selection

(B) Open the font dialog box

(C) Both A and B

(D) None of these

✅ Correct Answer: Fill down in the selection

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Selected cell of excel...?

(A) Active Cell

(B) Cell No

(C) Formula cell

(D) None Of These

✅ Correct Answer: Active Cell

Comments

Source: This question is taken from the Senior Station Assistant (SSA) batch 6th & 7th Past Paper

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

Shortcut key to insert a new worksheet in Excel is _______...?

(A) Shift + F8

(B) Shift + F9

(C) Shift + F10

(D) Shift + F11

✅ Correct Answer: Shift + F11

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Shortcut in excell to insert new sheet...?

(A) Shift+F6

(B) Shift+F12

(C) Shift+F11

(D) Shift+A1

✅ Correct Answer: Shift+F11

Comments

Source: This question is taken from the Police Station Assistant (PSA) Batch 6th & 7th Past Paper

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

Microsoft excel is a powerful______...?

(A) Spreadsheet package

(B) Word processing package

(C) DBMS package

(D) None

✅ Correct Answer: Spreadsheet package

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook

(B) Worksheet

(C) Note sheet

(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Actual working area of Computer’s Microsoft Excel is ________ ...?

(A) Workbook

(B) Worksheet

(C) Notesheet

(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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 🔊

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook

(B) Worksheet

(C) Note sheet

(D) Notebook

✅ Correct Answer: Worksheet

Comments

Source: This question is taken from the Manager Auqaf BS 16 PPSC past papers solved

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

When typing character search criteria, Excel matches fields based on:...?

(A) Alphabetical order

(B) Capitalization

(C) Spelling

(D) Primary records

✅ Correct Answer: Spelling

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 🔊

Which of the following is associated with Excel program...?

(A) Graphic program

(B) Word Processor

(C) Presentation

(D) Spreadsheet

✅ Correct Answer: Spreadsheet

Comments

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

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

Which the following term does not pertain to Excel...?

(A) Browser

(B) Columns

(C) Work Book

(D) None of these

✅ Correct Answer: Browser

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the result of the Excel formula [7-3]×[4+3]/4...?

(A) 1

(B) 4

(C) 7

(D) 9

✅ Correct Answer: 7

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 🔊

Which keyboard shortcut is used to add comments in MS Office Excel Worksheet...?

(A) Alt + F2

(B) Ctrl + F12

(C) Shift + F5

(D) Shift + F2

✅ Correct Answer: Shift + F2

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Microsoft Excel 2019 files have a default extension of ________...?

(A) .Xlsx

(B) .Xls

(C) .excel

(D) .123

✅ Correct Answer: .Xlsx

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS-Excel two common wildcard characters that MS Excel recognizes are:...?

(A) * and?

(B) < and >

(C) ^ and /

(D) None of these

✅ Correct Answer: * and?

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 will be result of excel formula =5 + 2 * 3...?**

(A) 1

(B) 10

(C) 11

(D) 21

✅ Correct Answer: 11

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the default file format for Excel spreadsheets...?

(A) .xlsx

(B) .doc

(C) .ppt

(D) .pdf

✅ Correct Answer: .xlsx

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of following is an active cell in excel...?

(A) Cell address

(B) Range

(C) Formula

(D) Current cell

✅ Correct Answer: Current cell

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How many columns are in one Microsoft Excel sheet...?

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

✅ Correct Answer: 16,384

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

You can set border in Excel from ___...?

(A) From Line Style tool in Drawing toolbar

(B) You can not set page border in Excel

(C) From Border tool in Formatting toolbar

(D) none

✅ Correct Answer: You can not set page border in Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

You can edit existing Excel Data by pressing the key...?

(A) F1 key

(B) F2 key

(C) F3 key

(D) F4 key

✅ Correct Answer: F2 key

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 🔊

User-developed instructions for excel are called...?

(A) Program

(B) Macros

(C) Procedure

(D) All of these

✅ Correct Answer: Macros

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 🔊

Worksheet in excel by default ___...?

(A) 3

(B) 2

(C) 1

(D) 4

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

When you insert a Excel file to a Word document The Data are:...?

(A) Embedded

(B) Linked

(C) Hyperlink placed in word table

(D) None of these

✅ Correct Answer: Linked

Comments

Source: This question is taken from the OFFICE ASSISTANT (BS-16) Housing Urban Development

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

What is the extension of a Microsoft Excel file...?

(A) .msxcl

(B) .xcl

(C) .xlsx

(D) .xlsm

✅ Correct Answer: .xlsx

Comments

Source: This question is taken from the Intelligence Officer (Bs-14) Punjab Police, Special Branch Assistant (Bs-16) Cooperatives Department PPSC Past Paper 2024

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

You can edit existing Excel data by pressing the:________ key...?

(A) F1 Key

(B) F2 Key

(C) F3 Key

(D) F4 Key

✅ Correct Answer: F2 Key

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Microsoft Excel 2019 files have a default extension of___________...?

(A) .Xlsx

(B) .Xls

(C) .excel

(D) .123

✅ Correct Answer: .Xlsx

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which key is used to edit the selected cell in excel...?

(A) F2

(B) F10

(C) F4

(D) F8

✅ Correct Answer: F2

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

We can set Page Border in Excel from:...?

(A) From Border tab in Format Cells dialog box

(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar

(D) we cannot set page border in Excel

✅ Correct Answer: we cannot set page border in Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How many characters can be typed in a single cell in Excel ...?

(A) 256

(B) 1024

(C) 32767

(D) 65535

✅ Correct Answer: 32767

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How a cell can be edit on Excel sheet...?

(A) Edit contents of cell directly in cell

(B) Edit by typing in formula bar

(C) Edit mode

(D) All above mentioned

✅ Correct Answer: All above mentioned

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the symbol for the "not equal to" operator in Excel...?

(A) !=

(B) ~=

(C) <>

(D) None of these

✅ Correct Answer: <>

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

#Value! Error in Microsoft Excel represents:...?

(A) The width of the cell is less to display the answer

(B) Parameter provided to the function is of wrong data type

(C) Value of the answer needs to be round off

(D) When Excel does not recognize the format

✅ Correct Answer: Parameter provided to the function is of wrong data type

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 used to split long text in excel within the cell...?

(A) Wrap text

(B) Click next

(C) All

(D) None

✅ Correct Answer: Wrap text

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

When you insert an Excel File into a word document, the data are...?

(A) Hyperlinked

(B) Placed in a word table

(C) Linked

(D) Embedded

✅ Correct Answer: Linked

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 🔊

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

✅ Correct Answer: A unit of data

Comments

Source: This question is taken from the Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

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

Which key is used for Excel to select the whole column highlight...?

(A) Shift + space

(B) CTRL + space

(C) Alt + space

(D) None of these

✅ Correct Answer: CTRL + space

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

A worksheet in Excel is divided into _____...?

(A) Height & Width

(B) Layers & Planes

(C) Columns & Rows

(D) Lines & Spaces

✅ Correct Answer: Columns & Rows

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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

(A) Cells

(B) Rows

(C) Columns

(D) Parentheses

✅ Correct Answer: Parentheses

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 🔊

To return the reminder after the number is divided by a divisor in Excel we use the function...?

(A) ROUND ( )

(B) FACT ( )

(C) MOD ( )

(D) None

✅ Correct Answer: MOD ( )

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations

(B) Pivot table

(C) Sparkline

(D) Filter

✅ Correct Answer: Pivot table

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 🔊

The first cell in excel worksheet is labeled as _________...?

(A) AA

(B) A1

(C) Aa

(D) None of these

✅ Correct Answer: A1

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following way cannot be used to link excel worksheet data to a Word document...?

(A) With the right drag method

(B) With a hyperlink

(C) With the copy and paste special commands

(D) With the copy and paste buttons on the standard toolbar

✅ Correct Answer: With the copy and paste buttons on the standard toolbar

Comments

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

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

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box

(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar

(D) You can not set page border in Excel

✅ Correct Answer: You can not set page border in Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the result of the Excel formula (7-3)×(4+3)/4...?

(A) 6

(B) 7

(C) 8

(D) 5

✅ Correct Answer: 7

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

“Ctrl + Delete” Shortcut key is used in Ms Word to____________...?

(A) Delete the word just after the cursor

(B) Delete the word just before the cursor

(C) Delete the single letter just after the cursor

(D) Delete the single letter just before the cursor

✅ Correct Answer: Delete the word just after the cursor

Comments

Source: This question is taken from the Microsoft Word MCQs

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

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.

(B) A1, A2, etc.

(C) A, B, C, etc.

(D) None of these

✅ Correct Answer: 1, 2, 3, etc.

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 🔊

How many rows are in one Microsoft Excel sheet...?

(A) 65,536

(B) 16,384

(C) 1,048,576

(D) None of Above

✅ Correct Answer: 1,048,576

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which is true when you insert an excel worksheet into a word document...?

(A) word is the destination document

(B) excel is the destination document

(C) the worksheet is the destination document

(D) the document is the source document

✅ Correct Answer: word is the destination document

Comments

Source: This question is taken from the Microsoft Word MCQs

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

In Microsoft Excel, the file you create and edit is called:...?

(A) A form

(B) A ledger

(C) A table

(D) A workbook

✅ Correct Answer: A workbook

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Anti-Corruption Punjab Police

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

How many sheets are there in the Excel workbook by default...?

(A) 2

(B) 3

(C) 4

(D) 5

✅ Correct Answer: 3

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In Microsoft Excel, the file you create and edit is called...?

(A) A ledger

(B) A table

(C) A workbook

(D) None of these

✅ Correct Answer: A workbook

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The first cell in EXCEL worksheet is labeled as ____...?

(A) AA

(B) Aa

(C) A1

(D) None of these

✅ Correct Answer: A1

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is a cell in Excel...?

(A) A row

(B) A column

(C) A unit of data

(D) A unit of formatting

✅ Correct Answer: A unit of data

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Ctrl + D in MS Excel is used for...? Mcqs

PPSC Past Papers