Microsoft Excel Related Objective Question Answer

Q.1) A spreadsheet does not allow

A) Manipulation of data

B) Generation of graphs

C) Animations

D) Charts

Ans: C) Animations

Q.2) In Excel, the intersection of a row and a column is called

A) Square

B) Cubicle

C) Cell

D) Worksheet

Ans:- C) Cell

Q.3)  In Order to cell excel that we are entering a formula in a cell, the user must begin with an operator, such as :

A) $

B) @

C) =

D) #

Ans:- C) =

Q.4) The value of the excel expression = sum(3*6/3+0-4) is:

A) 2

B) 3

C) 1

D) 0

Ans: A) 2 

Q.5)  Which of the following function is used to find the positive square root of a number?

A) SQRT

B) ABS

C) ROOT

D) SQUAREROOT

Ans: A) SQRT