Excel Functions Quiz

What is the purpose of using built-in functions in Excel spreadsheets?

• The purpose of using built-in functions in Excel spreadsheets is to format cells and apply styles.

• The purpose of using built-in functions in Excel spreadsheets is to create charts and graphs.

• The purpose of using built-in functions in Excel spreadsheets is to import and export data.

• The purpose of using built-in functions in Excel spreadsheets is to automate calculations, manipulate data, analyze information, and simplify complex tasks.

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

• MAX

• COUNT

• SUM

• AVERAGE

What does the AVERAGE function in Excel do?

• Calculates the sum of a range of numbers.

• Calculates the median of a range of numbers.

• Calculates the arithmetic mean of a range of numbers.

• Calculates the maximum value in a range of numbers.

Which function in Excel is used to find the minimum value in a range of cells?

• AVERAGE

• MINIMUM

• MIN

• SUM

What is the purpose of the MAX function in Excel?

• To find the smallest value in a range of cells or a set of values.

• To calculate the average of a range of cells or a set of values.

• To find the largest value in a range of cells or a set of values.

• To count the number of cells in a range that contain numbers.

Which function in Excel is used to count the number of cells that contain data?

• COUNTA

• SUM

• AVERAGE

• COUNT

What does the DATE function in Excel do?

• The DATE function calculates the difference between two dates.

• The DATE function rounds a number down to the nearest integer.

• The DAT function converts a number to a text string.

• The DATE function formats the date entered.

How does the COUNT function in Excel handle cells with text values?

• It counts text values as 0.

• It counts text values as 1.

• It counts text values as a separate category.

• It ignores text values.

In the ACTIVITY A spreadsheet what formula should be used in cell E4

• =SUM(B4-D4)

• =SUM(B4:D4)

• =ADD(B4:D4)

• =ADD(B4,C4,D4)

What formula should be used in cell B9 to calculate the total by month in Activity A?

(a)