Microsoft Office/Excel Basic Exam

VOCABULARY
Use the web site: http://www.scsite.com/ex2007/learn to practice the vocabulary words.

Play the following games for chapters 1, 2, and 3:


 * flash cards
 * Who Wants to be a computer Genius?
 * Wheel of Terms

The Crossword Puzzle for each chapter is extra credit if you can get the whole puzzle filled in.

PROJECT 1
Use the web site: http://lmigateway.coworkforce.com/lmigateway/analyzer/searchAnalyzer.asp?cat=OCC&session=OCCPROJ&subsession=99&time=&geo=&currsubsessavail=&incsource=&blnStart=True to create a spreadsheet that analyzes
 * Colorado
 * 2008-2018
 * Pick 5 -10 occupations (hold down the CTRL key to pick occupations not next to one another in the list).
 * 1) Create a spreadsheet for the employment and openings data for:
 * 2) *Employment 2008
 * 3) *Employment 2018
 * 4) *Use a formula to compute change in employment from 2008 to 2018
 * 5) *Openings due to growth
 * 6) *Openings due to replacement
 * 7) *Use the AutoSum function to create total openings
 * 8) Create a bar or column graph for openings due to growth and replacement for the occupations you have chosen.

PROJECT 2
Pick 5 stocks from the web site: http://www.nasdaq.com/
 * 1) Create a spreadsheet for the following:
 * 2) *List the stock's name
 * 3) *List the stock's symbol
 * 4) *Choose how many stocks you wish to buy (200 - 1000 of each)
 * 5) *Give the date from around 4 years ago that you would have purchased these (pick a date from the history)
 * 6) *List how much it cost then as the initial cost
 * 7) *Compute the initial cost
 * 8) *Give the current cost of the stock
 * 9) *Compute the current value of the stock
 * 10) *Compute the gain or loss
 * 11) *Find the percent gain or loss by taking the gain/loss and dividing by the initial cost.
 * 12) *Use conditional formatting to change the color on any percent gain/loss that is negative.
 * 13) *Add a row at the bottom for totals
 * 14) *Add a row at the bottom for average
 * 15) *add a row at the bottom for highest
 * 16) *add a row at the bottom for lowest
 * 17) Create a Pie Chart for current value of your stocks
 * 18) *do NOT have a legend
 * 19) *Have a title
 * 20) *Use data labels on the wedges for catagories
 * 21) *Use data labels on the wedges for percents

VOCABULARY
http://www.yacapaca.com

>Excel Basics Test

College Admission Requirements Instructions

 * 1) Visit http://www.collegeincolorado.org
 * 2) *Log in
 * 3) *Go to the PLAN tab
 * 4) *Click on the link for Higher Education Opportunities and Admission Requirements
 * 5) *Click on High School Coursework Planner
 * 6) *Click on High School Planner Subjects
 * 7) *Click on Add Higher Education Institution (add at least four colleges or universities)
 * 8) *Click on Summary
 * 9) Create a Spreadsheet of the data for Required and Recommended courses
 * 10) Format the spread sheet professionally, not necessarily how it is shown here
 * 11) Fill in the Total Row
 * 12) Fill in the Average Row
 * 13) Fill in the Total Column
 * 14) Create a Column Chart for the Schools Required and Recommended courses
 * 15) *1 column chart
 * 16) Place the Column Chart on the same sheet as the table of data
 * 17) Create a Pie Chart for each school showing Required Courses
 * 18) *4 pie charts
 * 19) *Do not include column A
 * 20) *Make sure Row 3 has no merged cells
 * 21) *Think about what the pie wedges represent and the value they have.
 * 22) Place the Pie Charts all on one sheet and separate from the table of data - NOT A NEW SHEET

Create a Projected Profit Spreadsheet - Instructions
The FBLA is going to purchase a screen printing machine to start a business of creating shirts for the various teams and clubs of the school. They will need to find an organization to put up the initial cost of $8000 for the machine. They proposal will be to pay back this organization the full amount by making payments of 50% of the profit on each batch/sale. Analyze the data to figure out about how long it will take to pay back the loan.

Create the following Table:
 * 1) Fill in the estimated number of shirts each group would sold for year 1.
 * 2) Compute the number of shirts sold for year 2 = prior year *(1+sales growth)
 * 3) *Compute the rest of the years sales with the same basic formula
 * 4) *You might have to have more than 5 years to pay this off
 * 5) *Make sure you look at your absolute and relative references on your formulas
 * 6) Find the total shirts sold for each year
 * 7) Compute the Total Profit = total shirts sold * Markup per shirt
 * 8) *Make sure you look at your absolute and relative references on your formulas
 * 9) Compute Amount Paid back to Donator = 50% of Profit
 * 10) *Make sure you look at your absolute and relative references on your formulas
 * 11) Compute Running Total Paid Back = Running Total Paid Back previous year plus Amount Paid Back this year
 * 12) *You will need to think on your own
 * 13) *Logically how much do you have paid back the first year?
 * 14) *Logically how can you find out how much is paid back the first two year?
 * 15) *What can your formula be so you can use the fill handle?
 * 16) *Make sure you look at your absolute and relative references on your formulas
 * 17) Compute Total left on Loan = Original cost of the Equipment - Running Total Paid Back
 * 18) *Make sure you look at your absolute and relative references on your formulas
 * 19) Create a Conditional Formatting on the Left on Loan to change the color of font and fill color when the value goes negative.
 * 20) Print the spreadsheet on one page
 * 21) Print the Formula View to one page
 * 22) Adjust the Assumptions to figure out how the loan could be paid off in one less year.
 * 23) *You may not change that the equipment costs $8,000.00
 * 24) Print the spreadsheet on one page