You will have a test tomorrow!!!!

Make sure you take the practice exam!!!


TaskName
Task Instruction
1.
Absolute Cell Address
With the cursor in the Formula Bar, press the F4 key so that the G3 cell reference becomes absolute $G$3. Then press ENTER.
2.
Add data labels
In the Labels group on the Chart Tools Layout tab on the Ribbon, click the Data Labels button. On the Data Labels menu, click Outside End to add data labels above each column in the chart.
3.
Align Cell Contents
Right align the contents of the range A13:A17 by clicking the Align Text Right button in the Alignment group on the Ribbon.
4.
Chart - Change Type
In the Type group on the Chart Tools Design tab on the Ribbon, click the Change Chart Type button to display the Change Chart Type dialog box. In the Column section of the Change Chart Type dialog box, click the 3-D Cone button. Click the OK button.
5.
Create formulas using the OR function
In the Insert Function dialog box, click the Or select a category: arrow, and click Logical. Then, in the Select a function: list, click OR, and click OK to open the Function Arguments dialog box.
6.
Cut Cells
Click the Cut button in the Clipboard group on the Ribbon to cut the contents of the Total Amount fields that are currently selected.
7.
Delete Cells
Select the range A13:C13, click the Delete arrow on the Ribbon, click Delete Cells, click OK.
8.
Delete Rows
In the Cells group on the Home tab, click the Delete arrow, and then click Delete Sheet Rows to delete the selected row from the worksheet.
9.
Fill Series - Drag and Drop
Fill the range A4:A19 by continuing the series started in the range A2:A3 by positioning the pointer over the fill handle and dragging down to cell A19 before releasing the mouse.
10.
Format - Copy
In the Clipboard group on the Ribbon, click the Format Painter button to copy the formatting of the selected cell.
11.
Format chart data labels
In the Labels group on the Chart Tools Layout tab, click the Data Labels button and then click More Data Label Options. In the Label Options section of the Format Data Labels dialog box, click the Value check box to select it, and click the Percentage check box to deselect it, then click Close.
12.
Format charts
Format the chart area of the New Sales 2010 chart with the Colored Fill - Accent 4 shape style.
13.
Format worksheet tabs
In the Cells group on the Ribbon, click the Format button, point to Tab Color, and click Orange under Standard Colors.
14.
Goal Seek
On the Data tab on the Ribbon, in the Data Tools group, click the What-If Analysis button and use the Goal Seek command to open the Goal Seek dialog box. Use the Goal Seek dialog box to change the value in cell B3 so that the result of the formula in cell H18 is $100,000.00 by typing $100,000.00 in the To value box and B3 in the By changing cell box. Click OK twice to start the analysis.
15.
Indent Cell Contents
In the Alignment group on the Home tab, click the Increase Indent button to increase the text indent of the selected cell.
16.
Insert Cells
Click the Insert arrow in the Cells group on the Ribbon, and then click the Insert Cells command to open the Insert dialog box. In the Insert dialog box, click OK to insert cells in the currently selected Dues Collected 2009 column (H) of the workbook, shifting the existing cells to the right.
17.
Insert Row
In the Cells group on the Ribbon, click the Insert arrow. Click Insert Sheet Rows.
18.
Italicize Cell Contents
In the Font group on the Ribbon, click the Italic button to apply the italic format to the text in cell A2.
19.
Move Cells
To move the contents of cell B9 to cell B10, point to the border of the selected cell B9. When the pointer becomes a move pointer, hold down the left mouse button, drag cell B9 to cell B10, and then release the mouse button.
20.
Number Format - Currency
Apply the Accounting number format to the values in the range E2:E20 by clicking the Accounting Number Format button in the Number group on the Ribbon.
21.
Panes - Freeze
On the View tab on the Ribbon, in the Window group, use the Freeze Panes button to freeze columns A and B in the worksheet so that they will remain visible when the worksheet is scrolled.
22.
Paste Cells
In the Clipboard group on the Ribbon, click the Paste button to paste the last item placed on the Clipboard into the selected range.
23.
Print a chart
To print the New Sales 2010 chart, click the Office button, click Print, and then click OK in the Print dialog box.
24.
Rotate and tilt a 3-D Pie chart
In the Background group on the Chart Tools Layout tab on the Ribbon, click the 3-D Rotation button. Click the up arrow in the X box twice to change the 3-D rotation for the X-axis to 20 degrees, then click the up arrow in the Y box once to set the 3-D rotation for the Y-axis to 40 degrees, and click Close.
25.
Rotate Text
Use the Orientation button in the Alignment group on the Home tab on the Ribbon to change the orientation of the text in the selected cells in the current workbook. Re-orient the text so that it rotates counterclockwise at a 45-degree angle.
26.
Series - Fill Cells
Click the Fill button arrow in the Editing group on the Ribbon and then click Series to open the Series dialog box. In the Series dialog box, click the Month radio button in the Date unit and then click OK to enter the remaining months of the year in the selected cells.
27.
Shading
Click the Fill Color button arrow in the Font group on the Ribbon to display the Fill Color palette. Click the No Fill button on the Fill Color palette to remove the fill from the title cell which is currently selected.
28.
Split a window into panes
Split the window into two horizontal panes so that the top pane's bottom row is row 19 by clicking the View tab, then clicking the Split button in the Window group.
29.
Underline Cell Contents
Click the Underline button in the Font group on the Ribbon to underline the selected cell.
30.
Undo
Click the Undo button on the Quick Access Toolbar to undo the most recent change.
31.
Zoom
Click the Zoom button in the Zoom group on the View tab on the Ribbon to open the Zoom dialog box. In the Zoom dialog box, click the 200% option button and then click OK to change the Zoom setting for the current worksheet to 200%

