Intermediate Microsoft Excel 2019 M55269 Training

Which function is used to search a value in a single row or column and match it in another row or column?

• IF

• VLOOKUP

• LOOKUP

• CONCATENATE

How can you create a named range in Excel?

• Insert > Name > Define

• Formulas > Name Manager > New

• Data > Data Tools > Data Validation

• Review > Changes > Protect Sheet

What is the purpose of the IF function in Excel?

• To return a value if a condition is true and another value if it's false

• To calculate the interest rate of a loan

• To lookup and return a value in a table

• To combine multiple strings into one

How do you convert a range of data into a table in Excel?

• Format > Table

• Insert > Table

• Data > Table

• View > Table View

What does the PMT function calculate?

• The total interest paid over the life of a loan

• The monthly payment for a loan

• The present value of an investment

• The future value of an investment

Which Excel function allows you to rearrange data from columns to rows or vice versa?

• TRANSPOSE

• SWITCH

• CONVERT

• FLIP

In Excel, how can duplicate values in a dataset be removed?

• Data > Data Tools > Remove Duplicates

• Home > Editing > Find & Select > Go To Special > Duplicates

• Review > Protect Workbook

• Insert > Symbol

Which function would you use to retrieve a value based on a horizontal lookup?

• VLOOKUP

• HLOOKUP

• MATCH

• INDEX

The CONCAT function in Excel is used for:

• Calculating the sum of a series of numbers

• Combining multiple text strings into one text string

• Looking up values in a data set

• Converting numbers to text format

Which function is not specifically designed to work with date and time in Excel?

• NOW

• TODAY

• DATE

• SUM