**High School ComputerScience – Week 2.5**

**Microsoft Excel – F602 Spreadsheet PowerPoint**

**How to Write a Winning College Application**

**Documentation – F602 Spreadsheet PowerPoint Online**

**Project - RESUME DUE TODAY 2/03/17**

**Homework – F603-01 Use Formula’s, Format & Enhance Data**

**F603-02Use Formulas; Format and Enhance Data;****Copy Formulas; Align Data**

**F603-03Use Functions; Absolute Reference;****Conditional Formatting; Sort**

Computer Memory

**Memory Types (Memory Pyramid)**

CPU Register

Cache

Level 1

Level 2

**RAM(Random Access Memory)**

Physical RAM

Dynamic

**How Stuff Works animations on DRAM and RAS/CAS addressing**

Static

**Virtual Memory (Hard Drive)**

Video Memory

**ROM(Read Only Memory)**

**BIOS(Basic Input/Output System)**

**Removable Memory**

Flash Memory (Flash Drive)

Memory Sticks

RAM Videos

Homework – Memory Quiz Online

Activity F603-01

Use Formulas; Format and Enhance Data

Directions: *Use your spreadsheet program to complete the following spreadsheet:*

- Open invoice
- Enter the new labels Subtotal and Discount in the cell locations shown.
- Calculate the Amount for each item in column F.
- Use Autosum to add the Amounts for the first Subtotal.
- Enter a formula to calculate the tax on the first Subtotal at 7%.
- Use Autosum to add the tax and shipping to the first subtotal amount for the second subtotal.
- Enter a formula to calculate the Total. (No value for Discount)
- Format all money amounts to include a comma and two decimal places; format the Total for currency with a $.
- Center and bold titles and column headings.
- Sort rows 5 through 8 in ascending order based on the item number.
- Place a border around the calculated Total. (You select thickness and color)
- Save the file as invoice2 and email to instructor.

Activity F603-02

Use Formulas; Format and Enhance Data;

Copy Formulas; Align Data

Directions: *Use your spreadsheet program to complete the following spreadsheet:*

- Open payroll.
- Enter the new labels Date and Totals in the exact location shown.
- Calculate gross pay; enter a formula in cell E5 to multiply hourly rate by hours worked.
- Copy the formula in E5 to E6:E11.
- Calculate social security tax: 7.65% of gross pay.
- Copy the formula from F5 to F6:F11.
- Calculate federal withholding tax: 20% of gross pay.
- Copy the formula from G5 to G6:G11.
- Calculate net pay; subtract taxes from gross pay.
- Copy the formula from H5 to H6:H11.
- Calculate Totals: use Autosum to add the values and copy the formula to the appropriate locations.
- Determine the largest and smallest amount of gross and net pay by using the MAX and MIN function as illustrated.
- Format titles and column headings as center, bold, sans serif font.
- Format money amounts in columns with a comma and two decimal places; format totals for currency
- Insert today’s date in A2 in a month, day, year format, bold, and italicize.
- Save as payroll2 and email to instructor

Activity F603-03

Use Functions; Absolute Reference;

Conditional Formatting; Sort

Directions: *Use your spreadsheet program to complete the following spreadsheet:*

- Create the worksheet by entering data and labels as illustrated.
- Enter a formula in F4 to calculate initial stock cost; use the fill handle to fill column.
- Enter a formula in H4 to calculate current market value;Using the current share price given or look up today’s current share price and calculate value with actual data. Fill the formula down.
- Enter a formula in I4 to calculate gain or loss. Fill the formula down and apply a conditional format that will display negative values in red. Click on Format, select Conditional Formatting, and set the condition to display negative values in red.
- Enter a formula in J4 to determine each stocks’ percent of total portfolio value. Fill down. (If an error message occurs, determine what must be done to the formula to correct this.)
- Determine average of columns D through I.
- Determine the highest and lowest values in columns D through J.
- Sort stocks by name in alpha order.
- Merge and center title in 14 point sans serif font, bold.
- Bold and center column headings and labels in A11:A13.
- Format money to two decimals.
- Format total amounts as currency and two decimals.
- Format column J as a percent and zero decimals.
- Save as stock.
- Save in landscape orientation with gridlines and column/row headings. Be sure the document fits on one page.
- Email to instructor.