Congrats!!!!

Click on article to view a larger size.

Points for Excel Chapter 3

You will be graded on the following:

1. Training for Excel Chapter 3
2. In class project
3. Flashcards for Excel Chapter 3, you only have to do 30.
4. In the Lab 1 for Excel Chapter 3. This will be completed with Sam.

Test today for Excel Chapter 2

Hello,

Yesterday I showed you what your exam will look like. If you do not finish the exam in class, you may either finish it at home or you will have 15 mins the next day. If you can't get it done in that amout of time, then you don't know the material. You will get 3 attempts to get the answer correct. Make sure you go back and review your training for this chapter.

Do not cheat! Be good for Mr. Saunders. Mr. Saunders will also write down the names of anyone that is talking during the exam, you will receive a zero. If you finish early go on and start the training for Excel Chapter 3. Make sure you use your headphones.

Calling all tech-savy girls!!!

We’re looking for young women with outstanding achievements and aspirations in computing and technology. Are you the future of technology?

What do winners receive?
Each qualified National winner receives:
» $500 in cash
» a laptop computer, provided by Bank of America
» a trip to attend the Bank of America Technology Showcase and Awards Ceremony, held in Charlotte, North Carolina on March 27, 2010
» an engraved award for both the student and the student’s school
Who is eligible?
» Applicants must be high-school level girls (grades 9-12).
» Applicants must reside in the United States of America.
» Applicants should have a demonstrated outstanding aptitude and interest in IT/computing, and demonstrated leadership ability.
» Applicants should have good academic history, typically a GPA of 3.0 or better.
» Applicants should have post-secondary education plans.
» Students from groups underrepresented in computing and current Juniors/Seniors are strongly encouraged to apply.
» Past applicants including semi-finalists are encouraged to apply, however, previous award-winners are not eligible to reapply or receive any awards.
» Relatives of employees or board members of NCWIT are prohibited from receiving the award.
Howdo Iapply?
Visit www.ncwit.org/award. Applications open on October 7, 2009 for the 2010 National award call. Applicants have until November 15, 2009 to complete their application. Email any questions to aspirations@ncwit.org.
Newthis year – Affiliate awards
There will be Affiliate Award programs in Illinois, Texas and Florida to recognize even more young women. The application period is the same and young women in those states will automatically be entered into both Affiliate and National competitions. Affiliate Award prize packages will vary. The Affiliate Awards are possible through a generous grant from the Motorola Foundation.

Vouchers!

Even though all of the vouchers have been assigned, there are a number of FREE training resources available including:

Microsoft Digital Literacy (Basic Training)
http://www.microsoft.com/about/corporatecitizenship/citizenship/giving/programs/up/digitalliteracy/default.mspx

Microsoft Office 2003 - 2007 (Intermediate Training)
http://office.microsoft.com/en-us/training/default.aspx

Goodwill Community Foundation (Basic and Intermediate Training)
http://www.gcflearnfree.org/computer/

W3Schools.com (IT Professional Training)
http://www.aboutus.org/W3Schools.com

E-Learning Center (IT Professional Training)
http://www.e-learningcenter.com/free.htm

Illinois WorkNet (Job Search & Career Development)
http://www.illinoisworknet.com

Starting with Sam Assessment Software

Go to sam2007.course.com and save it in your favorites. Your username is your login name when you sign into the network at OLCHS. When you first sign in use the password, password1 and then you will be asked to change your password. Make sure you remember it!

Click on My Assigments, and then start the training for Excel Chapter 2.