Excel NTI Day 2

Individual Excel files that contain one or more spreadsheets.

• $202.00
• Spreadsheets
• Spreadsheet Tab
• Workbook

Storage unit of a spreadsheet, it is named by the intersection of column and row.

• Spreadsheets
• =sum(A1:A5)
• Where is the fill handle located?
• Cell

Identifies the spreadsheet name.

• Formulas in Excel start with
• Spreadsheet Tab
• Clicking at the tabs at the bottom of a workbook make us ...
• Cell

Labeled with letters within a spreadsheet (vertical)

• Column
• Merge and center
• Where is the fill handle located?
• Clicking at the tabs at the bottom of a workbook make us ...

Labeled with numbers within a spreadsheet (horizontal)

• Cell
• * (star)
• Spreadsheet Tab
• Row

Data, formulas, error or empty

• =sum(A1:A5)
• Formulas in Excel start with
• Contents of cells
• Cell

A group of cells

• Relative reference
• Row
• Range
• Spreadsheets

In the bottom-right-corner of the selected cell

• Where is the fill handle located?
• Contents of cells
• Range
• Clicking at the tabs at the bottom of a workbook make us ...

202 formatted as currency number

• $202.00
• 202
• 202.00
• #202

How do you switch between worksheets?

• By clicking at the tabs at the bottom of a workbook
• Spreadsheet Tab
• Relative reference
• Autofit