Skip to main content
≡
Pearson Logo
Sign in
Your cart

The Microsoft Press Store by Pearson

  • Topics
    • AI & Machine Learning
    • Azure
    • Certification & Training
    • Data Analytics & Excel
    • Microsoft Office
    • Windows
    • Programming
    • Software Engineering
    • All topics
  • Formats
    • Books
    • eBooks
    • Practice tests
    • Videos
  • Series
    • Best Practices - Developer
    • Best Practices - IT Pro
    • Business Skills
    • Developer Reference
    • Exam Ref
    • Inside Out
    • MOS Study Guide
    • Step by Step
    • Step by Step for Developers
    • All series
  • Authors
  • Specials
  • More
    • About
    • Contact us
    • Distribution & sales
    • Newsletter
    • Register your book
    • Sample chapters
    • Support
    • Write for us
  1. Home
  2. Sample chapters

Perform calculations on data

  • By Curtis Frye
  • 4/9/2019
Contents
×
  1. Name groups of data
  2. Name groups of data
  3. Create formulas to calculate values
  4. Create formulas to calculate values
  5. Summarize data that meets specific conditions
  6. Summarize data that meets specific conditions
  7. Set iterative calculation options and enable or disable automatic calculation
  8. Set iterative calculation options and enable or disable automatic calculation
  9. Use array formulas
  10. Use array formulas
  11. Find and correct errors in calculations
  12. Find and correct errors in calculations
  13. Skills review
  14. Skills review
  15. Practice tasks
  16. Practice tasks
  • Back
  • Page 13 of 16
  • Next

Skills review

In this chapter, you learned how to:

  • Name groups of data

  • Create formulas to calculate values

  • Summarize data that meets specific conditions

  • Set iterative calculation options and enable or disable automatic calculation

  • Use array formulas

  • Find and correct errors in calculations

Save to your account
  • Back
  • Page 13 of 16
  • Next

This chapter is from the book

Microsoft Excel 2019 Step by Step

Microsoft Excel 2019 Step by Step

  • Learn more Buy

Related resources

  • Titles
  • Chapters
Complete Guide to Next Gen Excel Formulas for Data Analysts (Video)

Complete Guide to Next Gen Excel Formulas for Data Analysts (Video)

  • By Alan Murray
  • Online video $119.99
Exam DP-700 Implementing Data Engineering Solutions Using Microsoft Fabric (Video)

Exam DP-700 Implementing Data Engineering Solutions Using Microsoft Fabric (Video)

  • By Andy Cutler
  • Online video $119.99
GitHub Copilot Step by Step: Navigating AI-Driven Software Development

GitHub Copilot Step by Step: Navigating AI-Driven Software Development

  • By Gomathi S.
  • eBook $35.19

See related titles

  • About
  • |
  • Contact us
  • |
  • Cookies
  • |
  • Privacy
  • |
  • Do Not Sell My Personal Information
  • |
  • Terms of use
  • © 2026 Pearson. All rights reserved, including those for text and data mining and training of artificial intelligence and similar technologies.