Lecture Pt 1

Spreadsheets are also known as a worksheet
Contains rows and columns and is used to record and compare numerical or financial data
Found in: accounting, budgeting, sales forecasting financial analysis and scientific fields
Spreadsheets give a person the ability to update data and perform automatic calculation extremely quickly
Spreadsheets are set up in a grid
The intersection of a row and column is called a cell
Rows identified by numbers
Columns identified by letters
Excel has workbooks, several worksheets to a workbook

Lecture Pt 2

Anything typed into a cell is referred to as cell content
Cell content = 2 things: a constant value (known as a value) or a formula
Value is numbers, text, date or times of day
Formula is equation that does mathematical calculation on values
You can change (edit) values or formulas after you have entered the data
To enter text into a cell just click the cell and start typing
When you work with spreadsheets remember to title your rows and columns so you can identify the values in the cells and what they pertain to
Fill Handle – will take information and fill value in the direction you drag
Auto fill generate a series of values into adjacent cells, based on the values in the original cells.
You can spell check in a spreadsheet
When putting in decimals or dollars; excel can round or do a Rounding
If you type 289076.30, excel returns 289076.3
Inserting and deleting rows and columns. Clicking on the column letter or row number will select the entire row or column.
The = sign signals excel to begin a calculation
Underlying Formula = the cells shows the result, the formula bar shows the actual formula. Ctrl + ~ will show the formula in the actual spreadsheet
Sum and AutoSum = Sum adds rows or column. AutoSum looks all around the cell and assumes what you want to do
Excel Number Formats pg 33 and 34 = go over # formats
Merge and center = Merges the selected cells and then applies the center alignment

Lecture Pt 3

Chart = graphic representation of data in a worksheet.
Category labels. Labels that display along the bottom of the chart to identify the category of data “Category axis” or “x-axis”
Excel uses the ROW titles as the category names “Value Axis” or the “Y axis” The is the actual data you are using to make the chart.
Legend – Identified the patters or colors that are assigned to the categories in the chart
Yes you can put a chart on a different sheet
When you have a chart on the same worksheet page, then you have an embedded chart
When using excel formulas, use the following for calculations
Arithmetic Operators
+ is addition
- is subtraction
* is multiplication
/ is division
% is percentage
^ is exponentiation

Fill Color Arrow allows you to use Standard Colors or Theme colors, there is a difference, Standard color is red. Theme Colors is olive green, accent 3, lighter 60%