MS Excel Objective Questions and Answers - 1

Question: 1

DOS based spreadsheet package is

(A) Smartsheet

(B) Excel

(C) Spread PRO

(D) Lotus 1-2-3

Ans: D

Lotus 1-2-3

Question: 2

When we can create a chart on a separate sheet in the same workbook, it is called a

(A) Chart sheet

(B) Embedded chart

(C) View sheet

(D) View chart

Ans: A

Chart sheet

Question: 3

____ sign is used to create an absolute cell reference.

(A) $

(B) @

(C) &

(D) %

Ans: A

$

Question: 4

# VALUE! Refers to ___

(A) Font value

(B) Error in value

(C) Subscript of the number value

(D) Addition of value

Ans: B

Error in value

Question: 5

You can undo and redo up to ____ action in Microsoft Office Excel, even after a worksheet is saved.

(A) 50

(B) 99

(C) 100

(D) 500

Ans: A

50

Related Questions