In MS Excel you can sort data in ...? Mcqs

PPSC Past Papers

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

In MS Excel you can sort data in ...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

✅ Correct Answer: Both A & B

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 Excel, you can sort data in...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

✅ Correct Answer: Both A & B

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 🔊

With which of the following all formulas in excel starts ...?

(A) /
(B) *

(C) $
(D) =

✅ Correct Answer: =

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The Function ________ in Excel is used to look up information in a table and extract the corresponding data....?

(A) FETCH
(B) GET

(C) VLOOKUP
(D) LET

✅ Correct Answer: VLOOKUP

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

The ______ function in Excel returns the highest value in a set of data that you specify....?

(A) LRG
(B) AVG

(C) MAX
(D) None of these

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

MS excel is used to data...?

(A) Organize
(B) Share

(C) Communicate
(D) Obtain

✅ Correct Answer: Organize

Comments

Source: This question is taken from the Sub Inspector Service Quota Punjab Police Department

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

In MS Excel, to create a formula, you can use:...?

(A) Values but not cell references
(B) Cell references but not values

(C) Values or cell references although notboth at the same time
(D) Both value and cell references

✅ Correct Answer: Both value and cell references

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 🔊

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

✅ Correct Answer: =

Comments

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

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

In Excel data series is ...?

(A) A row or column of numbers that are plotted in a chart
(B) Spreed sheet

(C) Work sheet
(D) None

✅ Correct Answer: A row or column of numbers that are plotted in a chart

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

✅ Correct Answer: Number

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

In MS Excel to add two cells (A1 and A2) togather you use the following formula...?

(A) = add(A1+A2)
(B) = A1+A2

(C) = together A1:A2
(D) None of these

✅ Correct Answer: = A1+A2

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

A formula in MS Excel starts with a________ symbol...?

(A) *
(B) +

(C) =
(D) $

✅ Correct Answer: =

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 device stores data permanently:...?

(A) Flash disk
(B) Hard disk

(C) DVD
(D) All of these

✅ Correct Answer: All of these

Comments

Source: This question is taken from the Administrative Officer (Bs-17), Administrator (Bs-16), Media Monitoring Officer (Bs-16), Information Officer (Bs-17), Estate Officer (Bs-16) 2024

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

The ______________ function in Excel returns the highest value in a set of data that you specify...?

(A) AVG
(B) MAX

(C) LRG
(D) None of these

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

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

Go To command in Excel is located in...?

(A) Menu
(B) Find and select

(C) Search
(D) Help

✅ Correct Answer: Find and select

Comments

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

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

In MS-Excel, for arranging data in ascending or descending order the command used is...?

(A) Filter in review tab
(B) Filter in data tab

(C) Sort in data tab
(D) Sort in review tab

✅ Correct Answer: Sort in data tab

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 pointor in MS Excel is used to:...?

(A) Complete lists and fill patterns
(B) Move a group of cells

(C) Resize
(D) Highlight duplicate cells

✅ Correct Answer: Complete lists and fill patterns

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 🔊

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 🔊

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 🔊

In MS Excel to delete duplicate values which menu is used...?

(A) Data
(B) Tools

(C) Formatting
(D) Layout

✅ Correct Answer: Data

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

In MS Excel to delete duplicate values which menu is used:...?

(A) Data
(B) Tools

(C) Formatting
(D) Layout

✅ Correct Answer: Data

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 🔊

With which of the following all formulas in MS excel starts:...?

(A) /
(B) =

(C) +
(D) &

✅ Correct Answer: =

Comments

Source: This question is taken from the Land Records Junior Clerk BS-11 NTS past papers

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

How can you make MS Word data password-protected...?

(A) File > Save As > Password
(B) File > Options > Security

(C) File > Info > Protect Document
(D) None of these

✅ Correct Answer: File > Info > Protect Document

Comments

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

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link