Organized new perspectives on microsoft excel 2010 32

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: tions is the way lookup tables are organized New Perspectives on Microsoft Excel 2010 32 XP Using the IFERROR Function XP • Error value – Indicates that an element in a formula or a cell referenced in a formula is preventing Excel from returning a calculated value – Begins with a number sign (#) followed by an error name that indicates the type of error New Perspectives on Microsoft Excel 2010 33 Excel Error Values • XP XP Excel error values are not particularly descriptive or helpful New Perspectives on Microsoft Excel 2010 34 XP Using the IFERROR Function XP • • • • Displays a more descriptive message that helps users fix the problem Can determine if a cell contains an error value and then display the message you choose rather than the default error value Enables you to easily find and handle formula errors Syntax: New Perspectives on Microsoft Excel 2010 35 XP Using the IFERROR Function XP New Perspectives on Microsoft Excel 2010 36 Visual Overview New Perspectives on Microsoft Excel 2010 XP XP 37 Conditional Formatting New Perspectives on Microsoft Excel 2010 XP XP 38 Conditional Formatting • • XP XP Changes a cell’s formatting when its contents match a specified condition Can be used to: – Highlight cells based on their values – Add data bars that graph relative values in a range – Highlight duplicate values in a column of data New Perspectives on Microsoft Excel 2010 39 Using the Conditional FormattingP XP X Rules Manager • • A conditional formatting rule specifies: – Type of condition – Type of formatting when that condition occurs – Cell or range the formatting is applied to Use Conditional Formatting Rules Manager dialog box to edit existing conditional formatting rules New Perspectives on Microsoft Excel 2010 40 Using the Conditional FormattingP XP X Rules Manager New Perspectives on Microsoft Excel 2010 41 Using the Conditional FormattingP XP X Rules Manager New Perspectives on Microsoft Excel 2010 42...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online