Basic Spreadsheet Skills Review

1
Basic Spreadsheet Skills Review

• BUS 782

2
Expression
3
Arithmetic Operators

• , -, , /, , ( )
• Evaluating an expression
• Examples
• 4 2 1
• 4 2 3
• 3 4 / 2
• 8 / 4 2
• 2 3 2
• (2 3) 2 3

4
Order of Evaluation

• Operator Multiples
• 1 ( ) Inner to outer, left to right
• 2. left to right
• 3. , / left to right
• 4. , - left to right

5
Formula to Expression
6
(No Transcript)
7
((AB))2
8
Expression to Formula

• A / B C - 2
• A B C D
• (A B / (C 2)) D 1
• Evaluating an expression
• 4 2 8 / 4 2 2 1
• 18 / 3 2 (1 2)

9
Introduction to Excel
10
What is a spreadsheet?

• It is a matrix composed of rows and columns.
  Columns are identified by letters and rows are
  identified by numbers.
• Columns A Z, AA AZ, BA Bz,

11
Cell Range

• Cell Intersection of row and column identified
  by specifying column and row coordinates.
• A1, B3
• Range A group of rectangular shape cells
  identified by specifying the upper left corner
  and the lower right corner.
• B2D3, A1A3

12
Enter Constant in a Cell

• Number
• 2.345, -1000, (1000)
• With comma or 1,234, 1,234.56
• Fraction 1 7/9, 1/3
• Percentage 5.25
• Date mm/dd/yy (without )
• If yy lt 30 ? 20yy. If yygt30 ? 19yy
• Date(2012,9,14)
• Time MinSec
• 1525
• Date and time mm/dd/yy minsec
• Text
• Home/Fill/Series

13
Enter Formula and Function in a Cell

• Formula
• Begin with an
• Use operators , - , , /, , ( ) to define a
  formula.
• Function
• SUM(A1A3)
• Formula with function
• SUM(A1A3) 5 B5/2
• To display formulas
• Formulas/Show Formulas

14
Cell Reference
15
Demo
Note Software consists of three parts INPUT,
PROCESS, OUTPUT.
16
Copy Formula

• Drag the source cell
• Copy/Paste

17
Cell Reference

• Relative cell reference After copy, the formula
  will reference cells with the same relative
  position as the original formula.
• Example
• Value in cell E6 C6D6
• Absolute Cell Reference After copy, the formula
  still references the same cell as the original
  formula.
• Example
• Tax in cell F6 E6C3

18
AnnualGrowthRate 5 of the previous year.
Compute the forecasted sales for the next 5 years
19
(No Transcript)
20
Mixed Cell Reference

• ColumnRow A1
• ColumnRow A1
• Examples
• A1
• A1

21
Cases Where Mixed Cell Reference are Optional
22
Case that Must Use Mixed Cell Reference