Excel Functions Fun

What is the formula to add two numbers in Excel?

• =SUM(A1, B1) or =A1 + B1

• =ADD(A1, B1)

• =A1 * B1

• =TOTAL(A1, B1)

How do you subtract one number from another in Excel?

• Select the cells and press the 'Delete' key to remove the values.

• Use the formula =A1+B1 to add the values in A1 and B1.

• Use the formula =A1-B1 to subtract the value in B1 from A1.

• Click on the cell and type 'subtract' to perform the operation.

What function would you use to find the average of a set of numbers?

• total()

• average()

• mean()

• sum()

Which function counts the number of cells that contain numbers?

• COUNT

• SUM

• AVERAGE

• MAXIMUM

What is the purpose of the SUM function in Excel?

• To count the number of cells in a range.

• To calculate the average of numbers.

• To add numbers together.

• To find the maximum value in a range.

How do you use the IF function in Excel?

• The IF function is used for data visualization in Excel.

• Use the IF function to perform conditional logic in Excel.

• Use the IF function to create charts in Excel.

• You can only use the IF function for mathematical calculations in Excel.

What function would you use to find the maximum value in a range?

• MIN

• SUM

• AVERAGE

• MAX

How can you combine text from two cells into one cell?

• Use CONCATENATE(A1, B1) or A1 & B1.

• Use SPLIT(A1, B1) to separate text.

• Apply TEXTJOIN(A1, B1) for merging cells.

• Utilize the MERGE function for combining text.

What does the COUNTIF function do in Excel?

• Counts the number of cells that meet a specified condition in a given range.

• Sorts the data in ascending order.

• Finds the maximum value in a specified range.

• Calculates the average of a range of cells.

How do you create a formula that multiplies two numbers?

• a * b

• a + b

• a - b

• a / b