Excel Functions Challenge

What does the XLOOKUP function do in Excel?

• The XLOOKUP function formats cells in a spreadsheet.

• The XLOOKUP function searches for a value in a range and returns a corresponding value from another range.

• The XLOOKUP function calculates the sum of a range of numbers.

• The XLOOKUP function creates charts and graphs.

How do you calculate the sum of a range of cells?

• Use the SUM function, e.g., =SUM(A1:A10).

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

• Use the COUNT function, e.g., =COUNT(A1:A10).

• Add the cells manually, e.g., A1 + A2 + A3.

What function would you use to find the average of a set of numbers?

• total()

• mean()

• sum()

• average()

Which function returns the smallest number in a range?

• SUM

• MIN

• AVERAGE

• MAX

How can you find the largest number in a dataset using Excel?

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

• Sort the data in ascending order and select the last value.

• Use the COUNT function to find the largest number.

• Use the MAX function, e.g., =MAX(A1:A10).

What does the LEFT function do with a text string?

• The LEFT function returns the leftmost characters from a text string.

• The LEFT function removes the rightmost characters from a text string.

• The LEFT function counts the number of characters in a text string.

• The LEFT function returns the entire text string without any changes.

How does the RIGHT function differ from the LEFT function?

• The LEFT function counts the number of characters, whereas the RIGHT function does not.

• The LEFT function retrieves characters from the end of a string, while the RIGHT function retrieves from the start.

• The LEFT function retrieves characters from the start of a string, whereas the RIGHT function retrieves characters from the end.

• The LEFT function is used for numeric values, while the RIGHT function is used for text values.

What is the purpose of the MID function in Excel?

• To extract a text from determine position text string.

• To find the position of a character in a string.

• To convert text to uppercase.

• To calculate the length of a text string.

How can you combine text from multiple cells into one cell?

• Use the SUM function to add values.

• Use CONCATENATE function or the & operator.

• Utilize the VLOOKUP function to combine data.

• Apply the TEXTJOIN function for merging cells.

What is the SEARCH function used for in Excel?

• To create a chart from selected data.

• To sort data in ascending order.

• To calculate the average of a range of numbers.

• The SEARCH function is used to find the position of a substring within a string.