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

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

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

Latest MCQs

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

(A) *

(B) +

(C) =

(D) $

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

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

(A) /

(B) =

(C) +

(D) &

Comments

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

Latest MCQs

Constant value in excel also called ...?

(A) Number

(B) words

(C) mark

(D) None

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Data

(B) Tools

(C) Formatting

(D) Layout

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

MS excel is used to data...?

(A) Organize

(B) Share

(C) Communicate

(D) Obtain

Comments

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

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

Comments

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

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

Comments

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

Latest MCQs

In MS Excel formula and function start with ____...?

(A) +

(B) -

(C) =

(D) [

Comments

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

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

Comments

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

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

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

Comments

Source: This question is taken from the Data Entry Operator in the Punjab Police 2020

Latest MCQs

Formula in Excell starts with...?

(A) +

(B) -

(C) =

(D) [

Comments

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

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

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

You can edit existing Excel data by pressing the:________ key...?

(A) F1 Key

(B) F2 Key

(C) F3 Key

(D) F4 Key

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

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) LRG

(B) AVG

(C) MAX

(D) None of these

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

Comments

Source: This question is taken from the Assistant Sub Inspector in the Punjab Police Department

Latest MCQs

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

(A) Menu

(B) Find and select

(C) Search

(D) Help

Comments

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

Latest MCQs

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

(A) Data

(B) Tools

(C) Formatting

(D) Layout

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

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

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

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

You can edit existing Excel Data by pressing the key...?

(A) F1 key

(B) F2 key

(C) F3 key

(D) F4 key

Comments

Source: This question is taken from the Data Entry Operator BS-14 Lahore High Court 2022

Latest MCQs

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

(A) /

(B) *

(C) $

(D) =

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

PPSC Past Papers