In this exercise, you will use the new Flash Fill feature.
Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URL-encoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates. Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URL-encoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates.