Using Flash Fill - Exercise

Contact Us or call 1-877-932-8228
Using Flash Fill - Exercise

Using Flash Fill

Duration: 05 to 10 minutes.

In this exercise, you will use the new Flash Fill feature.

  1. Open a new, blank worksheet in Excel.
  2. In column A, enter the following:
    1. Angela Ang
    2. Bobbi Born
    3. Chris Carter
    4. Doris Day
    5. Edward Everly
  3. Use Flash Fill to enter just the first names in column B.

Solution:

  1. In a new, blank document, enter the data in column A.
  2. Click in cell B1, and type "Angela" and press Enter.
  3. Click in cell B2, and as you begin to type "Bobbi", Flash Fill fills in rest of the first names.
  4. To accept the rest of the data, press Enter.
  5. Close the worksheet without saving your changes.

New Functions in Excel 2013

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.

  1. DECIMAL function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number.
  2. ACOT function: Available on the Math & Trig tab. This function returns the arccotangent of a number.
  3. ENCODEURL function: Available on the More Functions tab in the Web section. This function returns a URL-encoded string.
  4. 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.

  1. DECIMAL function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number.
  2. ACOT function: Available on the Math & Trig tab. This function returns the arccotangent of a number.
  3. ENCODEURL function: Available on the More Functions tab in the Web section. This function returns a URL-encoded string.
  4. DAYS function: Available on the Date & Time tab. This function shows the number of days between two dates.
Next