COMPSCI 1BA3 Study Guide - Income Statement, Dialog Box, Flowchart
3 Apr 2013
School
Department
Course
Professor
Document Summary
Workbooks : excel files: workbooks are made up of sheets. Chart sheets: the sheet open when many are open is your active sheet, rows and columns intersect at cells, which may be identified by their cell reference. In practice, workbooks can be: used and updated by many, very complicated. Multiple worksheets and chart sheets, extensive data. Formulas may be used to populate cells. One work sheet can be the source data for other worksheets or workbooks. Contain macros (some programing code) to automate activities. There are generally multiple ways to do things in excel (mouse, keyboard shortcuts, dialogue boxes, etc. : e. g click tabs ctrl+ pgdn, go to vs name box vs ctrl + g5 vs f5. You can change column width and row height: drag, autofit, properties, multiple selections. You can insert rows or columns anywhere in a worksheet: button, right click. You can delete rows or columns anywhere in a worksheet: button, right click, multiple selections.
