Excel

Choose the best description of the IF function

• Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

• Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false

• Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false

• Returns a value from a list using a given position

Choose the correct format of the IF function:

• =IF(logical test,value if true,value if false)

• =IF(logical test,value if false,value if true)

• =IF(value if true,value if false,logical test)

• =IF(value if false,value if true,logical test)

Which is the correct way to write this function:

IF B4 is greater than 200, show "High", otherwise, show "Low"

• IF(B4>200;"High";"Low")

• =IF(B4<200,"High","Low")

• =IF(B4>200,"High","Low")

• =IF(B4>200"High","")

Which of these comparison operations means "Less than or equal to"?

• <

• <>

• <=

• $

In this IF function example:  =IF(G8>40,"Yes","No")

What would show in the cell after you hit enter if the value in G8 was 62?

• Yes

• No

• Nothing would show

The arrangement of data in Z to A will arrange the data in __________ order.

• Ascending

• Descending

The Sort & Filter option is present under which tab of Microsoft Excel?

• Insert Tab

• Data tab

• Home tab

• Format tab

The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .

• Filter

• sort

• Custom Sorting

• Removing Filter

State true or false.

You can sort data in only one field.

• True

• False

• Don`t know

• Not able to answer

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

• Apply filtering

• Use fill colour option

• Shade Cells

• Use Conditional Formatting