Mastering Essential Excel Functions

What is the primary purpose of the SUM function in Excel?

• To find the average of a range of cells

• To add up all the numbers in a range of cells

• To count the number of cells in a range

• To look up a value in a table

Which Excel function would you use to find the average value of a range of cells?

• SUM

• AVERAGE

• COUNT

• INDEX

If you want to count the number of cells in a range that contain numbers, which function should you use?

• COUNTIF

• LOOKUP

• COUNT

• GOAL SEEK

How does the COUNTIF function differ from the COUNT function?

• COUNTIF counts all cells, COUNT counts only numbers

• COUNTIF counts cells based on a condition, COUNT counts all numbers

• COUNTIF finds the average, COUNT sums up numbers

• COUNTIF looks up values, COUNT finds the index

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

• INDEX

• LOOKUP

• SUM

• AVERAGE

What is the purpose of the INDEX function in Excel?

• To find the sum of a range

• To return a value from a specific position in a range

• To count the number of cells in a range

• To seek a goal value

Which Excel feature allows you to find the input value needed to achieve a specific goal in a formula?

• LOOKUP

• GOAL SEEK

• INDEX

• COUNTIF

If you have a list of temperatures in Celsius and you want to find the average, which function would you use?

• SUM

• AVERAGE

• COUNT

• GOAL SEEK

You have a table of distances in miles. Which function would help you find the total distance?

• AVERAGE

• COUNTIF

• SUM

• LOOKUP

In a spreadsheet, you want to find how many cells contain the word "colour". Which function is most appropriate?

• COUNT

• COUNTIF

• INDEX

• GOAL SEEK