Exam 2: Formatting Workbook Text and Data

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

To return cell contents to its default font and style, you can use the _____ command.

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

To copy a cell's formatting to another cell, which of the following can you use?

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____ feature.

The Clipboard task pane shows the contents of the _____.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

A _______ refers to a collection of characters with a similar, specific design.

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Currency is an example of a number format.

To change the color of cell content, you use the ________ color list arrow.

To change the background color of a cell, you use the Background color button.

Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?

On which tab and button are document properties located for editing?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

You double-click the Format Painter button when you want to _____.

You can edit a worksheet footer in _____.