Excel Functions Fun

What function would you use to get today's date?

• datetime.today()

• datetime.date.current()

• datetime.now()

• datetime.date.today()

How do you find the average of a set of numbers in Excel?

• Calculate the median using =MEDIAN(A1:A10).

• Count the numbers with =COUNT(A1:A10).

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

• Use the SUM function, e.g., =SUM(A1:A10).

If you want to round a number to the nearest whole number, which function would you use?

• ceil

• truncate

• round

• floor

What does the MOD function do in Excel?

• The MOD function converts text to uppercase.

• The MOD function calculates the average of a set of numbers.

• The MOD function finds the maximum value in a range of cells.

• The MOD function returns the remainder of a division operation.

Which function would you use to convert a decimal number to an integer?

• float()

• round()

• str()

• int()

How can you quickly fill a series of numbers in Excel?

• Use the fill handle to drag and fill a series of numbers.

• Manually enter each number in the cells.

• Use the sort function to arrange numbers.

• Copy and paste a list of numbers from another document.

What is the purpose of the TODAY function?

• To return the current time.

• To display a random date.

• To return the current date.

• To calculate the sum of two numbers.

If you have the numbers 10 and 3, what is the result of MOD(10, 3)?

• 1

• 10

• 3

• 0

What function would you use to calculate the average of cells A1 to A10?

• SUM(A1:A10)

• MAX(A1:A10)

• COUNT(A1:A10)

• AVERAGE(A1:A10)

How does the INT function work in Excel?

• The INT function rounds a number up to the nearest integer.

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

• The INT function converts text to a number.

• The INT function returns the decimal part of a number.