Friday, October 31

Happy Halloween!

Essential Question:
Why should you be able to use Excel to create a worksheet for budgeting and other financial purposes?
Key Questions:

How do you enter a formula using the keyboard/ How do you enter formulas using point mode? How do you copy formulas using the fill handle? How do you determine averages of numbers in a range? How do you determine the highest number in a range? How do you determine the lowest number in a range? How do you copy a range of cells across columns to an adjacent range using the fill handle? How do you verify a formula using range finder? How do you change the workbook theme? How do you change the background color and apply a box border to the worksheet title and subtitle? How do you format dates and center data in cells? how do you apply accounting number format and comma stlye format using the ribbon? How do you apply currency style format with a floating dollar sign using the format cell dialog box? How do you apply a percent style format and use the increase decimal button? How do you apply conditional formatting? How do you change the width of columns? How do you change the height of rows? How do you use Spell Check? How do you change the worksheet's margins, header, and orientation in page layout view? How do you print a section of the worksheet? How do you display formalus in the worksheet and fit the printout on one page?

Activating Strategy:
Begin working on assigments below
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Students will complete M&M Excel Spreadsheet Test (counts as a test grade!)
  • Wait for specific instructions from your teacher
Summarizing Strategy:

Answer Key questions above

Observation, TOD

Previous Lesson | Next Lesson
Back to Intro. to Business & Technology Calendar | Back to Miss Rock's Homepage


Introduction to Business & Technology | Business Communications

Computer Applications 1 | Computer Applications 2

Computing in the Modern World | Fundamentals of Web Design | Advanced Web Design

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact


Updated August 2014


Disclaimer: This site provides external links as a convenience to my users. The appearance of external hyperlinks on this website does not constitute endorsement by me of the linked websites, or the information, products or services contained therein. I do not exercise any editorial control over the information you may find at these locations.

Introduction to Business & Technology Computer Applications 2 Business Communications Computing in the Modern World Fundamentals of Web Design Advanced Web Design Animation & 3-D Design