Advanced Excel

If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:

• Flashfill
• Autofill
• Merge & Center
• Copy and Paste

The shortcut key for AutoSUM is:

• Ctrl + =
• Alt =
• = SUM
• Shift +

To quickly highlight an entire range within a column, you can click on the first cell of that range and:

• Press Ctrl + Shift + ↓
• Press Ctrl + Alt + ↓
• Double-click cell border
• Hold the shift key

The formula that adds values in a specified range that meet a certain condition or criteria is called:

• SUMIFS

• SUMIF

• COUNTIF

• SUBTOTAL

Under the order of arithmetic operators, Excel will calculate division before exponents.

• TRUE

• FALSE

When creating a VLOOKUP function, the table array area can be pre-named to make it easier to type into the formula. To name this range, you would go to the Formulas tab and select:

• Name Manager
• Create from selection
• Define name
• Data validation

The formula used to make the error return value of a function look "pretty" or clean and non-confusing is:

• IFERROR
• IF
• ERROR
• VLOOKUP

The absolute cell reference uses which symbol:

• $

• %

• *

• &

When using the SUBTOTAL command, you must sort by the column you are wanting to subtotal.

• True
• False

To combine text that is in two different cells, use the formula:

• COMBINE

• MATCH

• CONCATENATE

• SUBTOTAL