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

PPSC Past Papers

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

________________________ is not a valid data type in excel...?

(A) Number

(B) Label

(C) Character

(D) none

✅ Correct Answer: Character

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which is the correct form in MS Excel...?

(A) 6A

(B) A6

(C) AA6

(D) +A+

✅ Correct Answer: A6

Comments

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

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

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

✅ Correct Answer: To temporarily hide certain data based on specific criteria

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 valid data type in Excel...?

(A) Number

(B) Character

(C) Label

(D) Date

✅ Correct Answer: Character

Comments

Source: This question is taken from the Assistant (bs-16) various departments Clubbed Case-74-2024 PPSC Past Paper (Morning)

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

To add two cells (A1 and A2) together in MS Excel,formula is used:...?

(A) =A1+A2

(B) =Add(A1+A2)

(C) =together(A1:A2)

(D) A1 plus A2

✅ Correct Answer: =A1+A2

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 🔊

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 🔊

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 🔊

Maximum zoom percentage in Excel is _________...?

(A) 100%

(B) 300%

(C) 400%

(D) 500%

✅ Correct Answer: 400%

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 🔊

A feature of MS Office that saves the document automatically after certain interval is called ____...?

(A) Save

(B) Save As

(C) Auto save

(D) None of the above

✅ Correct Answer: Auto save

Comments

Source: This question is taken from the Microsoft Word MCQs

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

A feature of MS Word that saves the document automatically after certain interval is available on___________...?

(A) Save tab on Options dialog box

(B) Save As dialog box

(C) Both of above

(D) None of above

✅ Correct Answer: Save tab on Options dialog box

Comments

Source: This question is taken from the Microsoft Word MCQs

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

Which of the following will not enter data in a cell...?

(A) Pressing the Esc key

(B) Pressing the Tab Key

(C) Both of these

(D) None of above

✅ Correct Answer: Pressing the Esc key

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The thin black cross-shaped pointer in MS Excel is used to _____...?

(A) Move a group of cells

(B) Highlight duplicate cells

(C) Complete lists and fill patterns

(D) None of these

✅ Correct Answer: Complete lists and fill patterns

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

While finding and replacing some data in Excel,which of following statement is valid...?

(A) You can Find and Replace within the sheet or workbook

(B) Excel does not have option to match case for find

(C) All

(D) None

✅ Correct Answer: You can Find and Replace within the sheet or workbook

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 enter the current date in Excel...?

(A) Ctrl+:

(B) Ctrl+Shift:

(C) Ctrl+;

(D) None of these

✅ Correct Answer: Ctrl+;

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Letters in Excel denote: ______________...?

(A) Columns

(B) rows

(C) numbers

(D) reference

✅ Correct Answer: Columns

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following methods can not be used to enter data in MS Excel cell:...?

(A) Pressing an arrow key

(B) Pressing the Tab key

(C) Pressing the Esc key-

(D) Clicking on the formula bar-

✅ Correct Answer: Pressing the Esc key-

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 🔊

A feature of MS Office that saves the document automatically after certain interval is called:...?

(A) Save

(B) Save as

(C) Auto save

(D) None of these

✅ Correct Answer: Auto save

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 🔊

Which of the following is correct syntax in Excel...?

(A) =IF(LogicalTest, TrueResult, FalseResult)

(B) =IF(LogicalTest, (TrueResult, FalseResult)

(C) =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

(D) =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

✅ Correct Answer: =IF(LogicalTest, TrueResult, FalseResult)

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 🔊

# value which type of error record in excel...?

(A) [\"numeric error\",\"syntax error\",\"excel does not recognize the formula\",\"None\"]

(B) empty

(C) empty

(D) empty

✅ Correct Answer: empty

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 GO TO tab in Ms Excel...?

(A) F1

(B) F3

(C) F6

(D) F5

✅ Correct Answer: F5

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of following is not a valid zoom percentage in Excel...?

(A) 10

(B) 100

(C) 300

(D) 500

✅ Correct Answer: 500

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 🔊

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 🔊

A feature of MS Office that saves the document automatically after certain interval is called:...?

(A) Save

(B) Save as

(C) Auto save

(D) None of these

✅ Correct Answer: Auto save

Comments

Source: This question is taken from the Junior Clerk Board of Revenue, Punjab-2023 43j2022

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

_____ is not a valid data type in excel...?

(A) Number

(B) Label

(C) Character

(D) none

✅ Correct Answer: Character

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which shortcut key switch to next worksheet tab in MS Excel...?

(A) Ctrl + Page up

(B) Ctrl + Home

(C) Ctrl + Page down

(D) Ctrl + End

✅ Correct Answer: Ctrl + Page down

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 🔊

How many worksheets are there in Excel by default:...?

(A) 01

(B) 03

(C) 05

(D) 07

✅ Correct Answer: 03

Comments

Source: This question is taken from the Lecturer Political Science Punjab Higher Education Department (Bs-17) 2022

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

Which chart type in Excel is best suited for showing the proportion of parts to a whole...?

(A) Pie Chart

(B) Bar Chart

(C) Lines Chart

(D) None of these

✅ Correct Answer: Pie Chart

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

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 🔊

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 🔊

How do you freeze panes in Excel...?

(A) Home tab and go to freeze panes

(B) View he tab and go to freeze panes

(C) Review tab and go to Freeze Panes

(D) Page layout tab and go to Freeze panes

✅ Correct Answer: View he tab and go to freeze panes

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Letters in Excel denote :...?

(A) Columns

(B) rows

(C) numbers

(D) reference

✅ Correct Answer: Columns

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How to duplicate values in cell range in Excel 2016...?

(A) Click the conditional formatting button in the styles group of the theme

(B) Select the range of cell in the work sheet

(C) Both A and B

(D) None of these

✅ Correct Answer: Select the range of cell in the work sheet

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 term pertaining to spreadsheets...?

(A) cell

(B) character

(C) browser

(D) formula

✅ Correct Answer: browser

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 valid Zoom percentage in Excel...?

(A) 10

(B) 100

(C) 300

(D) 500

✅ Correct Answer: 500

Comments

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

💡 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 the use of proper text in MS Excel...?

(A) Engineered

(B) Convert your input text to proper case

(C) Original

(D) None of these

✅ Correct Answer: Convert your input text to proper case

Comments

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

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

What does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns

(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria

(D) To create a chart

✅ Correct Answer: To temporarily hide certain data based on specific criteria

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

PPSC Past Papers