Excel Ch 2 Concepts

When you cut and paste a cell containing a formula with relative references, Excel _____________.

• updates the cell references to the new location

• does not update the cell references to the new location

• treats the formulas as if it contained absolute references

• both b and c

Which paste option pastes formulas and number formatting but none of the cell formatting?

• Keep Source Formatting

• Values

• Formulas

• Formulas & Number Formatting

To split a cell into two cells _________.

• in the Format Cells dialog, on the Alignment tab, in the Text Control section., click the Merge cells box to uncheck it

• on the Home tab, in the Alignment group, click the Merge & Center button and select Unmerge Cells.

• on the Data tab, in the Data Tools group, click the Text to Columns button

• you cannot split a cell into two cells; you can only unmerge merged cells

To apply the Double Accounting underline format ______.

• press Ctrl + U

• in the Font dialog, on the Font tab, expand the Underline list and select Double Accounting

• on the Home tab, in the Font group, click the Underline button

• on the Home tab, in the Font group, click the Underline button arrow and select Double Underline

Clicking the Borders button on the Ribbon applies which border style?

• none

• outline

• bottom border only

• the most recently used border style

The keyboard shortcut to open the Quick Analysis tool is ______.

• Ctrl+A

• Ctrl+Q

• F7

• F10

To highlight cells with values in the top 10% of the select range, use conditional formatting ______.

• Highlight Cells Rules

• Top/Bottom Rules

• data bars

• icon sets

You can remove conditional formatting using the______.

• Clear All command

• Ctrl + X keyboard shortcut

• Delete keyboard shortcut

• Clear Rules from Selected Cells command

Selecting a cell and pressing Delete clears______.

• cell content only

• cell content and formatting

• cell content, formatting, and formulas

• cell formatting only

Where is the Set Print Area command located?

• on the Page Layout tab, in the Page Setup group

• in the Page Layout dialog

• in the Print dialog

• on the Home tab, in the Print group