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

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

Latest MCQs

MS excel is used to data...?

(A) Organize

(B) Share

(C) Communicate

(D) Obtain

Comments

Latest MCQs

Constant value in excel also called ...?

(A) Number

(B) words

(C) mark

(D) None

Comments

Latest MCQs

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

(A) /

(B) =

(C) +

(D) &

Comments

Latest MCQs

Which device stores data permanently:...?

(A) Flash disk

(B) Hard disk

(C) DVD

(D) All of these

Comments

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

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

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

Comments

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

Latest MCQs

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

(A) /

(B) *

(C) $

(D) =

Comments

Latest MCQs

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

(A) Menu

(B) Find and select

(C) Search

(D) Help

Comments

Latest MCQs

Formula in Excell starts with...?

(A) +

(B) -

(C) =

(D) [

Comments

Latest MCQs

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

(A) Data

(B) Tools

(C) Formatting

(D) Layout

Comments

Latest MCQs

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

(A) Data

(B) Tools

(C) Formatting

(D) Layout

Comments

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

Latest MCQs

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

(A) Ascending order

(B) Descending order

(C) Both A & B

(D) None of these

Comments

Latest MCQs

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

(A) +

(B) -

(C) =

(D) [

Comments

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

Latest MCQs

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

(A) *

(B) +

(C) =

(D) $

Comments

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

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

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

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

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

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

Latest MCQs

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

PPSC Past Papers