Excel Text Functions

What is the purpose of the LOOKUP function in Excel?

• The purpose of the LOOKUP function in Excel is to insert a new row into a worksheet

• The purpose of the LOOKUP function in Excel is to search for a value in a range and return a corresponding value from another range.

• The purpose of the LOOKUP function in Excel is to calculate the sum of a range of cells

• The purpose of the LOOKUP function in Excel is to change the font style of a cell

How can the VLOOKUP function be used to search for a value in a table?

• By using the VLOOKUP function in Microsoft Word

• By using the VLOOKUP function in Excel or Google Sheets.

• By using the VLOOKUP function in Photoshop

• By using the VLOOKUP function in PowerPoint

Explain the difference between the HLOOKUP and VLOOKUP functions in Excel.

• HLOOKUP and VLOOKUP functions are used for the same purpose.

• The main difference between HLOOKUP and VLOOKUP is the orientation of the data table they search. HLOOKUP searches for data in a row, while VLOOKUP searches for data in a column.

• HLOOKUP and VLOOKUP functions cannot be used in Excel.

• HLOOKUP searches for data in a column, while VLOOKUP searches for data in a row.

What does the TEXT function do in Excel?

• The TEXT function creates a table of contents in Excel.

• The TEXT function converts text to a numerical value in Excel.

• The TEXT function calculates the total of a range of cells in Excel.

• The TEXT function converts a value to text in a specific number format.

How can the CONCATENATE function be used to combine text in Excel?

• The CONCATENATE function can be used by entering =COMBINE(text1, text2, ...) in a cell, where text1, text2, etc. are the text strings to be combined.

• The CONCATENATE function can be used by entering =CONCATENATE(text1, text2, ...) in a cell, where text1, text2, etc. are the text strings to be combined.

• The CONCATENATE function can be used by entering =MERGE(text1, text2, ...) in a cell, where text1, text2, etc. are the text strings to be combined.

• The CONCATENATE function can be used by entering =JOIN(text1, text2, ...) in a cell, where text1, text2, etc. are the text strings to be combined.

Explain the usage of the LEFT function in Excel.

• The LEFT function in Excel is used to insert a new column in a worksheet.

• The LEFT function in Excel is used to convert text to uppercase.

• The usage of the LEFT function in Excel is to extract a specified number of characters from the start of a text string.

• The LEFT function in Excel is used to calculate the average of a range of cells.

What is the purpose of the RIGHT function in Excel?

• To insert a new row into a worksheet

• To extract a specified number of characters from the right side of a text string.

• To change the font color of a cell

• To calculate the sum of a range of cells

How can the MID function be used to extract text from a cell in Excel?

• The MID function takes three arguments: the text string, the starting position, and the number of characters to extract. For example, =MID(A1, 3, 5) would extract 5 characters from cell A1, starting at the 3rd position.

• The MID function can extract text from multiple cells at once in Excel

• The MID function does not require the starting position argument

• The MID function can only be used to extract numbers from a cell in Excel

Explain the usage of the YEAR function in Excel.

• The YEAR function in Excel is used to round a number down to the nearest integer.

• The YEAR function in Excel is used to calculate the number of years between two dates.

• The YEAR function in Excel is used to extract the year from a given date.

• The YEAR function in Excel is used to convert a number to a year.

How can the DATEDIF function be used to calculate the difference between two dates in Excel?

• The DATEDIF function only works for dates within the same year

• The DATEDIF function takes three arguments: start_date, end_date, and unit. For example, =DATEDIF(A1, B1, "D") will calculate the difference in days between the dates in cells A1 and B1.

• The DATEDIF function does not exist in Excel

• The DATEDIF function can only calculate the difference in years between two dates