Excel 2007 Unit A

2007 illustrated introductory windows xp edition

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: cells such selection as B5:B14 is called a range range Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Touring the Excel 2007 Window Window Name box and current cell address Open workbook Cell pointer Formula bar Sheet tabs Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Status bar Understanding Formulas • Formulas are equations in a worksheet worksheet • Excel formulas allow users at every Excel level of mathematical expertise to make calculations with accuracy make Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Understanding Formulas • When creating calculations in Excel, When it is important to: it • Know where the formulas should be • Know exactly what cells and arithmetic Know operations are needed operations • Create formulas with care • Use cell references rather than values • Determine what calculations will be Determine needed needed Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Understanding Formulas Viewing a Formula Formula appears in formula bar Result of formula Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Understanding Formulas Understanding Excel arithmetic operators Excel Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Entering Labels and Values and Using AutoSum • Labels contain text and numerical information not used in calculations information • Labels help you identify data in Labels worksheet rows and columns worksheet • You should enter all the labels first You before entering other content before • Values are numbers, formulas, and functions that can be used in calculations calculations Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Entering Labels and Values and Using AutoSum • A function is a built-in formula function • A function includes arguments, the function arguments the information necessary for the calculation calculation • Clicking the AutoSum button sums Clicking the adjacent range above or to the left, though you can adjust the range left, • The Fill button fills cells based on the The first number sequence in the range first Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Entering Labels and Values and Using AutoSum Creating a formula using the AutoSum button AutoSum button Formula Fill button Cells included in formula Microsoft Office 2007-Illustrated Introductory, Windows XP Edition Editing Cell Entries • You can change, or...
View Full Document

Ask a homework question - tutors are online