Excel Recap

How do you sum a range of numbers in Excel?

• =TOTAL(range)

• =SUM(range)

• =ADD(range)

• =AVERAGE(range

What does the function "=IF(A1>10, "Yes", "No")" do in Excel?

• Adds the values in cell A1 and 10.

• Checks if cell A1 is greater than 10 and returns "Yes" if true, "No" if false.

• Checks if cell A1 is greater than 10 and returns "No" if true, "Yes" if false.

• Multiplies cell A1 by 10.

How can you quickly fill a series of numbers or dates in Excel?

• Use the "Random Number" function.

• Manually type each number or date.

• Drag the fill handle or use the Fill Series feature.

• Use the "Sort" function.

What function can be used to find the highest value in a range of numbers?

• =MIN(range)

• =MAX(range)

• =HIGH(range)

• =LARGEST(range)

What is the purpose of the "Find and Replace" feature in Excel?

• To calculate mathematical expressions.

• To create charts and graphs.

• To search for specific text or numbers and replace them with another value.

• To change the font and style of text in cells.

What is the function of the "VLOOKUP" function in Excel?

• To find and replace text.

• To add a range of numbers.

• .To calculate the square root of a number.

• To perform vertical lookup and retrieve data based on a matching value.

What function is used to count the number of cells that meet a specific condition in Excel?

• =COUNT(range)

• =SUM(range)

• =COUNTIF(range, criteria)

• =AVERAGEIF(range, criteria)

What is the purpose of the "SUMIFS" function in Excel?

• To calculate the sum of a range of numbers.

• To count the number of cells that meet specific criteria.

• To perform a vertical lookup.

• To calculate the sum of a range of numbers based on multiple criteria.

You have a list of first names in column A and last names in column B. You want to create a new column that combines these names into a single cell with a space between the first and last names. Which formula would you use to achieve this?

• =CONCATENATE(A1 " " B1)

• =CONCATENATE(A1, B1)

• =CONCATENATE(A1, "_ ", B1)

• =CONCATENATE(A1, " ", B1)

You have a list of first names in column A and last names in column B. You want to create a new column that combines these names with a comma and space between the last name and the first name, like "Dela Cruz, Juan." Which formula would you use to achieve this?

• =CONCATENATE(A1", "B1)

• =CONCATENATE(A1, ", ", B1)

• =CONCATENATE(A1, " ", B1)

• =CONCATENATE(A1, , , B1)