Excel Final Review

In which group do you find the command for conditional formatting?

• Font

• Styles

• Formatting

• Paragraph

What view displays the location of the different page breaks within a worksheet?

• Normal

• Page View

• Page Break Preview

• Print Preview

Select ALL that apply:

Which of the following are rules that can be created with Conditional Formatting?

• Top 20 items

• Values between 50 and 100

• Cell Shading

• Red Data Bar

By default, numbers appear in the _____ format and generally display values exactly as you type them

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

• cell

• relative

• absolute

• mixed

Click the _____ key (on your keyboard) to select multiple cells in a worksheet that are not next to each other.

In Excel, what is a cell range?

• The basic units of life

• A group of cells in a rectangular block.

• The intersection of a row and a column.

Select ALL that apply:

Which of the following unique tab(s) appear on the ribbon when a chart is selected?

• Insert

• Design

• Format

• Layout

ALL Excel formulas and functions begin with an _______ sign.

Which logical function returns a TRUE value if the logical condition is true and a FALSE value if the condition is FALSE?

• AND

• OR

• IF

• IFS