Formatting vs. Rounding Topic 2 Lesson 1 Formatting vs. Rounding Numbers Formatting Formatting changes the way values are displayed, but does not change the actual value being used in functions.

Common formatting options: Currency values Time and date values Numeric formats and decimal points Percent CS1100 Excel Basics

2 Demo: Formatting Unformatted values Formatted values

CS1100 Excel Basics Percen tCurrenc y Accountin g

3 Formatting 2016 2013 2010

CS1100 Excel Basics 4 Conditional Formatting Conditional formatting allows the application to limit

formatting when certain conditions are met. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting CS1100 Excel Basics 5

Rounding Rounding actually changes the value by rounding up or down to some specified accuracy. The rounded value is copied to another cell. To round, use the ROUND() function: =ROUND(A1,2) =ROUNDUP(A1,2)

CS1100 Excel Basics 6 Formatting Example Look Carefully at the Formatting Example

It appears to say that the sum of 3.05 2.02 1.03 is 6.11 That is not mathematically correct! The next slide shows what is actually in each cell. (Control +~)

Formatting Example with CTRL+~ What happened? What happened is that the cells in column A were formatted to show only 2 digits after the decimal point. However, the numbers in column A actually had more than 2 digits after the decimal point. The

last digits were hidden. Hiding some of the digits can yield results that appear to be wrong. Rounding Example Rounding Example with CTRL+~ Rounding Example

The addition in column B is now mathematically correct. The value that appears in cell B5 is in fact the sum of the numbers appearing in cells B1:B3 Warning! The values displayed by a computer application are often not the values that are used inside that application.

If you need a value that has only a certain number of digits after the decimal place, you must round that value, not merely format it. Excel: ROUND(Range, Decimal Places) Bottom Line If a computers arithmetic appears incorrect, it may be a formatting / rounding error. Excel: fix these errors with the ROUND function.

Summary In this module you learned that: rounding is not the same as formatting Excel automatically adjusts cell references when copying formulas CS1100

Excel Basics 16

Recently Viewed Presentations

  • Anthology B Short Stories -

    Anthology B Short Stories -

    Can you find examples of heightened language suggesting his mental state? How is the rhetorical question used in this section? On 129 Lydia is 'immersed in her English book' how does this emphasise the difference between the two characters? ......
  • PowerPoint Presentation

    PowerPoint Presentation

    Peter Topalovic Project Manager, Transportation Demand Management, Hamilton Cumulative Summits have resulted in better understanding of Transportation Systems in Hamilton and Real Action Transportation Summit Review: 2008-2013 Smart Commute Hamilton Expansion Rapid Transit Planning Pedestrian Mobility Plan Complete Streets &...
  • The World of Charles Dickens - Plainview

    The World of Charles Dickens - Plainview

    Tone/Mood- dark, dreary, flat, bit creepy Story begins in counting-house (workplace) of misanthropic Ebeneezer Scrooge Stave One Narrator goes to great lengths to establish facts of Marley's death- reader learns that Scrooge was Marley's only friend in life, only mourner...
  • FIN ERP Transition Session - GL/COA

    FIN ERP Transition Session - GL/COA

    The Chart of Accounts is used to organize our financial information The Chart of Accounts provides all the fields we can choose from to organize and label our financial transactions Examples include Assets, Liabilities, Revenues, Expenses Detailed Departments Specific Funding...
  • Implementing a Queue as a Linked Structure

    Implementing a Queue as a Linked Structure

    Times New Roman MS Mincho Courier New Arial LinkedStacks Implementing a Queue as a Linked Structure Implementing queues using arrays Implementing queues using linked lists Queue class specification Enqueuing (non-empty queue) Enqueuing (empty queue) Function Enqueue Dequeueing (the queue contains...
  • Chapter 1- Section 2 The Development of Sociology

    Chapter 1- Section 2 The Development of Sociology

    Chapter 1- Section 2The Development of Sociology. ... Describe to me your ideal mate. ... Current Perspectives. A theory is a systematic explanation of the relationship among phenomena to guide their work and help interpret their findings . A .
  • Reading Strategies

    Reading Strategies

    Reading Strategies By: Mrs. Berry Tabs on your foldable Predict/Infer Monitor/Clarify Phonics/Decoding (Think About Words) Question Evaluate Summarize Monitor/Clarify Keep track of what you are reading Think about if what you are reading makes sense Reread Read ahead for more...
  • Chapter 14 Integrity & Security - Sacramento State

    Chapter 14 Integrity & Security - Sacramento State

    Pad with blanks at end as necessary Translate each cipher text alphabetic character and the encryption key into an ordinal number For each group, subtract the ordinal number of the key value from the ordinal number of the cipher text...