Intermediate Microsoft Excel 2019 M55269

What function in Excel is used to convert lowercase letters in a given text string to uppercase?

• UPPER function
• NIDS
• CONCATENATE(text1, [text2], ...)
• Conditional Formatting

Which Excel function is used to search for a value in a row and return a value from a different row?

• HLOOKUP function
• HLOOKUP function
• Conditional Formatting
• One value for the TRUE result

What is the syntax for the CONCATENATE function?

• CONCATENATE(text1, [text2], ...)
• CONCATENATE(text1, [text2], ...)
• One value for the TRUE result
• Select either a single cell or range of cells

Which Excel feature allows you to analyze data, detect issues, and identify patterns?

• Conditional Formatting
• Conditional Formatting
• Select either a single cell or range of cells
• An approximate match

What does the IF function in Excel return when the logical test is TRUE?

• One value for the TRUE result
• One value for the TRUE result
• An approximate match
• Charts

What is the first step in creating a named reference in Excel?

• Select either a single cell or range of cells
• Select either a single cell or range of cells
• Charts
• Go to Data tab and click on Remove Duplicates

What does the VLOOKUP function return when range_lookup is set to TRUE?

• An approximate match
• An approximate match
• Go to Data tab and click on Remove Duplicates
• To calculate loan payments based on constant payments and a constant interest rate

What Excel feature helps to create a graphical illustration of any data set?

• Charts
• Charts
• To calculate loan payments based on constant payments and a constant interest rate
• HLOOKUP function

How do you remove duplicate values from a list in Excel?

• Go to Data tab and click on Remove Duplicates
• Go to Data tab and click on Remove Duplicates
• UPPER function
• CONCATENATE(text1, [text2], ...)

What is the use of the PMT function in Excel?

• To calculate loan payments based on constant payments and a constant interest rate
• To calculate loan payments based on constant payments and a constant interest rate
• HLOOKUP function
• UPPER function