Spreadsheets Objective 6 01 Demonstrate basic spreadsheet concepts

Spreadsheets Objective 6. 01 Demonstrate basic spreadsheet concepts and functions

Designing a Spreadsheet § WHAT IS A SPREADSHEET? § Rows and columns of data and formulas § Cell - Intersection of a row and column COLUMNS (vertical) A ROWS (horizontal) B C 1 2 *CELL 3 * CELL ADDRESS = B 2 D

Spreadsheets Perform Mathematical Calculations Spreadsheet Applications § § § § Budgets Checkbook Product prices Payroll Financial statements Profit/loss statements Company bids

Daily Uses of Spreadsheets Business Personal/Home • Payrolls • Budgeting • Checkbook • Investments • Car loans • Inventory costs • Household Expenses • Loan Payments School • School Budgets • Student Grades • Payrolls

Spreadsheet Input Operations § Keyboard or Menu Commands § Mouse § Arrow keys § Enter § Alternate Input Devices § § PDA Speech Recognition Tablet PC Virtual Keyboard

Creating a Spreadsheet § Data Types § Labels (left default alignment) § Data expressed in words, symbols, dates, or numbers not used in calculations Thomas Jones January 3 Zip code, SS#, telephone number § Values (right default alignment) § Data expressed in numbers 150 § Formulas § Algebraic format of formulas =A 1+B 1, =(C 4*D 10)+A 3

Data Types Value Label Formula

Basic Spreadsheet Formulas are used for simple mathematical calculations § § Addition Subtraction Multiplication Division =B 7+C 7 =B 7 -C 7 =B 7*C 7 =B 7/C 7

Editing/Insert Row To insert a row between row 1 and 2, active cell must be in row 2 (row below)

Editing/Insert Row When the Insert window appears, click on the "Entire row" selection and click on the OK button.

Editing/Insert Column Right-click and select "Insert" from the popup menu. To insert a column between column A and B, active cell must be in column B (inserts left of column)

Editing/Insert Column When the Insert window appears, click on the "Entire column" selection and click on the OK button.

Deleting Cells, Rows or Columns 1. Select the cells, rows, or columns that you want to delete. 2. On the Home tab, in the Cells group, do one of the following: • To delete selected cells, click the arrow next to Delete, and then click Delete Cells.

Deleting Cells, Rows or Columns To delete selected rows, click the arrow next to Delete, and then click Delete Sheet Rows.

Deleting Cells, Rows or Columns To delete selected columns, click the arrow next to Delete, and then click Delete Sheet Columns.

Formatting Cell Features Types of Cell Formatting § § § § General Number Currency Percentage Text Comma Date

Formatting Cell Features Format from the formatting toolbar. OR … Format from the Format from Format. Menu

Formatting Cell Features

Aligning Data Align Data from the Formatting Toolbar OR …

Aligning Data From the Format Menu

Aligning Data

Aligning Data