HITS Excel Revision

Pertaining to IF function, what do you key in for the Logical Test field when given a statement of : A is at least 200.

• A>=200

• A>200

• A=>200

• A<=200

Pertaining to IF function, what do you key in for the Logical Test field when given a statement of : B is less than 200.

• B >= 200

• B > 200

• B < 200

• B <= 200

Pertaining to IF function, what do you key in for the Logical Test field when given a statement of : C is greater than 100.

• C >= 100

• C > 100

• C < 100

• C <= 100

Pertaining to IF function, what do you key in for the Logical Test field when given a statement of : D is Premium.

• D = Premium

• D = premium

• D = " Premium "

• D = ' Premium '

Under Filter function, when asked for 'Rate is at least $250', you should use number filter and select

• Greater than 250

• Greater than or Equal to 250

• Less than 250

• Less than or Equal to 250

Under Filter function, when asked for 'Duration is maximum 14 days', you should use number filter and select

• Greater than 14 days

• Greater than or Equal to 14 days

• Less than 14 days

• Less than or Equal to 14 days

Under Filter function, when asked for 'Points is minimally 500', you should use number filter and select

• Greater than 500

• Greater than or Equal to 500

• Less than 500

• Less than or Equal to 500

Under Filter function, when asked for 'Time is below 60 seconds', you should use number filter and select

• Greater than 60

• Greater than or Equal to 60

• Less than 60

• Less than or Equal to 60

'Absolute referencing' or 'Lock reference cells' requires you to press the __ button on your keyboard.

Given above reference table to Vlookup on, for the Range_lookup field, you need to type 'False'. Is this statement correct?

• Correct

• Incorrect