Excel Formulas & Functions

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

• SUM

• RANGE

• TOTAL

• ADD

How can you reference a cell in Excel formula?

• By using the cell's border

• By using the cell's font style

• By using the cell's color

• By using the cell's address, named ranges, or structured references.

What does the VLOOKUP function do in Excel?

• VLOOKUP function calculates the sum of a range of cells in Excel

• VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from another column.

• VLOOKUP function changes the font style of a cell in Excel

• VLOOKUP function inserts a new row at the bottom of a table in Excel

Explain the difference between absolute and relative cell references in Excel formulas.

• Absolute cell references adjust based on the relative position of the formula, while relative cell references do not change

• Absolute cell references and relative cell references are the same in Excel formulas

• Absolute cell references change when copied, while relative cell references do not adjust

• Absolute cell references do not change when copied, while relative cell references adjust based on the relative position of the formula.

How can you nest functions in Excel?

• Create a new Excel file for each nested function

• Combine functions in a single cell without any separation

• Enter one function as an argument within another function

• Use a separate worksheet for each function

What is the IF function used for in Excel?

• It is used to create charts in Excel

• It is used to format cells in Excel

• It is used to import data into Excel

• It is used to perform logical tests and return different values based on the result.

What is CONCATENATE function in Excel?

• CONCATENATE function calculates averages in Excel
• CONCATENATE function separates strings in Excel
• CONCAT function combines numbers in Excel
• CONCATENATE function in Excel is used to combine multiple strings into one single string.

How can you use the SUMIF function in Excel?

• Use the AVERAGEIF function instead of SUMIF

• Specify the range, criteria, and sum range in the SUMIF function in Excel.

• Include only the range in the SUMIF function

• Apply the SUMIF function to text data

Explain the purpose of the COUNTIF function in Excel.

• The purpose of the COUNTIF function in Excel is to count cells based on a single condition.

• COUNTIF function in Excel is used to merge cells with similar values

• The COUNTIF function in Excel calculates the sum of a range of cells

• COUNTIF is used to format cells based on specific criteria

What is the difference between AVERAGE and AVERAGEIF functions in Excel?

• AVERAGE calculates the median of a range of cells

• The difference between AVERAGE and AVERAGEIF functions in Excel is that AVERAGE calculates the average of a range of cells, while AVERAGEIF calculates the average based on a specified condition.

• AVERAGE calculates the sum of a range of cells

• AVERAGEIF calculates the maximum value in a range of cells