Excel Functions and Formulas

This video tutorial covers 10 essential Excel functions: Average, Sum, Sum If, Count, Count A, Count Blank, Count If, Concatenate, If, and VLOOKUP. It explains how to use each function with examples, including calculating averages, sums, and conditional sums, counting cells, concatenating text, performing logical tests, and looking up data. The tutorial also demonstrates creating a drop-down list for easier data entry.

What is the result of using the Average function on the numbers 15, 27, and 42?

• 28

• 30

• 27

• 29.33

How do you calculate the sum of 50 and 125 using the Sum function?

• =SUM(50; 125)

• =SUM(50 + 125)

• =SUM(50 125)

• =SUM(50, 125)

Which function would you use to sum only the values associated with 'Mazda' in a list?

• COUNT

• AVERAGE

• SUMIF

• SUM

What does the Count function do in Excel?

• Counts non-empty cells

• Counts all cells

• Counts empty cells

• Counts cells with numbers

Which function counts the number of non-empty cells in a range?

• COUNT

• COUNTIF

• COUNTA

• COUNTBLANK

How can you combine the first and last names in two columns into one using Excel?

• =MERGE()

• =CONCATENATE()

• =JOIN()

• =COMBINE()

What will the IF function return if the logical test is false?

• A specified value

• FALSE

• TRUE

• An error

Which function would you use to find a specific value in a table based on a given criterion?

• INDEX

• HLOOKUP

• VLOOKUP

• MATCH

What is the purpose of a drop-down list in Excel?

• To format data

• To sort data

• To select data from a predefined list

• To filter data

How do you create a drop-down list in Excel?

• Use Data Validation

• Use Data Filter

• Use Data Sort

• Use Conditional Formatting