Excel Functions and Their Uses

This video tutorial introduces 14 essential Excel functions, including SUM, COUNT, AVERAGE, IF, SUMIF, COUNTIF, PROPER, UPPER, LOWER, LEFT, MID, RIGHT, LEN, ROUND, CONCATENATE, VLOOKUP, and HLOOKUP. Each function is explained with examples, demonstrating their use in data analysis and manipulation. The tutorial aims to equip viewers with the skills to efficiently handle data tasks in professional and academic settings.

Which Excel function is used to calculate the total of a range of numbers?

• AVERAGE

• COUNT

• IF

• SUM

What does the COUNT function in Excel do?

• Checks conditions

• Calculates average

• Counts cells with numbers

• Adds numbers

How does the IF function in Excel help users?

• It formats text

• It applies logic based on conditions

• It counts data

• It sums data

What is the purpose of the SUMIF function?

• To sum all data

• To sum data based on criteria

• To count data

• To average data

Which function converts all text to uppercase in Excel?

• CONCATENATE

• PROPER

• UPPER

• LOWER

What does the PROPER function do to text?

• Capitalizes first letter of each word

• Converts to uppercase

• Converts to lowercase

• Joins text

Which function would you use to extract a substring from the middle of a text string?

• LEFT

• RIGHT

• MID

• LEN

What does the LEN function return?

• Logical comparison

• Sum of numbers

• Length of a text string

• Average of numbers

How does the ROUND function modify numbers?

• It averages numbers

• It rounds numbers to a specified digit

• It counts numbers

• It adds numbers

What is the main difference between VLOOKUP and HLOOKUP?

• VLOOKUP is for vertical data, HLOOKUP is for horizontal data

• VLOOKUP is for logic, HLOOKUP is for text

• VLOOKUP is for counting, HLOOKUP is for summing

• VLOOKUP is for text, HLOOKUP is for numbers