Excel Formatting
Did You Know?
In Command of Excel
Formulas and Other
Trivia-NFL
100

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

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

100

 Click the row header for the row you want to select

To select an entire row, where would you click?

100

CTRL+G

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

100

=

What indicates the contents of a cell are a formula?

100

Tampa Bay Buccaneers 

Who won this years super bowl?

200

Horizontally, vertically, or rotated

How can data be aligned within a cell?

200

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

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

200

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

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

200

Turn on the My data has headers option

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

200

Patrick Mahomes

Who is the quarterback for the Chiefs?

300

Borders can help to separate and identify specific cells

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

300

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

What is the difference between a workbook and a worksheet?

300

labels identify the values and help outline the mathematical relationships

Why would you enter labels into the worksheet?

300

Bucs and Chiefs

What were the two teams in the Super bowl this year?

400

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

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

400

Above the current row

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

400

Expenses appear to increase in the first three months

What do you notice about the chart in the folowing?

400

Tom Brady

Who is the Quarterback for the Buccaneers?

500

 A blank workbook

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

500

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

What displays when you activate the Cut or Copy command?

500

Reymond James Stadium

Where was the super bowl at this year?