ExcelChapter6 - Microsoft Office 2007 Excel Chapter 6...

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

View Full Document Right Arrow Icon
Microsoft Office 2007 Excel Chapter 6 Creating Templates and Working with Multiple
Background image of page 1

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

View Full DocumentRight Arrow Icon
Objectives Create and use a template Use the ROUND function Utilize custom format codes Define, apply, and remove a style Add a worksheet to a workbook Create formulas that use 3-D cell references Draw a Clustered Cone chart Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 2
Background image of page 2
Objectives Use WordArt to create a title and create and modify shapes Add a header or footer, change margins, and insert and move a page break Save a workbook as a PDF or XPS file Use the Find and Replace commands Create a workspace Consolidate data by linking workbooks Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Entering Formulas Using Point Mode and Determining Totals in the Template Follow the instructions on pages EX 423 – EX 427 to start Excel and prepare the Template Select cell D5, type = to start the formula, click cell B5, type * (asterisk), click cell C5, and then click the Enter box in the formula bar Select cell E5, type =round(c5/(1-.42),2) , and then click the Enter box in the formula bar to display the formula =ROUND(C5/(1-0.42), 2) in the formula bar and the value 3.45 (3.448276 rounded to two decimal places) as the average unit price in cell E5 Follow the instructions on pages EX 430 – EX 432 to finish entering formulas and values into the worksheet Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 4
Background image of page 4
Entering Formulas Using Point Mode and Determining Totals in the Template Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Saving and Formatting the Template Follow the instructions on page EX 433 – EX 437 to save and format the template Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 6
Background image of page 6
Creating and Assigning a Custom Format Code and a Comma Style Format Select the range C6:G11, right-click the selected range, and then click Format Cells on the shortcut menu When Excel displays the Format Cells dialog box, if necessary, click the Number tab, and then click Custom in the Category list If necessary, scroll down and then click #,##0.00_); [Red](#,##0.00) in the Type list In the Type text box, change the word Red to Blue Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
Creating and Assigning a Custom Format Code and a Comma Style Format Click the OK button to display the numbers in the range C6:G11 using the custom format code created in Step 1 Select the range B5:B12, click the Comma Style button on the Ribbon, and then click the Decrease Decimal button on the Ribbon twice to display the numbers in the range B5:B12 using the Comma style format with no decimal places Select cell A14 Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 8
Background image of page 8
Creating and Assigning a Custom Format Code and a Comma Style Format Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Creating a New Style Click the Cell Styles button on the Home tab
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/27/2012 for the course MISY 2305 taught by Professor Staff during the Spring '08 term at Texas A&M University, Corpus Christi.

Page1 / 62

ExcelChapter6 - Microsoft Office 2007 Excel Chapter 6...

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

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