Excel contains a conditional formatting preset that highlights top/bottom values. However, using a formula instead provides more flexibility. If you have a series of data with high & low magnitude values and you want to format only N number of high magnitude values in the series of data, which of the following formulas is valid?

Which of the following formulas is not entered correctly?

Is it possible to make Pivot table using multiple sources of data?

Which of the functions listed will not work if you are looking for an exact value based on a right lookup column?

If cell A2 has a full name (Fristname, Middle Initial and Lastname) like 'Karen E. McRich' which of the following formula will extract the lastname?

Which one of the following get displayed if custom numeric format is set as follows and cell has 123456? 'Acct'# 00-0000;;;;'Don't enter dash'

what is the maximum limit of digits in excel?

While you are typing data into a cell, which of these commands cannot be performed?

If cell A1='Smith,Joe' then =Find(',',A1) returns:

What command reveals which cells must contain data for the function in the currently selected cell to work?

Which Windows Keyboard Shortcut unhides any hidden rows within the selection.