Mastering Excel Formulas

What is the purpose of the SUM function in Excel?

• To find the maximum value in a range of numbers in Excel.

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

• To add a range of numbers in Excel.

• To calculate the average of a range of numbers in Excel.

How do you create a formula that adds values in cells A1 and A2?

• =A1 * A2

• =SUM(A1, A2)

• =A1 + A2

• =A1 - A2

What symbol is used to start a formula in Excel?

• *

• =

• -

• +

Explain the difference between relative and absolute cell references.

• Relative references adjust when copied; absolute references do not.

• Relative references are used for formatting; absolute references are for calculations.

• Both relative and absolute references adjust in the same way when copied.

• Relative references are always fixed; absolute references change when copied.

How can you use the AVERAGE function in a formula?

• Use AVERAGE(range) to find the median of a set of values.

• Apply AVERAGE(range) to count the number of values in a range.

• Use AVERAGE(value1, value2) to find the maximum value.

• Use AVERAGE(range) to calculate the average of a set of values.

What does the IF function do in Excel?

• The IF function creates charts based on data.

• The IF function sorts data in ascending order.

• The IF function merges multiple cells into one.

• The IF function evaluates a condition and returns specified values based on whether the condition is true or false.

How would you write a formula to calculate the total price by multiplying quantity and price per unit?

• total_price = quantity + price_per_unit

• total_price = quantity * price_per_unit

• total_price = quantity / price_per_unit

• total_price = quantity - price_per_unit

What is the function to find the maximum value in a range of cells?

• MIN

• MAX

• AVERAGE

• SUM

How can you concatenate text from two different cells in Excel?

• Use =CONCATENATE(A1, B1) or =A1 & B1 to concatenate text from two cells.

• Use =TEXTJOIN(A1, B1) to combine text.

• Use =SUM(A1, B1) to merge text.

• Apply the CONCAT function in Excel.

What is the purpose of the COUNT function?

• To sort the rows in a dataset.

• To calculate the average of a dataset.

• To count the number of rows in a dataset.

• To find the maximum value in a dataset.