Excel Functions and Features Assessment

This video tutorial covers essential Excel functions including Autosum, Average, Max, Min, and Count. It demonstrates how to use these functions to perform calculations on data sets, both within individual cells and across columns. The tutorial also explains the Autofill feature, showing how to extend patterns in Excel. By the end of the video, viewers will understand how to efficiently use these functions to manage and analyze data in Excel.

Which of the following functions is NOT introduced in the lesson?

• Average

• Autosum

• Count

• Median

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

• To find the average of numbers

• To find the maximum value

• To sum up a range of numbers

• To count the number of cells

How can you calculate the average of numbers in Excel?

• Using the AVERAGE function

• Using the MIN function

• Using the SUM function

• Using the MAX function

If you have the numbers 84, 92, and 78, what is their average?

• 83.5

• 84.6667

• 85

• 86

Which function would you use to find the highest number in a list?

• COUNT

• MIN

• AVERAGE

• MAX

What is the result of the MAX function for the numbers 43, 17, 26, and 35?

• 35

• 43

• 26

• 17

Which function helps you find the smallest number in a dataset?

• SUM

• MIN

• AVERAGE

• MAX

What does the COUNT function do in Excel?

• Finds the average of numbers

• Counts the number of cells with numbers

• Finds the maximum value

• Adds up all the numbers

What is the purpose of the Autofill feature in Excel?

• To find the average

• To count the cells

• To calculate the sum

• To automatically fill cells with a pattern

If you start with 100 and increase by 25 using Autofill, what is the next number?

• 125

• 150

• 175

• 200