A cell is defined as...?

PPSC Past Papers

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

A cell is defined as...?

(A) Intersection of rows and columns

(B) An input box

(C) A rectangular box

(D) None of these

✅ Correct Answer: Intersection of rows and columns

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 🔊

The Footnote Text style defines characters as ___________...?

(A) 12-point Times New Roman and paragraphs as single-spaced and right-aligned

(B) 10-point Times New Roman and paragraphs as double-spaced and left-aligned

(C) 12-point Times New Roman and paragraphs as double-spaced and right-aligned

(D) 10-point Times New Roman and paragraphs as single-spaced and left-aligned

✅ Correct Answer: 10-point Times New Roman and paragraphs as single-spaced and left-aligned

Comments

Source: This question is taken from the Microsoft Word MCQs

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

MS Excel displays the address of the active cell in the:...?

(A) Formula bar

(B) Status bar

(C) Tool bar

(D) Menu bar

✅ Correct Answer: Formula bar

Comments

Source: This question is taken from the Assistant Director BS-17 Home Department

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

Which sign is used to create an absolute cell reference in MS Excel...?

(A) $

(B) @

(C) &

(D) %

✅ Correct Answer: $

Comments

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

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

In Ms Word AutoCorrect was originally designed to replace _________ words as you type....?

(A) Grammatically incorrect

(B) Short, repetitive

(C) Misspelled

(D) None of the above

✅ Correct Answer: Misspelled

Comments

Source: This question is taken from the Microsoft Word 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 Junior Clerk (BS-11) Board of Revenue PPSC Past Paper

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

What is active cell in MS-Excel ______...?

(A) Rectangular box

(B) Pointer

(C) Nearing point of view

(D) None of the above

✅ Correct Answer: Rectangular box

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The column heading in the spreadsheet are identified by _________...?

(A) Alphabets

(B) Numbers

(C) Symbels

(D) None of these

✅ Correct Answer: Alphabets

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Use a _________ list to sort or fill in a user-defined order....?

(A) Auto Fill Options

(B) Fill Series

(C) Custom List

(D) none

✅ Correct Answer: Custom List

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

________the cell pointer indicates that you can fill series...?

(A) Doctor’s symbol (Big Plus)

(B) Small thin plus icon

(C) Mouse Pointer with anchor at the tip

(D) None

✅ Correct Answer: Small thin plus icon

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

A __________ is a collection of Predefined design elements and color schemes....?

(A) feature

(B) hyperlink

(C) palette

(D) theme

✅ Correct Answer: theme

Comments

Source: This question is taken from the Microsoft Word MCQs

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

In Power Point ________ contains pre-defined ...?

(A) Graphics

(B) Theme

(C) Texture

(D) Gradient

✅ Correct Answer: Theme

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 🔊

--- is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon

(B) Single colon

(C) Double sami colon

(D) None of these

✅ Correct Answer: Single colon

Comments

Source: This question is taken from the Microsoft PowerPoint MCQs

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

Select a ________ to apply a predefined format to a Word 2016 table...?

(A) Table style

(B) Table format

(C) Format Style

(D) None of above

✅ Correct Answer: Table style

Comments

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

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 🔊

Ellipse motion is a predefined ___...?

(A) Design template

(B) Animation scheme

(C) color scheme

(D) None of these

✅ Correct Answer: Animation scheme

Comments

Source: This question is taken from the Microsoft PowerPoint MCQs

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

In MS Excel the command used to combine /merge the consecutively selected cells andcenter aligned is:...?

(A) Combine & Center

(B) Merge & Center

(C) Merge Cells

(D) Combine

✅ Correct Answer: Merge & Center

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 PowerPoint ____ contain pre defined...?

(A) Graphics

(B) Themes

(C) Texture

(D) Gradient

✅ Correct Answer: Themes

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 🔊

How can you sum up a range of cells in Excel...?

(A) Use the SUM function

(B) Use the AVERAGE function

(C) Use the COUNT function

(D) Use the MAX function

✅ Correct Answer: Use the SUM function

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 🔊

Which formula is used to find the number of numerical cells in a range of cells in Excel...?

(A) COUNTIF

(B) COUNT

(C) COUNTA

(D) None of these

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Move to the next cell in the row in MS Excel _____...?

(A) Tab

(B) Shift

(C) Space

(D) None of these

✅ Correct Answer: Tab

Comments

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

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

Which is the shortcut key to display active cells in Excell...?

(A) Shift+Backspace

(B) Crtl+Backspace

(C) Alt+Backspace

(D) none

✅ Correct Answer: Shift+Backspace

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the cell pointer indicates you that you make selection ...?

(A) Mouse Pointer with anchor at the tip

(B) Small thin plus icon

(C) Doctor’s symbol (Big Plus)

(D) None

✅ Correct Answer: Doctor’s symbol (Big Plus)

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 🔊

In Ms Word the AutoCorrect was originally designed to replace _________ words as you type....?

(A) Grammatically incorrect

(B) Short, repetitive

(C) Misspelled

(D) None of the above

✅ Correct Answer: Misspelled

Comments

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

Which of the following is an absolute cell reference...?

(A) $A$1

(B) #A#1

(C) !A1

(D) None of these

✅ Correct Answer: $A$1

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

______ the cell pointer indicate that you can move the content to other cell ....?

(A) Doctor’s symbol (Big Plus)

(B) Mouse Pointer with anchor at the tip

(C) Small thin plus icon

(D) All

✅ Correct Answer: Mouse Pointer with anchor at the tip

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 🔊

In MS-Excel when you are typing an equation into a cell the first thing that must be entered is...?

(A) The first cell referenced

(B) Parenthesis

(C) Quotation marks

(D) An equal sign

✅ Correct Answer: An equal sign

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

move to the next cell in the sheet in ms excel....?

(A) ctrl + page down

(B) shift + page down

(C) page down

(D) none of these

✅ Correct Answer: shift + page down

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 🔊

_________ is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon

(B) Single colon

(C) Double sami colon

(D) None of these

✅ Correct Answer: Single colon

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 🔊

In Microsoft Excel the Intersection of columns and rows is called a:...?

(A) Data

(B) Table

(C) Cell

(D) Schema for:

✅ Correct Answer: Cell

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 cell referencing that does not change when copied is:...?

(A) Absolute

(B) Comparative

(C) Relative cell addressing

(D) Reference

✅ Correct Answer: Absolute

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 🔊

Where can you set the shading color of a range of cells in excel ...?

(A) Choose required color on Fill Color tool in Formatting toolbar

(B) Choose required color on Fill Color tool in Drawing toolbar

(C) Choose required color form Patterns tab of Format Cells dialog box

(D) All of these

✅ Correct Answer: All of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE

(B) SUM

(C) COUNT

(D) None of these

✅ Correct Answer: AVERAGE

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which file format is typically opened in word processing software...?

(A) MS Doc

(B) XLX

(C) PDF

(D) None of these

✅ Correct Answer: MS Doc

Comments

Source: This question is taken from the Microsoft Word MCQs

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

How is a selected cell indicated in MS Excel...?

(A) Dotted line

(B) Double line

(C) Wide bold line

(D) Single line

✅ Correct Answer: Wide bold line

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

A cell is defined as...? Mcqs

PPSC Past Papers