STA641 Handouts

Spreadsheets in Excel are referred to as worksheets. · A workbook file may contain may worksheets. · Home · Ribbon · Sizing · Buttons · Help Button · Quick Access · Toolbar · Column Letter · Headings · Ribbon Tabs · Formula Bar · Contents of · Fx Insert · Function · B · Name Box · Row Numbers · Co · e · s o · Active Cell displayed · on Formula Bar · View Buttons Zoom · Sheet Tabs Insert Worksheet · Button · Scroll Bars · Button · Rows · Rows · Columns · Columns · Cell D2 · Contains · Each box is referred to as a “cell”. Cells may contain · Labels, Values or Formulas that result in a value or · label. A cell is identified first by its column letter and · then by its row number · Contains · the Formula · = B2*C2 · Labels · Labels · One can also write formulas that refer to cells on · other worksheets – Sheetname!Cell-Reference · input!B1*input!B3 + A1 · When referencing a cell · on the same · spreadsheet as the · active cell the sheet · active cell the sheet · name is not required.