MS Excel MCQs - Fine MCQs

Fine MCQs

Fine Preparation

Fine MCQs

Fine Preparation

Welcome to your MS Excel 8

Which function displays row data in a column or column data in a row

Rows

Transpose

Hyperlink

Index

None

Which of the following is not an example of a value?

64%

450

June 5, 2014

Serial No.12345

None

How do you display current date only in MS Excel?

date ()

Today ()

now ()

time ()

None

When you copy a formula

Excel erases the original copy of the formula

Excel edits cell references in the newly copied formula

Excel adjusts absolute cell references

Excel doesn't adjust relative cell references

None

Which of the following formulas will Excel Not be able to calculate?

=SUM(Sales)-A3

=SUM(A1:A5)*.5

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

None

Time's up