MCQS Of Ms Excel

The Most Frequent MCQS For CSS, FPSC, PPSC, SPSC, STS IBA, NTS, PTS, OTS

A block of cells is called?
(a) Workbook
(b) Function
(c) Cells
(d) Range
Answer: a

The result of a formula in a cell is?
(a) Display Value
(b) Label
(c) Value
(d) Range
Answer: c

On an Excel worksheet the active cell is indicated by?
(a) A dark white border
(b) A black white border
(c) A blinking border
(d) A dotted border
Answer: a

Default worksheets in a workbook are?
(a) 5
(b) 4
(c) 3
(d) 1
Answer: c

The correct cell address is?
(a) Cell 1
(b) Row 1
(c) D1
(d) None of these
Answer: c

There are two types of references in Excel formula. They are
(a) Relative & Absolute
(b) Formula & Value
(c) Text & Number
(d) None of these
Answer: a

If you want to to keep table headings visible, you can use
(a) Freeze headings
(b) Hold heading
(c) Hold panes
(d) Freeze panes
Answer: a

Which function displays row data into column or column data into row?
(a) Index
(b) Rows
(c) Hyperlink
(d) Transpose
Answer: d

When you insert an Excel file into a word document, the data are?
(a) Linked
(b) Embedded
(c) Hyperlinked
(d) Placed in a word table
Answer: d

What we say a function inside another function?
(a) Round
(b) Text
(c) Nested
(d) Sum
Answer: c

What term refers to a specific set of values saved with workbook?
(a) Trend line
(b) Range
(c) What – if analysis
(d) Scenario
Answer: d

In which of the flowchart symbols, the statement “IS A>B” is placed?
(a) Diamond
(b) Rectangular
(c) Parallelogram
(d) None of these
Answer: a

In BASIC LOG function refers to natural logarithm have Base?
(a) 10
(b) 100
(c) e
(d) None of these
Answer: c

How can you break the current column?
(a) Press Shift+Ctrl+Enter
(b) Press Ctrl+Shift+Enter
(c) Press Alt+Shift+Enter
(d) Both A & B
Answer: b

In the formula, which symbol specifies the fixed column or rows?
(a) *
(b) %
(c) $
(d) #
Answer: c

How can you display current date in MS Excel?
(a) Date ()
(b) Today ()
(c) Now ()
(d) Time ()
Answer: b

How can you display current date and time in MS Excel?
(a) Date ()
(b) Today ()
(c) Now ()
(d) Time ()
Answer: c

An Excel Workbook is a collection of?
(a) Charts
(b) Workbooks
(c) Worksheets
(d) Worksheets & Charts
Answer: d

The following is not valid data, type in Excel?
(a) Number
(b) Label
(c) Data/Time
(d) Character
Answer: d

What we call getting data from a cell located in a different sheet?
(a) Functioning
(b) Arranging
(c) Referencing
(d) Updating
Answer: c