To separate merged cell for each row in the selection area and maintain default alignment for the data type of the first cell in each row, which would you select?

1. Merge Cells
2. Merge & Center
3. Merge Across
4. Merge Below

To change text from horizontal to vertical, which would you change?

1. Orientation
2. Alignment
3. Indentation
4. Width

What must be established in order for Flash Fill to work?

1. A date and time structure
2. A pattern of data entry
3. Transposition of rows and columns
4. Data in Flash Form

To keep the Format Painter active for more than one cell, double click the Format Painter.

1. True
2. False

In order to insert more than one row at a time, what must you do?

1. Press Ctrl + *
2. Enter the number of rows in the Add Rows and Columns dialog box.
3. Select the number of rows you want to insert.
4. You can only insert one row at a time.

What tool allows you to apply the same unique combination of formatting to other text?

1. Style Sets
2. Format Painter
3. Font dialog box
4. Paste Values

Which of the following can you adjust in the Format Cells dialog box? Select all that apply.

1. Value
2. Indentation
3. Alignment
4. Orientation

Excel calculates the series of values by adding the values you enter in the Step Value box to each cell in the series when you select the Growth series.

1. True
2. False

Where can you find the Insert Cells button?

1. In the Alignment group of the Insert menu.
2. In the Cells group of the Insert Menu.
3. In the Alignment group of the Home menu.
4. In the Cells group of the Home menu.

If you wanted to reuse a value that is the result of a formula and only wanted to paste the result of the formula rather than the actual cell content, which would you use?

1. Paste format
2. Paste values
3. Transpose
4. Paste Link