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

PPSC Past Papers

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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)

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

Latest MCQs

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

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link