Computer Applications W2008
Computer Applications – 4/16/08
Objective: Create an amortization table using the PMT function. Organize data using multiple sheets in a workbook. I. Bellwork (Pg 275) A. What is an amortization table? B. What is the PMT function and what form does it take? II. Classwork A. Loan Pgs 275-277 (Follow Directions for Part 8 & Print it out.) B. Car Sales […]
Computer Applications – 4/15/08
Objectives: Use text in the IF function. Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I. Bellwork A. Explain the difference between the merge and centering formatting option and centering B. Explain the difference between clicking the currency style button on the toolbar and selecting Format-Cells-Number-Currency- 2 decimal places. II. Notebook Work A. Writing Activity […]
Computer Applications – 4/14/08
Objective: Use the IF function. Change the print orientation and margins of a worksheet. I. Bellwork A. Draw the following buttons from the Excel toolbars Increase Decimal Decrease Decimal Increase Indent Decrease Indent II. Classwork A. Exercise 9 Chapter 10 B. Exercise 10 Chapter 10 C. Exercise 11 Chapter 10
Computer Applications – 4/11/08
Objectives: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I. Bellwork – Questions & Answers Write a formula to sum cells B3 through B1o. Write a formula to subtract cell E2 from cell D2. Write the formula to add cells A5, B5 and C5. Write a formula to divide cell C5 by cell D5 II. Classwork A. Micro Type Pro […]
Computer Applications – 4/10/08
Objectives: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I. Bellwork – Questions & Answers Write a formula to divide cell B3 by cell C3. Write a formula to multiply cell A2 by cell B2. Write the formula to Average the cells A5 to G5. Write a formula to substract cell D3 from cell C3 […]
Computer Applications – 4/09/08
Objectives: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I. Bellwork – Questions & Answers In Excel what is the symbol for multiplication? In excel what is the symbol for division? What must all formulas start with? Write the formula to SUM the cells A5 to G5. II. Classwork A. Page 274 Hotel Occupancy […]
Computer Applications – 4/08/08
Objective: Use the IF function. Change the print orientation and margins of a worksheet. Print part of a worksheet. Use text in the IF function. I. Bellwork Work A. pg 285 #17 a, b, c II. Notebook Work – MI Declining Industries A. Based on the chart answer the following questions What does this chart demonstrate? Which declining […]
Computer Applications – 4/07/08
Objectives: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions. Sort the data in a spreadsheet. Insert and delete rows and columns. I. Bellwork A. Page 285 #15a & b Questions and Answers (See pg 268) II. Classwork A. Pages 265-266 Mileage Summary – Print B. Page 267 Hotel Occupancy Part I C. Page 269 Hotel Occupancy […]
Computer Applications – 4/04/08
Objective: enter and edit data in worksheet insert functions into formulas I. Bellwork A. Pg 285 Questions and Answers #13 & #14 II. Classwork A. Exercise 4 Chapter 10 – Print B. Pages 265-266 Mileage Summary – Print III. Micro Type Pro E-H due next week
Computer Applications – 4/03/08
Objective Use functions enter and edit data in worksheet use formulas to perform calculations I. Bellwork A. Draw the following buttons from the Excel toolbars Merge and Center Spelling Sort Ascending Format Painter AutoSum II. Notebook Work A. Click Here – Pie Chart 1 Questions B. Write Questions 1-5 in your notebook and the answers III. Classwork A. […]