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

How can data be aligned within a cell?

What is horizontally, vertically, or rotated 

100

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

What is CTRL+G

100

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

A blank workbook

100

What indicates the contents of a cell are a formula?

=

100

The airline that has blue planes with red and yellow stripes

What is Southwest Airlines?

200

Why might you prefer to apply a background color to a cell instead of applying a pattern?

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

200

When you insert a row, where does Excel place it in relation to the cursor position?

Above the current row

200

To select an entire row, where would you click

Click the row header for the row you want to select

200

The richest man in the world

Who is Elon Musk?

300

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

Borders can help to separate and identify specific cells.

300

What does it mean that the data in the table must be contiguous?

there must not be a blank rows or columns in the range of cells for the table

300

Why would you enter labels into the worksheet?

labels identify the values and help outline the mathematical relationships.

300

The fastest car in the world

What is the ThrustSSC?

400

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

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

400

What is the difference between a workbook and a worksheet?

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

400

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

Filtering displays only those records that match the criteria you specify; other records are temporarily hidden

400

The man who was assassinated to start WWI

Who is archduke Franz Ferdinand

500

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

Turn on the My data has headers option.

500

What do you notice about the chart in the following?

Expenses appear to increase in the first three months

500

What displays when you activate the Cut or Copy command

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

500

The largest animal in the world

What is the blue whale?