EXCEL Coding

Each Excel file is called a workbook because

• It can contain text and data
• It can be modified
• It can contain many sheets including worksheets and chart sheets
• You have to work hard to create it

If the cell contains hashtags (#), what do you need to do?

• Expand the column
• Expand the row
• Change the formula

Columns go...

• Across
• Down

Rows go...

• Across
• Down

In a cell reference, for example A1, what does the letter refer to?

• The column
• The cell
• The row

A cell name contains

• Cell name
• Column numbers and row letters
• Column letters and row numbers
• Cell locator coordinates

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.

Define Formula Bar?

• I don't know

• I don't care

• Don't miss this one!

• An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

To create a formula, you first:

• Select the cell you want to place the formula into
• Type the equals sign (=) to tell Excel that you're about to enter a formula
• Enter the formula using any input values and the appropriate mathematical operators that make up your formula
• Choose the new command from the file menu