Formatting in Excel

How do you insert a new row?

• Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
• Select the row heading where you want to insert the new row and select Edit >Row from the menu
• Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
• All of the above

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

• Page preview
• Print Layout
• Synchronous Scrolling
• Window View

What is the name of this cell?

• B10
• 5B
• B5
• A5

The numbers in Excel represent the _____?

• columns

• rows

• data

• functions

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

What is the green bar at the top of Excel referred to as?

• the data bar

• the function bar

• the ribbon

• the row

What is a spreadsheet?

• An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

• An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

• An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

• An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

Define Cell?

• The dark bordered box in excel.

• A box in Excel that has formulas.

• The intersection of a column or row in a worksheet or table.

• Fx Bar where you input data.

What is the "Active Cell" in Excel?

• The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

• The current cell in a worksheet. It is indicated by a dark border onscreen.

• The top cell in a worksheet. It is indicated by a dark border onscreen.

• The past cell in a worksheet. It is indicated by a dark border onscreen.