Excel Formatting
Did you know?
In Commands of Excel
Formulas and Other
Trivia
100

Patterns can make it harder to read the data than using a solid color.

Instead of a pattern, why might you prefer to apply a background color to a cell?

100

Horizontally, Vertically, or Rotated

How can data be aligned within a cell?

100

Ctrl+G

Which key can you press to activate the Go To command?

100

=

What character automatically indicates the contents of a cell are a formula?

100

A magical theme park located in Orlando, FL

What is Disney World?

200

Borders can help to separate and identify specific cells

Why might you want to apply borders to a cell instead of just using gridlines on the worksheet?

200

A blank workbook

Which new workbook option displays the title, Book1, when it is created?

200

Above the current row

Where does Excel insert a row in relation to the cursor position?

200

Expenses appear to increase in the first three months

What do you notice about the chart in the following?

200

The location of the Coliseum

What is Rome?

300

Labels identify the values and help outline the mathmatical relationships

Why would you enter labels into the worksheet?

300

A workbook is the actual file that contains the worksheets, which in turn contain the data

What is the difference between a workbook and a worksheet?

300

A marque appears around the selected cells for the Cut or Copy command

What displays when you activate the Cut or Copy command?

300

Flitering displays only those records that match the cruteria you specify; other records are temporarily hidden.

Why might you choose to filter a list or table instead of simply sorting it?

300

A baby kangaroo

What is a joey?

400

On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement

What is the best way to set a column to a specific width? 

400

Click the row header for the row you want to select

Where do you click to select an entire row?
400

The colors of this country's flag are green, white, and red

What is Italy?

500

There must be no blank rows or columns in the range of cells for the table

What is Contiguous Data in a table?

500

Turn on the My data as headers options

What has to happen in order for column headings to display in the Sort fields?

500

A goup of lions

What is a pride?