MS EXCEL FORMULAS, FUNCTIONS AND ANALYSIS

Referencing in =$B3+B$4 formula is

• Absolute

• Relative

• Mixed

• Proper

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

The various elements of a chart are

• data label, chart title, legend

• data legend, chart title, label

• chart legend. chart label, chart title

• none of the above

To change chart layout, style, type of inserted chart you need to go to

• Format Tab

• Insert Tab

• Design Tab

• View Tab

To display the date and time in a manner such that it gets updated automatically you will

• Type Date/Time and update it time to time

• Use Date and TIme function

• Use Today function

• Use Now function

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

when A1=10 A2 = 11

• Equal

• Unequal

• Error

• None of these

A) =Count("String")

B) =Len("String")

• Both will give the same output

• Both will give an error

• A) is correct B) is wrong

• A) is wrong B) is correct

Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is

• =A4+B5

• =A3+B4

• =B4+B5

• =B3+C4