WHAT IF? Columns run vertically & are identified by letters A, - - PowerPoint PPT Presentation

▶

Jan 23, 2024 292 likes •548 views

An application program that can quickly handle calculations A spreadsheet uses numbers like a word processor uses words. WHAT IF? Columns run vertically & are identified by letters A, B, etc. Rows run horizontally & are

SLIDE 1

SLIDE 2

An application program that can quickly handle calculations A spreadsheet uses numbers like a word processor uses words.

SLIDE 3

WHAT IF?

SLIDE 4

Columns run vertically & are

identified by letters A, B, etc.

Rows run horizontally & are

identified by numbers 1, 2, etc.

SLIDE 5

SLIDE 6

The intersection

f a column &

row.

SLIDE 7

Coordinates of a cell

SLIDE 8

The cell that is currently being worked on.

SLIDE 9

Where you can see what information is actually typed in the cell.

SLIDE 10

Labels: words.
Values: Numbers like 78 or $1.60
r 5%.
Formulas: equations

–starts with an =

SLIDE 11

SLIDE 12

1. Columns and Rows can be re-sized.
2. Set decimal points.
3. Set %.
4. Set $.
5. Cut, copy, paste rows & columns.
6. Insert rows and columns.
7. Connects numbers to other numbers.
8. Graphs and Charts.

SLIDE 13

Freezing Panes

Freezing Panes – a method to keep cells frozen in view even when scrolling. View Menu.

SLIDE 14

Notes: Microsoft Excel - Spreadsheets

Function Formulas – Preset formulas like =sum(D1:D6) =average(D1:D6) =min(D1:D6) =max(D1:D6) Template - A file that serves as a starting point for a new

document. It is pre-formatted in some way.

Basic Math operators in a SS: + adding

subtraction

* multiply / division ( ) parenthesis Demo – Fill down with dates and numbers.

SLIDE 15

Other SS Terms

Freezing Panes – a method to keep cells in view even when scrolling. Range – a block of cells. Contiguous Range – block of adjacent cells. Noncontiguous Range – block of cells not adjacent (not near each other).

SLIDE 16

Workbook – an Excel file, made up of individual worksheets. Worksheet – each individual spreadsheet in a workbook file. Sheet Tab – current worksheet being displayed F2 – This key allows you to edit a cell. Fill-down – term for copying a formula down or across a range of cells by dragging the cell handle. Sort – putting the date in some type of order. Total Cost =Price * Quantity

Microsoft Excel - Spreadsheets

SLIDE 17

Spreadsheet Terms

Function – built-in formula to perform calculations like =SUM, = AVERAGE, =MIN, =MAX Workbook – an Excel file, made up of individual workbooks. Chart – A graphic that allows you to compare and contrast data in a visual format. Data Series – the data selected to be visualized in a chart.

SLIDE 18

Notes: Microsoft Excel - Spreadsheets

NOTES: Chart – A graphic that allows you to compare and contrast data in a visual format. Data Series – the data selected to be visualized in a chart. Types of Charts: Pie Column Bar Bar Line

Jan. 18, 2011

SLIDE 19

Notes: Microsoft Excel - Spreadsheets

NOTES: Sheet tabs – Labels located at the bottom of the workbook window indicating the worksheets. Sort – In a database, this function puts the records into a specific order. Sheet tabs – Labels located at the bottom of the workbook window indicating the worksheets.

Jan. 19/20, 2011

SLIDE 20

Topic: Budgeting for Business EQ: How can I use spreadsheets in budgeting

f a business?

Budgeting - allocation of monetary funds based

n a determined structure

Profit – the difference between what you sold your item for and how much you originally paid for it. Gross Profit - the amount of income received before subtracting expenses. (higher amt) Net Profit - the amount of income after costs of goods and taxes are deducted. (lower amt)

SLIDE 21

Topic: Budgeting for Business EQ: How can I use spreadsheets in budgeting of a business?

Gross Pay - The total of an employee's regular pay, before

any deductions are made.

Net Pay - The remaining amount of an employee's gross

pay after deductions, such as taxes and retirement, are made.

Deduction – expenses which are subtracted out of a

paycheck or business budget (taxes, retirement, insurance).

Deposit – Funds placed into an account to increase the

balance of the account.

SLIDE 22

Topic: Budgeting for Business EQ: How can I use spreadsheets in budgeting of a business?

Income Tax – government imposed tax on a person’s income. Social Security - tax on both employers and employees used to fund the Social Security program. FICA Tax - tax imposed on both employees and employers to fund Social Security and Medicare.

SLIDE 23

Topic: Stock Market EQ: What is the stock market? How do I track the value of my stocks?

Do you or your parents own stock(s)? If so, what are they? Please share. What company would you like to own stock in? Definitions: Stocks – small pieces of a company that a person can own. Stock market - The market that people use to trade (= buy and sell) shares Share holder – One of many owns of the company. Stock Cartoon RAP

SLIDE 24

Stock market indicators:

Dow Jones Industrial Average (DJIA) – follows average stock prices of 30 of about 3000 stocks on the New York Stock Exchange. S&P 500 – Looks at the market value of 500 different stocks. Nasdaq – tracks the prices of more than 3000 stocks.