Excel Unit Review - Office 2016

Combining two or more cells into one cell

• merging

• mixing

• combining

• spanning

__________ reference is adjusted cell reference in copied and pasted formula

• revised

• relative

• recycled

• retained

Pie chart with one or more slices offset

• offset

• exploded

• outer

• retained

A ______________ conveys visual representation of data

• spreadsheet

• chart

• image

As you type, Excel displays the entry (and Cancel box and Enter box) in _________________

• formula bar

• task bar

• header

• footer

A prewritten formula that is built into Excel

• function

• feature

• task

• calculation

This button assigns fixed dollar sign to the far left with spaces between the symbol and digits

• comma style format

• accounting number format

• percent style format

• currency style format

A person wants to format data to look different if it exceeds $500, what feature can be applied?

• spell checker

• conditional formatting

• point mode

• formula version

The range automatically selected by Excel is always correct.

• True

• False

Excel has more than 400 functions to perform many calculations

• True

• False