Ch3_4 - Section 3.4: Formatting a Table Tables 11 are a...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Section 3.4: Formatting a Table Tables 11 are a common use of Excel Formatting a table to look proper is important Tables make it easy to plot data Tables are best when they use relative and fixed references to their advantage Section 3.4: Formatting a Table Previous Next Creating a table the x values 22 The Formula Bar shows the formula in the current cell Formulas start with an = and can be typed in or "pointed in" B5 is a relative cell reference (relative to B6) In this case meaning the cell directly above the current cell $B$1 is a fixed cell reference. Current cell Cell B5 was COPIED and PASTED (using click-and-highlight) into cells B6 to B13 Section 3.4: Formatting a Table Previous Next Creating a table the y values 33 The variables named "a" and "b" are fixed The B4 cell reference is relative Relative cells make copying down columns or across rows easy and accurate Notice that we have renamed the sheet and saved the file Cell C4 was COPIED and then PASTED (using click-and-highlight) into cells C5 to C13 Section 3.4: Formatting a Table Previous Next Improve the formatting Select "Home" tab in menu 44 Place boxes around table cells Center numbers Set precision to 2 Section 3.4: Formatting a Table Previous Next 55 End of Slide Show for Section 3.4 Excel example done in this section tableexample.xlsx Click to edit Master subtitle style This is a good time to work on Exercise 3.4 Section 3.4: Formatting a Table Previous Next 66 End of Slide Show for Section 3.4 Excel example done in this section tableexample.xls Click to edit Master subtitle style This is a good time to work on Exercise 3.4 Section 3.4: Formatting a Table Previous Next ...
View Full Document

This note was uploaded on 05/19/2008 for the course ENGR 25 taught by Professor All during the Spring '08 term at Lehigh University .

Page1 / 6

Ch3_4 - Section 3.4: Formatting a Table Tables 11 are a...

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