LAB 22 Intro to Excel

1) Visit and read  Excel overview at:
 http://www.freeofficetutorials.com/ExcelModule/section1/lesson_1left.html

2) In a blank word document Answer  the following:

   a .   Use the example check register in the lesson (figure 1A1 or 1A2) and calculate what the balance would be after the Jan. 5 cable cheque.

   b .  What would the balance be after the Jan. 7 check?

   c .  Does a deposit increase or decrease the balance?

   d .  What is the name of a slip that you receive from your employer indicating that a deposit has been made to your account?

3) Follow step by step instructions  @:

http://www.freeofficetutorials.com/ExcelModule/section1/lesson_1right.html

4) Answer all questions from A to H

5)Add Header and Footer with you name, period, date and name of substitute teacher.

6) Save your Word file as LAB22YourNamePeriodnumber.

7) Upload file to the dorpbox computer station.

This lab will be grade and counted towards your third marking period grade.

Marking Period 2 Vocabulary Words set #4 due on 4/3/11

1)Aplication Window

2)Dialog Box Launcher

3)Document Window

4)File

5)File Compatibility

6)File Extension

7)Folders

8)I-beam

9)Insertion Point

10)Open a Document

11)Path

12)Ribbon

13)Save a Document

14)ScreenTip

15)Scroll

16)Default Settings

17)Normal.dotm Template

18)Toggle

19)Word Wrap

20)Alignment

21)Clipboard

22)Drag-and-Drop editing

23)Edit

24)First Line Indent

25)Font

26)Format

27)Format Painter

28)Hanging Indent

29)Indent

30)Insert Mode

31)Landscape Orientation

32)Manual Line Break

33)Manual Page Break

34)Margin

35)Overtype Mode

36)Points

37)Portrait Orientation

38)Select

39)Soft Page Break

40)Document Workspace

Marking Period 2 Vocabulary Words set #5 due on 4/10/11

1)Ascending Order
2)AutoShape
3)Banner
4)Blog
5)Boilerplate Text
6)Building Blocks
7)Cell
8)Clip Art
9)Commet
10)Crop
11)Descending Order
12)Desktop Publishing
13)Document Management Server
14)Drawing Obejects
15)Duplex Printing
16)Encryption
17)Fields
18)Footer
19)Graphics
20)Gridlines
21)Hard Copy
22)Header
23)Manual Column Break
24)Markup
25)Merging Cells
26)Metadata
27)Microsoft Word
28)Portable Document Format (PDF)
29)Print Queue
30)Quick Tables
31)Read-Only Document
32)Section Break
33)Sizing Handles
34)Soft Copy
35)Splitting Cells
36)Style
37)Text box
38)Thumbnails
39)Word Processor
40)XML Paper Specification (XPS)

Marking Period 2 Vocabulary Words set #6 due on 4/26/11

1)Absolute Cell Reference
2)Active Cell
3)Argument
4)AutoFill
5)Cell
6)Cell Reference
7)Cell Style
8)Chart
9)Column
10)Column Heading
11)Complex Formulas
12)Embedded Chart
13)Filter
14)Formula
15)Freeze
16)Funtion Formula
17)Graph
18)Grid
19)Header Row
20)Macro
21)Mathematical Functions
22)Microsoft Excel
23)Mixed Cell Reference
24)Operand
25)Operator
26)Order of Evaluation
27)Range
28)Relative Cell References
29)Row
30)Row Heading
31)Sheet Tab
32)SmartArt
33)Split
34)Spreadsheet
35)Statistical Functions
36)Table Style
37)Theme
38)Value
39)Workbook
40)Worksheet

Marking Period 2 Vocabulary Words set #3 due on 3/27/11

1. active window
2. Appearance and Personalization category
3. application file
4. bitmapped graphics
5. cell
6. data file
7. database
8. datasheet
9. directory
10. field
11. file propertoes
12. gadgets
13. hidden file
14. icons
15. multimedia
16. object
17. object linking and embedding (OLE)
18. presentation Software
19. Primary key
20. query
21. quick launch toolbar
22. record spreadsheet
23. Recycle Bin
24. Shortcut
25. Sidebar
26. Software Development
27. Software license
28. software piracy
29. system file
30. system software
31. table
32. text editor
33. update
34. upgrades
35. utility program
36. vector graphics
37. Web applications
38. word-processing software
39. workbook
40. worksheet

Marking Period 2 Vocabulary Words set #2 due on 3/20/11

1. algorithm
2. application software
3. backup
4. beta testing
5. bundleware
6. Cable managment
7. cookie
8. corona wires
9. data theft
10. defragmentaations
11. driver
12. encryption
13. ergonomic keyboard
14. flowchart
15. frangmentation
16. humidity
17. inputting
18. Linux PC
19. maintenence
20. network license
21. operating systems
22. patch
23. ping
24. power spikes
25. problem solving
26. Recycle Bin
27. Sectors
28. Seek Time
29. service pack
30. single-user license
31. software
32. Software as a Service(SaaS)
33. support agreement
34. Surge suppressor
35. Touchpad
36. troubleshooting
37. Uninterruptible power supply UPS)
38. useful life
39. warranty
40. wireless keyboard

Marking Period 2 Vocabulary Words set #1 due on 3/13/11

1. Arithmetic /Logic Unit (ALU)
2. Audio Input
3. Biometrics
4. Centrl Procesing Unit (CPU)
5. Circuit board
6. Computer
7. Control Unit
8. Data
9. Digital Camera
10. Expansion Slot
11. FireWire
12. Hard Disk
13. Hardware
14. Information
15. Inkjet Printer
16. Input
17. Keyboard
18. Laser Printer
19. Memory
20. Mobile Devices
21. Modem
22. Monitor
23. Motherboard
24. Mouse
25. notebook computer
26. Output
27. Plug-and-Play
28. Pointing Device
29. Port
30. Printer
31. Random Access Memory (RAM)
32. Read-Only Memory (ROM)
33. Scanner
34. Server
35. Software
36. Supercomputer
37. Tablet PC
38. Trackball
39. Universal Serial Bus (USB)
40. USB Flash Drive