Excel Formulas & Functions

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

• TOTAL

• RANGE

• ADD

• SUM

How can you reference a cell in a formula using its address?

• Use the cell's row number followed by its column letter in the formula.

• Use the cell's column letter followed by its row number in the formula.

• Use the cell's column number followed by its row number in the formula.

• Use the cell's row number followed by its column number in the formula.

What does the function =AVERAGE(A1:A10) do?

• Calculates the average of the values in cells A1 to A10.

• Counts the number of values in cells A1 to A10

• Multiplies the values in cells A1 to A10

• Finds the maximum value in cells A1 to A10

How can you use the CONCATENATE function to combine text in Excel?

• =MERGE(text1, text2)

• =COMBINE(text1, text2)

• =CONCATENATE(text1, text2, text3)

• =CONCATENATE(text1, text2, ... text_n)

What is the shortcut key to start a formula in Excel?

• *

• +

• Enter

• =

Explain the purpose of the MAX function in Excel.

• To find the maximum value in a range of cells.

• To calculate the average of a range of cells.

• To count the number of cells in a range.

• To concatenate text in multiple cells.

What does the function =COUNTA(A1:A10) do?

• Calculates the average of the values in cells A1 to A10.

• Counts the number of non-empty cells in cells A1 to A10.

• Multiplies the values in cells A1 to A10.

• Finds the maximum value in cells A1 to A10.

What does the function =SUM(A1:A10) do?

• Calculates the average of the values in cells A1 to A10.

• Counts the number of non-empty cells in cells A1 to A10.

• Adds the values in cells A1 to A10.

• Finds the maximum value in cells A1 to A10.

How does the function =AVERAGE(A1:A10) differ from =SUM(A1:A10) in Excel?

• Calculates the average of the values in cells A1 to A10.

• Counts the number of values in cells A1 to A10

• Adds the values in cells A1 to A10.

• Finds the maximum value in cells A1 to A10

What is the purpose of the MIN function in Excel?

• To find the minimum value in a range of cells.

• To calculate the average of a range of cells.

• To count the number of cells in a range.

• To concatenate text in multiple cells.