MS+Excel

Excel 2007

=‍ __What is Microsoft Excel and When Would I Use it? __= **Answer:** **Excel is an Electronic Spreadsheet Program** Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. When you look at the Excel screen you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

The intersection point between a column and a row is a small rectangular box known as a cell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell referenceor address to identify it. The cell reference is a combination of the column letter and the row number such as A3, B6, AA345.

**Data Types, Formulas, and Functions** The types of data that a cell can hold include numbers, text or formulas. Just as in math class, formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions.

**Excel and Financial Data** Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include:
 * Performing basic mathematical operations such as summing columns and rows of figures.
 * Finding values such as profit or loss.
 * Calculating repayment plans for loans or mortgages.
 * Finding the average, maximum, or minimum values in a specified range of data.

**Excel's Other Uses** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">Other common operations that Excel can be used for include: <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.
 * <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">graphing or chartingdata to assist users in identifying data trends.
 * <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">sorting and filtering data to find specific information.

<span style="font-family: Arial,Helvetica,sans-serif; font-size: 140%;">__**Getting Started with Excel 2007**__ - Using information from the textbook pages Excel 2- Excel 9, answer the questions on the Word document below. Save document as "Getting Started" and email to teacher. On a separate Excel worksheet complete the "Excel Intro" assignment. Save spreadsheet as "Excel Intro" and email to teacher



EXCEL SPREADSHEET ASSIGNMENTS

__**Work Together:**__
 * Exercise 1-2 Create A Worksheet - pages 218-220
 * Exercise 1-3 Format A Worksheet - pages 221-222
 * Exercise 1-4 Format and Print a Worksheet - pages 223-224

__**Independent Work:**__ Guided Practice 1 - pages 225-226 Save as: Computer Selling Price and email to teacher

EXCEL CUSTOM SPREADSHEET 1 Complete assignment below and save as "Custom Spreadsheet 1" and email to teacher



EXCEL CUSTOM SPREADSHEET 2 Complete assignment below and save as "Custom Spreadsheet 2" and email to teacher

New Skills for this assignment
 * Text Wrap (Home Tab, Alignment Group)
 * Cell/Range Borders (Home Tab, Font Group) - Select cell or range and then apply a border
 * Rename Sheet Tab - double click on Sheet 1 and type in new name for sheet



For Excel Test 1, you need to be able to perform the following skills in MS Excel: Download File: Excel Test 1 Start File.xlsx
 * Enter data
 * Change column width and row height
 * Merge and Center data
 * Apply Wrap text feature
 * Set a print range
 * Apply borders to cells and ranges
 * Rename a worksheet
 * Apply basic formatting to cells
 * font style
 * font size
 * font color
 * underline
 * bold
 * color fill



Download instruction sheet



Learning Excel Formulas - complete the worksheet below as an introduction to using formulas in Excel



Excel Formulas - Day 1 - use the spreadsheet below to practice what you have learned using formulas in Excel



ENTERING FORMULAS ASSIGNMENTS

__**Work Together:**__ Start File - page 229 - Save as "Computer Price Comparison with Formulas"
 * Exercise 2-1 Enter Formulas - pages 229-230
 * Exercise 2-2 Use Functions to Summarize Data - pages 231-233
 * Exercise 2-3 Copy Formulas - pages 234-235



__**Independent Work:**__

Guided Practice 1 - pages 236-237 Start File - page 236 - Save as "Computer Selling Prices with Formulas" and email to teacher.



EXCEL CUSTOM SPREADSHEET 3 - LET'S HAVE A PARTY Complete assignment below and save as "Custom Spreadsheet 3" and email to teacher



EXCEL CUSTOM SPREADSHEET 4 - PLAN A TRIP FOR APRIL VACATION



Excel Test 2 - Entering Formulas

Download the spreadsheet below and save as "Excel Test 2" follow the instructions to modify the spreadsheet and email to your teacher.





CREATING CHARTS IN EXCEL ASSIGNMENT

__**Work Together:**__ Start File - page 245 - Save as "Computer Price Comparison - Column Chart"
 * Exercise 3-3 Create Charts - pages 244-246 (include Sorting)



__**Independent Work:**__ Start File - page 248 - Save as "Computer Price Comparison - Pie Chart" and email to teacher.
 * Guided Practice 1 - pages 248-249 (Do Steps 1-4 on page 248 and Steps 8-11 on page 249)



Unit D - Working with Charts

__** Unit D Objectives **__
 * Plan a Chart
 * Create a Chart
 * Move and resize a chart
 * Change the chart design
 * Change the chart layout
 * Format a chart
 * Annotate and draw on a chart
 * Create a pie chart

Open the Excel workbook below and save **"Quarterly Tour Revenue".** Complete all of the lessons from page Excel 82 to Excel 94. Email your completed workbook to your teacher.



Open the Excel spreadsheet below and save as "Tour Guide Payroll Calculator". Begin on page Excel 4 and complete all of the lessons until page Excel 17. Email your completed spreadsheet to your teacher.



After completing "**Getting Started with Excel**", and Unit A lessons from page Excel 4 to Excel 17, take the quiz on Quia.com called "__Excel Unit A Quiz - Getting Started with Excel - 2018__."

**You may take the quiz twice and the best score will be recorded.**

