STA641 Handouts from Slides

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 · Row Numbers · Ribbon Tabs · Formula Bar · Contents of · Active Cell displayed · on Formula Bar · View Buttons Zoom · Sheet Tabs Insert Worksheet · Button · Scroll Bars · Fx Insert · Function · Button · Name Box · Rows · Columns · Cell · D2 · Contai · ns · the · Form · ula · B2*C2 · 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 · 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 · name is not required.