Digital Communication Systems Spreadsheet Fundamentals Spreadsheet a program

Spreadsheet. . . a program that allows you to use ROWS and COLUMNS of

Advantages of Computer Spreadsheets n Fast and Accurate n Can answer “What Is…. ?

Can Answer “What Is…. ? ” § students’ current grade (school) § individual athlete

Can Answer “What If…. ? § student population increases (school) § win/loss record changes

Uses of Computer Spreadsheets n School n n student grades payroll class sizes schedules

Uses of Computer Spreadsheets, cont’d n Personal n n checkbook household expenses investments income

Uses of Computer Spreadsheets, cont’d n Government n n n Taxes Census Loans Investments

Spreadsheet Terms n n Active Cell - The cell ready for data entry. Alignment

Spreadsheet Terms, cont’d. n n Cell reference - The column letter and the row

Spreadsheet Terms, cont’d. n n Label - Text, symbols, dates, or numbers not used

Spreadsheet Terms Cell (B 3) Intersection of a row and a column Value A

More Terms Range (B 4: B 8) A block of cells Sum…. Adds the

Slides: 13

Download presentation

Digital Communication Systems Spreadsheet Fundamentals

Spreadsheet. . . a program that allows you to use ROWS and COLUMNS of data to manage, predict, and present information. ROW COLUMN

Advantages of Computer Spreadsheets n Fast and Accurate n Can answer “What Is…. ? ” n Can Answer “What If…. ? ”

Can Answer “What Is…. ? ” § students’ current grade (school) § individual athlete statistics (sports) § transportation schedules (business) § current $ available for spending (personal) § census results

Can Answer “What If…. ? § student population increases (school) § win/loss record changes (sports) § product sales decrease (business) § hourly wage rate changes (personal)

Uses of Computer Spreadsheets n School n n student grades payroll class sizes schedules n Sports n n individual and team statistics current and future budgets

Uses of Computer Spreadsheets, cont’d n Personal n n checkbook household expenses investments income taxes n Business n n n payroll investments inventory product sales delivery

Uses of Computer Spreadsheets, cont’d n Government n n n Taxes Census Loans Investments budgets

Spreadsheet Terms n n Active Cell - The cell ready for data entry. Alignment - When data is entered into a cell, the default alignment is labels to the left and values to the right. Cell - Intersection of a row and column and is identified by a cell reference. Cell range - A selected group of cells that form a rectangle

Spreadsheet Terms, cont’d. n n Cell reference - The column letter and the row number. Example: B 12 Column - Identified by letters that appear at the top of the spreadsheet. (Vertical) Formula - Equations with symbols for math operations. Example =B 6+B 7+B 8+B 9 Function - Special formulas that do not use operators to calculate a result. i. e. A shortcut formula. Example: =sum(A 6: A 9)

Spreadsheet Terms, cont’d. n n Label - Text, symbols, dates, or numbers not used in calculations. Rows - Identified by numbers on the left side of the spreadsheet. (Horizontal) Spreadsheet - A program that allows you to use rows and columns of data to manage, predict, and present information. Value - A number entered into a spreadsheet cell that will be used for calculations

Spreadsheet Terms Cell (B 3) Intersection of a row and a column Value A number entered on a spreadsheet and used for calculations Label Text, Symbols, dates, or numbers not used in calculations Formula An equation with symbols for math operations B 4+B 5+B 6+B 7+B 8

More Terms Range (B 4: B 8) A block of cells Sum…. Adds the range Average…. averages the range Functions Shortcut formulas Sum(B 4: b 8)