MS EXCEL

Referencing in =$B3+B$4 formula is

• Absolute

• Relative

• Mixed

• Proper

It spans a cell or a group of cells adjacent to each other on a worksheet.

• Reference

• Sequence

• Range

• Collection

What are pre-designed formulas in Excel

• Cell reference

• Range

• Relative reference

• Functions

Which of the given cell reference can be included in relative reference?

• $D6

• B3

• A$3

• B$3

Formulas in Excel must begin with _________________ symbol.

• !

• @

• #

• =

_______________ are inputs to functions, which accept values as number or text.

• Arguments

• Parameters

• Cell reference

• Range

To arrange data in ascending order of age we will

• Filter it

• Sort it

• Apply Conditional Formatting

• Rearrange data manually

To display only those records where temperature is below 0 degree you will

• Manually extract the data

• Sort the data

• Filter the data

• Use Goto option

To colour those cells blue where temperature is above 50 degree you will

• Apply filtering

• Use fill colour option

• Shade Cells

• Use Conditional Formatting

What is the output of the function =if(A1=A2,"Unequal","Equal")

when A1=10 A2 = 11

• Equal

• Unequal

• Error

• None of these

Answer explanation

This is a super tricky question, so just imagine how it will appear in Excel and answer.