Lecture+23+-+Excel+Examples

Lecture+23+-+Excel+Examples - foo bar baz bat one,two,three...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
foo bar baz bat one,two,three Import From Text File: Test.csv If you enter in comma, tab, space or other delimitted text you can use the Data > Tex to Columns function to automatically populate columns You can also import text files that have an appropriate format into an excel sheet. For example, tab and comma-separated files.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1 Mon 2 Tue After Auto Filling the first column you can just highlight Column B's range and double click on the drag handle. It will Auto Fill to column A's height
Background image of page 2
one a two b three c one a two b three c one a two b three c 1. You can select a range of cells by clicking on one cell and then "shift+clicking" on a different cell 2. You can select all cells in a given data set by clicking within that data set and then typing CTR+SHIFT+* 3. You can also select ranges of cells using the SHIFT key and the ARROW keys 4. To return to the top of a spreadsheet you can type CTR+SHIFT+HOME to go to the end of a sheet you can type CTR+SHIFT+END
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Rounding Sample $2,123.12 "2 places" 100ths $2,123.12 $2,124.12 "1 places" 10ths $2,124.10 $2,125.12 "0 places" 0ths $2,125.00 $2,126.12 "-1 places" tens $2,130.00 $2,127.12 "-2 places" hundreds $2,100.00 $2,128.12 "-3 places" thousands $2,000.00
Background image of page 4
Straight up, lookup The lookup table 2.17 Density Viscosity Temperature 0.457 3.55 500 0.525 3.25 400 0.616 2.93 300 0.675 2.75 250 0.746 2.57 200 0.835 2.38 150 0.946 2.17 100 1.09 1.95 50 1.29 1.71 0 Advanced Lookup Study: To the Left, To the Left. In a box to the left
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/17/2011 for the course BUSINESS 198:170 taught by Professor Staff during the Spring '09 term at Rutgers.

Page1 / 14

Lecture+23+-+Excel+Examples - foo bar baz bat one,two,three...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online