Excel: Common Excel Functions

The video tutorial introduces basic Excel functions, including SUM, AVERAGE, MIN, and MAX. It demonstrates how to use these functions to calculate totals, averages, minimums, and maximums in a spreadsheet. The tutorial also covers using the auto fill handle to apply functions across multiple columns efficiently.

What is the purpose of leaving blanks in the spreadsheet for total, average, minimum, and maximum calculations?

• To make the spreadsheet look cleaner

• To manually input values later

• To avoid errors in the spreadsheet

• To fill them using Excel functions

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

• MIN

• SUM

• AVERAGE

• MAX

How can you quickly apply the same function to multiple columns in Excel?

• By using the format painter

• By copying and pasting the formula

• By using the auto-fill handle

• By typing the function in each cell

What does the AVERAGE function in Excel do?

• Finds the maximum value in a range

• Calculates the average of a range

• Finds the minimum value in a range

• Calculates the sum of a range

Which function would you use to find the smallest value in a range of cells?

• MIN

• AVERAGE

• SUM

• MAX