Topic 3 - Starter - BTEC IT

Which function is used for decision making in Excel?

• a) IF
• b) VLOOKUP
• c) COUNTBLANK
• d) LEFT

Which function is used for lookup in Excel?

• a) SUMIF
• b) COUNTIF
• c) OR
• d) HLOOKUP

3. Which string operation function is used to extract characters from the left side of a cell in Excel?

• a) RIGHT
• b) VLOOKUP
• c) LEFT
• d) COUNTIF

Which count function is used to count the number of blank cells in a range in Excel?

• a) IF
• b) COUNTBLANK
• c) OR
• d) SUMIF

5. Which logical operator in Excel returns TRUE if all the conditions are met?

• a) AND
• b) OR
• c) NOT
• d) VLOOKUP

Which function is used to add up the values in a range if they meet a certain criterion in Excel?

• a) SUMIF
• b) LEFT
• c) COUNTBLANK
• d) VLOOKUP

Which function is used for decision making in Excel and has an additional capability to test multiple conditions?

• a) IF
• b) COUNTIF
• c) OR
• d) WHATIF

Which function is used for lookup in Excel and retrieves data from a specified column in a table?

• a) HLOOKUP
• b) RIGHT
• c) SUMIF
• d) VLOOKUP

Which function in Excel returns TRUE if any of the conditions are met?

• a) AND
• b) OR
• c) NOT
• d) COUNTIF

Which outline feature in Excel groups rows or columns together for easy navigation and organization?

• a) Subtotal
• b) COUNTIF
• c) Group
• d) VLOOKUP