Excel Formulas & Functions

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

• ADD

• RANGE

• TOTAL

• SUM

How can you reference a cell in Excel?

• A1

• C1

• D1

• B1

What does the formula =A1+B1 do in Excel?

• It subtracts the value in cell B1 from A1.

• It divides the value in cell A1 by B1.

• It multiplies the values in cell A1 and B1 together.

• It adds the values in cell A1 and B1 together.

What is the purpose of the IF function in Excel?

• To perform a logical test and return different values based on the result.

• To insert images

• To create pivot tables

• To calculate square roots

How can you calculate the average of a range of cells in Excel?

• AVERAGE(range:range)

• AVERAGE(range)

• AVERAGE(range, range)

• SUM(range)

What is the difference between absolute and relative cell references in Excel?

• Absolute cell references stay fixed, while relative cell references adjust based on their new position.

• Absolute cell references are used for text, while relative cell references are used for numbers.

• Absolute cell references and relative cell references are the same thing.

• Absolute cell references adjust based on their new position, while relative cell references stay fixed.

How do you use the VLOOKUP function in Excel?

• Click on the cell where you want the result and then type VLOOKUP

• Type =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in the desired cell.

• VLOOKUP can only be used in Google Sheets, not Excel

• Use the SUM function instead of VLOOKUP

What is the CONCATENATE function used for in Excel?

• To combine multiple strings or cell values into one single string.

• To format cells

• To create pivot tables

• To calculate mathematical operations

How can you count the number of cells that contain data in Excel?

• =COUNTA(range)

• =AVERAGE(range)

• =COUNT(range)

• =SUM(range)

Explain the difference between COUNT, COUNTA, and COUNTIF functions in Excel.

• COUNTA function counts only empty cells

• COUNT function counts text values

• COUNTIF function counts cells randomly

• COUNT function counts numbers, COUNTA function counts all non-empty cells, and COUNTIF function counts cells based on a specified condition.