[|Quia.com]

Unit A - Practice - pages Excel 18 - Excel 24


 * Complete the following activities: **

1. __Skills Review #2-#8__ - page Excel 19 - Excel 20 - Save as "Weather Statistics" and email completed workbook to teacher.



2. __Independent Challenge 2__ - page Excel 21 - Save as "Hot Cars Sales" and email completed workbook to teacher.

3. __Independent Challenge 3__ - page Excel 22 - Save as "Temperature Converter" and email completed workbook to teacher.


 * NOTE: Use an actual formula in your worksheet to converter temperatures from Fahrenheit to Celsius. Go to http://allmeasures.com/temperature.html to find the formula. ** Remember formulas in Excel begin with an equal ("=") sign. **

4. __Visual Workshop__ - page Excel 24 - Save as "Inventory Items" and email completed workbook to teacher.
 * Create the appropriate formula for Total Value (Sale Price times Quantity).


 * ** NOTE: Email two copies of the completed worksheet. One with the formulas not displayed and one with the formulas displayed. Refer to page Excel 16 for information on printing worksheet formulas. **

Unit B - Working with Formulas and Functions

__** Unit B Objectives **__
 * Create a complex formula
 * Insert and type a function
 * Copy and move cell entries
 * Understand relative and absolute cell references
 * Copy formulas with relative cell and absolute cell references
 * Round a value with a function

Open the Excel workbook below and save "**Tour Revenue Analysis".** Complete all of the lessons from page Excel 26 to Excel 40. Email your completed workbook to your teacher.

Unit B Practice - pages Excel 44 - Excel 50

1. Skills Review - pages Excel 44 - Excel 45 - save as "**Candy Supply Company Inventory**" and email completed workbook to your teacher.



2. Independent Challenge 1 - page Excel 46 - save as "**Estimated Diner Expenses**" and email completed workbook to your teacher.



3. Independent Challenge 2 (including Advanced Challenge Exercise) - page Excel 47 - save as "**Pamper Yourself Finances**" and email completed workbook to your teacher.



4. Visual Workshop - page Excel 50 - save as "**Sales Analysis**" and email completed workbook to your teacher.

Unit C - Formatting a Worksheet

__** Unit C Objectives **__
 * Format Values
 * Change font and font size
 * Changes attributes and alignment
 * Adjust column width
 * Insert and delete rows and columns
 * Apply colors, patterns, and borders
 * Apply conditional formatting
 * Name and move a sheet
 * Check Spelling

Open the Excel workbook below and save as "**QST Advertising Expenses**". Complete all of the lessons from page Excel 52 to Excel 68. Email your completed workbook to your teacher.



Unit C - Practice - pages Excel 71 to Excel 78

1. Skills Review - pages Excel 71 - Excel 73 - save as "Health Insurance Premiums" and email completed workbook to teacher.



2. Independent Challenge 1 - page Excel 73 - save as "Lovely Lock Inventory" and email completed workbook to teacher.



3. Independent Challenge 2 - page Excel 74 - save as "South Bend Assistance League" and email completed workbook to teacher.



5. Visual Workshop - page Excel 78 - save as "Top Notch Personnel" and email completed worksheet to teacher.



Unit D - Working with Charts

__** Unit D Objectives **__
 * Plan a Chart
 * Create a Chart
 * Move and resize a chart
 * Change the chart design
 * Change the chart layout
 * Format a chart
 * Annotate and draw on a chart
 * Create a pie chart

Open the Excel workbook below and save **"Quarterly Tour Revenue".** Complete all of the lessons from page Excel 82 to Excel 94. Email your completed workbook to your teacher.



Unit D Practice - pages Excel 97 - Excel 104

1. Skills Review - pages Excel 97 - Excel 99 - save as "**Departmental Software Usage**" and email completed workbook to your teacher.



2. Independent Challenge 1 - pages Excel 99 - Excel 100 - save as "**Springfield Theater Group**" and email completed workbook to your teacher.



3. Independent Challenge 3 (including Advanced Challenge Exercise) - page Excel 102 - save as "**Ad Agency Expenses**" and email completed workbook to your teacher.



4. Visual Workshop - page Excel 104 - save as "**Projected Project Revenue**" and email completed workbbok to your teacher.



Unit D - Working With Charts What you will need to do for quiz?
 * Create a pie and column chart
 * Move and resize chart
 * Move chart to a new sheet
 * Add chart title
 * Add axis titles to column chart
 * Change chart data colors
 * Add annotations (text box) and shapes (arrows) to charts

__Computer Applications - Quarter 3 Study Guide__ - Open the document below and fill in the study guide for Quarter 3. There are terms and skills that you should know about Excel. Your exam will be sometime next week.



Integration - Unit A

__** Unit A Objectives **__


 * Integrate data between Word and Excel
 * Copy data from Excel to Word
 * Copy a chart from Excel to Word
 * Create linked objects
 * Embed a Word file in Excel

Begin on page Integration 4 and open the documents below. Save as "QST Vancouver Survey Data" and complete the lessons from pages Integration 4 to Integration 11. Email completed assignment to your teacher.









Integration Unit A Practice

1. Skills Review - pages Integration 12 - Integration 14 - save as "Language Arts Data" and "Language Arts Report" and email completed documents to your teacher.