-
Excel Notes
IF Function (logical test)
- click in cell where answer will go
- formulas tab - logical - IF
- logical test --> type cell to be tested, comparison operator, value (Ex. b2 > 50)
- value if true --> type what will be displayed if true
- type if false --> type what will be displayed if falseCreating Charts
select cells for chart
insert tab - chart group - select type of chartdata elements (click on +)
- chart title
- axis titles
- data labels
- leader lines (click and drag label away from chart to get line to show up)selecting more than one range
- select first range, hold ctrl, select second rangeto move chart
- as an object in - puts the chart on your cells
- a new sheet - puts the chart on its own pageExcel formulas
all formulas start with =
+ add
- subtract
* multiply
/ divide
^ exponent
use ( ) to change the order of operationsConditional Formatting
- Home tab - conditional formatting - highlight cells rulesFormatting
- Home tab - number group
- currency style ($) - formats with a dollar sign, comma, decimal and 2 numbers after
- comma style (,) - formats with a comma, decimal and 2 numbers after
- increase / decrease decimalAutosum (sum, average, maximum, minimum)
- click in the cell where your answer will go
- click arrow next to autosum and select sum, ave, max or min
- use white plus sign to click and drag over cells OR type correct cells in formula