Class Notes (1,100,000)
CA (650,000)
McMaster (50,000)
COMPSCI (100)
Lecture

COMPSCI 1BA3 Lecture Notes - Function Key, Microsoft Excel


Department
Computer Science
Course Code
COMPSCI 1BA3
Professor
Dr.Hurst

This preview shows half of the first page. to view the full 2 pages of the document.
September 10-12, 2012
Dr. Nicole Wagner
Excel terminology
- Excel files are called workbooks (.xlsx for 2010)
- A workbook s made up of sheets
- worksheets
- chart 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.
Creative effective Workbooks
- In practice, workbooks can be:
- Used and updated by many people
- Very complicated
- 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
workbooks.
- Contain Macros (some programming code) to automate activities.
- These factors should be considered when planning a new book.
- Good practice:
- Plan out your workbook:
- What problem do you want to solve?
- What data is needed?
- What calculations are required?
- What form should the solution take?
- From these answers determine the worksheets required.
- Include a documentation sheet to describe your workbook.
Navigating in Excel
- There are generally multiple ways to do things in excel (mouse, keyboard shortcuts,
dialogue boxes, etc.)
- E.g. click tabs, Ctrl + PgDn
- E.g. go-to vs. name box
- The first function key F1 is a good tool (arrow) brings up the Help function, search for
shortcuts for things you do often.
Entering Text, Numbers & Dates
- There are three data types:
- Text: a combination of letters, numbers, and some symbols that form words and
sentences.
- Number: any numerical value that can be used in a mathematical calculation
- Date and Time: commonly recognized formats for date and time values
You're Reading a Preview

Unlock to view full version