COMPSCI 1BA3 Lecture Notes - Function Key, Microsoft Excel
Document Summary
Contain macros (some programming code) to automate activities. Multiple worksheets and chart sheets, extensive data. Formulas may be used to populate cells. One worksheet can be the source data for other worksheets or even. Excel files are called workbooks (. xlsx for 2010) A workbook s made up of sheets. Can have multiple workbooks and sheets open at once, the one you"re working n is active. Rows and columns intersect at cells, which may be identified by their cell reference. These factors should be considered when planning a new book. From these answers determine the worksheets required. Include a documentation sheet to describe your workbook. There are generally multiple ways to do things in excel (mouse, keyboard shortcuts, dialogue boxes, etc. ) The first function key f1 is a good tool (arrow) brings up the help function, search for shortcuts for things you do often. Text: a combination of letters, numbers, and some symbols that form words and.