2007 illustrated introductory windows xp edition

Info icon This 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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern