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

PPSC Past Papers

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

In a computer spreadsheet rows are labeled ________ ...?

(A) by letters

(B) by numbers

(C) by cell references

(D) by symbols

✅ Correct Answer: by numbers

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

in a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of...?

(A) calculation

(B) formulas

(C) functions

(D) relative addressing

✅ Correct Answer: functions

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Which one is the spreadsheet application that comes with MS Office software group...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

(D) MS Access

✅ Correct Answer: MS Excel

Comments

Source: This question is taken from the Microsoft Word MCQs

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

Main window in a computer spreadsheet is called ___________ ...?

(A) Work book

(B) Work

(C) Account book

(D) Work sheet

✅ Correct Answer: Work book

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 an element of computer spreadsheet interface...?

(A) Pencil work

(B) Active cell

(C) Menu bar

(D) Workbook

✅ Correct Answer: Pencil work

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ...?

(A) Calculations

(B) Formulas

(C) Functions

(D) Relative addressing

✅ Correct Answer: Functions

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 🔊

How are data organized in a spreadsheet ...?

(A) Lines and spaces

(B) Layers and planes

(C) Rows and columns

(D) Height and width

✅ Correct Answer: Rows and columns

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ...?

(A) Decoration

(B) Data appearance

(C) Functions

(D) Charting

✅ Correct Answer: Charting

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Microsoft office suite spreadsheet program is...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

(D) None of these

✅ Correct Answer: MS Excel

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 a computer spreadsheet rows are labeled ?...?

(A) by letters

(B) by numbers

(C) by cell references

(D) by symbols

✅ Correct Answer: by numbers

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 🔊

Which one is the spreadsheet application that comes with MS Office software group:...?

(A) MS Word

(B) MS Excel

(C) MS PowerPoint

(D) MS Access

✅ Correct Answer: MS Excel

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 🔊

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 🔊

Which function key is used to refresh the current window:...?

(A) F4

(B) F5

(C) F8

(D) F9

✅ Correct Answer: F5

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 block of numbers is called-------...?

(A) workbook

(B) columns

(C) rows

(D) range

✅ Correct Answer: range

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ...?

(A) 7

(B) 1.5

(C) 2

(D) 12

✅ Correct Answer: 7

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

Microsoft Office Suite spreadsheet program is _________...?

(A) None of these

(B) Microsoft Word

(C) Microsoft Excel

(D) Microsoft PowerPoint

✅ Correct Answer: Microsoft Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, block of cells is called __________ ...?

(A) Workbook

(B) Function

(C) Column

(D) Range

✅ Correct Answer: Range

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The main window in a computer spreadsheet is called...?

(A) workbook

(B) work

(C) account book

(D) worksheet

✅ Correct Answer: workbook

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

An electronic spreadsheet consists of:...?

(A) Rows

(B) Columns

(C) Cells

(D) All of these

✅ Correct Answer: All of these

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 a computer spreadsheet, each cell contains a...?

(A) Label

(B) value

(C) formula

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

In a computer spreadsheet rows are labeled:...?

(A) By letters

(B) By numbers

(C) By cell references

(D) By symbols

✅ Correct Answer: By numbers

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

How are data organized in a spreadsheet...?

(A) Lines and spaces

(B) Layers and planes

(C) Rows and columns

(D) Height and width

✅ Correct Answer: Rows and 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 is not an element of a computer spreadsheet interface?...?

(A) Pencil work

(B) Active cell

(C) Menu bar

(D) Workbook

✅ Correct Answer: Pencil work

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 🔊

Which of the following is not an element of computer spreadsheet interface...?

(A) Workbook

(B) Menu bar

(C) Pencil work

(D) None of these

✅ Correct Answer: Pencil work

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, first part of number format describes __________ ...?

(A) Positive number

(B) Negative number

(C) Zero values

(D) Text values

✅ Correct Answer: Positive number

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

To create table of columns and rows for statistical or mathematical calculation using spreadsheet, which software is used...?

(A) Excel

(B) Word Pad

(C) Word Pertect

(D) Corel Draw

✅ Correct Answer: Excel

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

To create table of columns and rows for statistical or mathematical calculations using spreadsheet, which software is used...?

(A) Excel

(B) Word Pad

(C) Word Perfect

(D) Corel Draw

✅ Correct Answer: Excel

Comments

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

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

The vertical dimension of a spreadsheet is called...?

(A) Row

(B) Column

(C) Record

(D) Field

✅ Correct Answer: Column

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The horizontal and vertical lines on a spreadsheet are called:...?

(A) Grid-lines

(B) Block lines

(C) Sheets

(D) Cells

✅ Correct Answer: Grid-lines

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

What is the combination of row and column is called in a spreadsheet...?

(A) Line

(B) Column

(C) Range

(D) Cell

✅ Correct Answer: Cell

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 🔊

Main window in a computer spreadsheet is called:...?

(A) Workbook

(B) Work

(C) Account book

(D) Worksheet

✅ Correct Answer: Workbook

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 a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of...?

(A) calculation

(B) formulas

(C) functions

(D) relative addressing

✅ Correct Answer: functions

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 🔊

In a computer spreadsheet, cell range A3 through G3 should be keyed is as...?

(A) A3-G3

(B) A3:G3

(C) A3: G3

(D) A3 to G3

✅ Correct Answer: A3:G3

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, cell range A3 through G3 should be keyed in as _________ ...?

(A) A3-G3

(B) A3:G3

(C) A3?.G3

(D) A3 to G3

✅ Correct Answer: A3:G3

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In a computer spreadsheet, each cell contain a __________ ...?

(A) label

(B) Value

(C) Formula

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

Microsoft office spreadsheet program is ...?

(A) Microsoft word

(B) Microsoft excel

(C) Microsoft powerpoint

(D) none of these

✅ Correct Answer: Microsoft excel

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 F4 key in a Spreadsheet...? Mcqs

PPSC Past Papers